Forum Discussion

Icon for Post Prodigy rank

Post Prodigy

6 years ago

Solved

Perfomance based on Quartile

I have the attriton Data based on Team Manager and country. I need to find the quartile and based on that we need to see whcih quartile the TM falls under. Fotr this i need a formula that will calcul...

Anonymous
6 years ago
Hi unnijoy ,

You can also use the attached file for Visulaization.

https://drive.google.com/open?id=12XyFQmI9bZpSXy08lgMc8EpVuwQQ42ZG

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

Icon for Community Champion rank

Community Champion

6 years ago

After going through this excercise, I'm not sure I trust Excel's QUARTILE function and by proxy PERCENTILE.INC and PERCENTILE.EXC they seem to come up with different results than everything else I have read on Quartiles...