🔢Percentile
Also known as Percentile Rank, Quartile
Where a value ranks out of 100. The 90th percentile beats 90% of the rest.
Think of it like
It is like a race with 100 kids. Beat 90 of them and you are in the 90th percentile.
Example
Jack's baby is heavier than 75 of every 100 babies the same age. The doctor says he is on the 75th percentile.
Why it matters
Test results, child growth and page speed are often given as percentiles. They show where one value sits in the crowd.
Definition
Example code
excel
=PERCENTILE.INC(B2:B101, 0.9)Common mistake
Key takeaways
- 1Rank, not score. Where you sit in the line.
- 2The 50th is the median. The very middle of the line.
- 3Quartiles cut in four. The 25th, 50th and 75th.