Percentile Calculator
Find the value at any percentile of a data set, or the percentile rank of a given value.
About the Percentile Calculator
Paste your data and enter a percentile, or a value to find its percentile rank. The calculator gives the percentile value, the median and the position used.
The p-th percentile is the value below which p% of the data falls. Percentile ranks are used for test scores and child growth charts: scoring in the 90th percentile means you did better than about 90% of people.
The formula
Position h = (n − 1) × p ÷ 100; value = x⌊h⌋ + (h − ⌊h⌋)(x⌈h⌉ − x⌊h⌋)
- Method
- Excel PERCENTILE.INC / R type 7
- Rank
- (values below + ½ × values equal) ÷ n
Worked example
Ten values from 12 to 41; the 90th percentile
- Position: (10 − 1) × 0.9 = 8.1 in the sorted list
- Between the 9th value (35) and 10th (41)
- = 35 + 0.1 × 6 = 35.6
Questions people ask
Is percentile the same as percentage?
No. 80% is a score; the 80th percentile is a position relative to everyone else.
What's the 50th percentile?
The median.