How to use the Percentile Calculator
- 1. Paste the dataEnter all values in any order.
- 2. Choose the directionFind a value at a percentile, or the percentile rank of a value.
- 3. Compare methodsSee inclusive, exclusive and nearest-rank answers together.
How the percentile is found
The inclusive method (Excel PERCENTILE.INC, NumPy and pandas default) sorts the data and finds position h = (n − 1) × p, counted from 0, then interpolates between neighbours. The exclusive method (PERCENTILE.EXC) uses (n + 1) × p instead, and nearest rank simply picks the value at position ⌈p × n⌉.
Worked example (15 sorted scores from 45 to 97, p = 90%): h = 14 × 0.9 = 12.6, so the value lies 60% of the way from the 13th score (88) to the 14th (92): 88 + 0.6 × 4 = 90.4. The exclusive method gives 94 and nearest rank gives 92, which is why reports should state the method.
Percentile rank and common uses
Percentile rank answers the reverse question. A score of 75 in the same list has 8 values below it and 1 equal, so 60% of scores are at or below 75 and 53.33% are strictly below. Excel's PERCENTRANK.INC gives 0.5714 because it measures position on a 0-to-1 scale across n − 1 gaps.
- Exams: a 90th percentile score beats 90% of candidates. It is not the same as 90% marks.
- Website speed: p95 or p99 load time shows what slow users experience, which an average hides.
- Salaries and growth charts are also reported in percentiles.
Quartiles are just the 25th, 50th and 75th percentiles; see them all with the quartile calculator. For normal data, convert with the z-score calculator.
Frequently asked questions
Is percentile the same as percentage?
No. A percentage is a share of a total. A percentile tells you the share of values below a given point in a group.
Why is the exclusive result missing sometimes?
PERCENTILE.EXC is undefined for very low or high percentiles in small data sets, so the tool shows that instead of guessing.
Is the Percentile Calculator free?
Yes, the Percentile Calculator is free. The first time you see your first result, you are asked for your name and WhatsApp number once. After that, this and every other Uncodemy tool opens straight away without the form.