Percentile Calculator

The value at any percentile of a data set, and the percentile rank of any value.

Sort the data and find the rank r = p × (n − 1) + 1, interpolating between neighbours. For 15 test scores, the 90th percentile rank is 0.9 × 14 + 1 = 13.6, between the 13th (88) and 14th (90) scores: 88 + 0.6 × 2 = 89.2.

Free, runs in your browser. Nothing you enter is uploaded.

How to use it

Paste your data set.
Enter the percentile you want, or a value to rank.
Read the result by both common methods and the summary percentiles.

What you enter

Data set
Percentile or value

What you get

Value at the percentile
Nearest-rank value
Percentile rank
Summary percentiles

Formula

Position = p(n − 1) + 1 (PERCENTILE.INC) | Percentile rank = (below + 0.5 × equal) / n × 100

Worked example: class scores

Input: 15 scores from 62 to 93; 90th percentile; rank of 84

Result: 90th percentile 89.2; 84 is at the 63rd percentile

A score of 84 beat about 63% of the class.

Questions

How do you calculate a percentile?

Sort the values, compute the position p(n − 1) + 1 and interpolate between the two values around that position. Other methods round to the nearest rank instead, so small data sets can give slightly different answers.

What is a percentile rank?

The percentage of values below a score, counting ties as half. Scoring at the 80th percentile means you did better than about 80% of the group.

Is the 50th percentile the median?

Yes. The 25th and 75th percentiles are the first and third quartiles.

Is percentile the same as percentage?

No. A percentage is a share of the maximum (85% on a test); a percentile compares you with other people.

More Statistics

All free tools · By Dr. Zubair Khalid, DVM, MS, PhD.