Percentile Calculator
Find the percentile rank of a value in a list of numbers, or the value at any percentile, with the working shown.
Percentile of 82
56.7th percentile
- Numbers below it
- 8 of 15
- At or below it
- 60%
82 is at the 56.7th percentile: it beats 8 of the 15 numbers and ties with 1.
How it's worked out
- Count below and equal
8 below, 1 equal15 in all - Percentile rank
(8 + ½ × 1) ÷ 15 × 10056.67
- Counting half of the tied values is the usual school and testing method. Some reports count all ties instead, which gives the 'at or below' figure.
Percentile rank
Percentile rank = (values below + ½ × values equal) ÷ count × 100
A value at the 75th percentile is higher than about three quarters of the list. Counting half of the tied values keeps the rank fair when several people share a score.
The value at a percentile
Position = p × (n − 1) + 1
When the position falls between two values, the calculator moves the same fraction of the way from one to the next. This is the inclusive method used by most spreadsheets.
Questions people ask
How do you find the percentile rank of a score?
Count the scores below it, add half of those equal to it, divide by the number of scores and multiply by 100. A score of 82 in a class of 15 with 8 scores below it is at the (8 + 0.5) ÷ 15 × 100 = 56.7th percentile.
How do you find the 90th percentile?
Sort the numbers and find position 0.9 × (n − 1) + 1, interpolating between neighbours. For 15 numbers that's the 13.6th value: between 93 and 95, so 94.2.
Is the 50th percentile the median?
Yes. Half the numbers are at or below the 50th percentile.
Why does Excel give a slightly different answer?
There are several percentile methods. This calculator matches Excel's PERCENTILE.INC and Google Sheets' PERCENTILE; PERCENTILE.EXC uses another rule.
About this calculator
Formula and rules last checked 9 November 2026Written and tested by the CalculatorDex teamReport a problem