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{1, 2, 3, 4, 5, 6, 7, 8, 9, 10}, p=90\left\{ 1,\ 2,\ 3,\ 4,\ 5,\ 6,\ 7,\ 8,\ 9,\ 10 \right\},\ p = 90

9.1\displaystyle 9.1

Position in the ordered list

9.1\displaystyle 9.1
Show the work
  1. Sort the data

    Write the values in order from smallest to largest, so positions in the list are easy to count. The smallest is 11 and the largest is 1010.

    1, 2, 3, 4, 5, 6, 7, 8, 9, 101,\ 2,\ 3,\ 4,\ 5,\ 6,\ 7,\ 8,\ 9,\ 10
  2. Rank of the percentile

    This uses the PERCENTILE.INC method, as in Excel: the smallest value has rank 0 and the largest has rank n−1n - 1, so the ppth percentile sits at the fraction p100\frac{p}{100} of the way along. Here n=10n = 10.

    rank=p100(n−1)=90100×(10−1)=8.1\begin{aligned} \text{rank} &= \frac{p}{100}\left(n - 1\right) \\ &= \frac{90}{100} \times \left(10 - 1\right) \\ &= 8.1 \end{aligned}
  3. Percentile by linear interpolation

    The rank falls between positions k=8k = 8 and k+1=9k + 1 = 9 of the ordered list (counting from 0), at a fraction f=0.1f = 0.1 of the way from xk=9x_k = 9 to xk+1=10x_{k+1} = 10.

    P=xk+f(xk+1−xk)=9+0.1×(10−9)=9.1\begin{aligned} P &= x_k + f\left(x_{k+1} - x_k\right) \\ &= 9 + 0.1 \times \left(10 - 9\right) \\ &= 9.1 \end{aligned}
  4. Result

    So the 90th percentile is 9.19.1.

Worked examples