Percentile Calculator
Enter your data and a percentile, or a value to find its percentile rank.
Numbers separated by commas, spaces or new lines
A number from 0 to 100, such as 90 for the 90th percentile.
Try
Result
You entered
Position in the ordered list
Show the work
Sort the data
Write the values in order from smallest to largest, so positions in the list are easy to count. The smallest is and the largest is .
Rank of the percentile
This uses the PERCENTILE.INC method, as in Excel: the smallest value has rank 0 and the largest has rank , so the th percentile sits at the fraction of the way along. Here .
Percentile by linear interpolation
The rank falls between positions and of the ordered list (counting from 0), at a fraction of the way from to .
Result
So the 90th percentile is .