Percentile Calculator
Any percentile of a data set, plus the percentile rank of a value (Excel methods).
About this tool
Paste or type your numbers, separated by commas, spaces or new lines. Choose a percentile, such as 90, to see the value below which that share of the data falls, and enter any value to see its percentile rank. Pick the inclusive or exclusive method to match Excel or your textbook.
How percentiles and percentile ranks work
A percentile answers "how high is this compared with everything else?" The 90th percentile is the value that 90% of the data falls below. The percentile rank works the other way round: it tells you what percentage of values lie below a particular number. To find a percentile, the data is sorted and a position is calculated from the percentage. If the position falls between two values, the tool interpolates between them. With the sample values 12, 15, 17, 20, 22, 25, 28, 30, 34 and 41, the 90th percentile is 34.7 by the inclusive method (Excel PERCENTILE.INC, the default in most software) and 40.3 by the exclusive method (PERCENTILE.EXC). A value of 28 has a percentile rank of 65%: six values are below it and one is equal, and ties count as half. The 25th, 50th and 75th percentiles are the quartiles, and the 50th is the median. Honest limits: small data sets give noticeably different answers depending on the method, so say which one you used. Published percentiles, such as children's growth charts or exam results, come from large reference groups, not from your own list. The box plot maker, the standard deviation calculator and the z-score calculator are related.
Frequently asked questions
How do you calculate a percentile?
Sort the data, find the position (n โ 1) ร p/100 counting from zero, and interpolate between the values either side. This is the inclusive method Excel uses.
What is the difference between a percentile and a percentile rank?
A percentile is a value, such as the 90th percentile being 34.7. A percentile rank is a percentage, such as 28 being at the 65th percentile rank.
Why does Excel give two different percentile answers?
PERCENTILE.INC and PERCENTILE.EXC use slightly different position formulas, and the difference is larger for small data sets.
Is my data saved?
No. Everything is calculated in your browser and nothing is stored or sent.