Percentile Calculator for Statistics (k-th Percentile & Rank)

StatisticsFreeNo sign-up

A percentile calculator for statistics finds the value below which a given percent of a data set falls. Sort the data, find the position h = (n − 1) × p/100 + 1, and interpolate between the two nearest values. For the 15 test scores below, the 90th percentile sits at position 13.6, between 90 and 92, so P90 = 91.2.

Percentile calculator (statistics)
th
Try:
The 90th percentile
91.2

The 90th percentile of these 15 values is 91.2 (PERCENTILE.INC method): about 90% of the data is at or below it.
Number of values n15
Position used#13 and #14
Minimum59
Median (50th)79
Maximum95
The 90th percentile by method
Method Position Value
Linear interpolation, inclusive (Excel PERCENTILE.INC) (n − 1)p/100 + 1 = 13.6 91.2
Linear interpolation, exclusive (Excel PERCENTILE.EXC) (n + 1)p/100 = 14.4 93.2
Nearest rank np/100, round up = 13.5 92
Textbook: average when the position is whole np/100 = 13.5 92
Methods agree for large data sets and differ most for small ones. Google Sheets PERCENTILE, Excel PERCENTILE and R’s default (type 7) match the inclusive method.
Sorted data with the position highlighted
59#163#267#370#472#574#677#779#881#984#1085#1188#1290#1392#1495#15
Below the positionValues used
Data on a number line

Data on a number line: each dot is one data value; dashed lines mark the results.60708090P₉₀ = 91.2

Show steps
  1. Sort the data from smallest to largest: 59, 63, 67, 70, 72, 74, 77, 79, 81, 84, 85, 88, 90, 92, 95. There are n = 15 values.
  2. Find the position: h = (n − 1) × p/100 + 1 = (15 − 1) × 0.9 + 1 = 13.6.
  3. The position 13.6 lies between #13 and #14: x₁₃ = 90 and x₁₄ = 92.
  4. Go 0.6 of the way from one to the next: 90 + 0.6 × (92 − 90) = 91.2.
  5. Answer: the 90th percentile is 91.2.
Common percentiles (PERCENTILE.INC)
Percentile Value
1st 59.56
5th 61.8
10th 64.6
20th 69.4
25th 71
30th 72.4
40th 75.8
50th 79
60th 82.2
70th 84.8
75th 86.5
80th 88.4
90th 91.2
95th 92.9
99th 94.58

Percentile Calculator for Statistics (k-th Percentile & Rank)
Embed this calculator on your site

Free to use on class pages, blogs and course pages. Copy the code below and paste it into your page:

How to use the percentile calculator

  1. Paste or type your data in any order, separated by commas, spaces or new lines. The calculator sorts it for you.
  2. Choose a tab: Percentile value (the k-th percentile), Percentile rank (where one value stands), Quartiles (Q1, median, Q3 and the IQR), or Normal (z-score) to turn a z-score into a percentile and back.
  3. Pick a method if your class, textbook or software uses a specific one. The results table always shows every method side by side, and Show steps walks through the working for your numbers.

This tool is for data sets and statistics classes. Child growth percentiles for height, weight or BMI come from national reference data instead; for those, use the CDC growth charts or the CDC Child and Teen BMI Calculator, and talk with your child’s doctor about the results.

What a percentile means in statistics

The p-th percentile is a value with about p% of the data at or below it. If your test score is at the 90th percentile, about 90% of the scores are at or below yours. A percentile is a position in the data, not a percent correct: a score of 70% can be at the 95th percentile on a hard test.

The 25th, 50th and 75th percentiles are the quartiles Q1, Q2 and Q3, and the 50th percentile is the median. The percentile rank works the other way around: it starts from a value and tells you its percentile.

Percentile formulas: four common methods

Statisticians do not agree on a single formula, so different books and programs can give slightly different answers for small data sets. With the data sorted as x1 ≤ x2 ≤ … ≤ xn:

Method Position Then
Linear, inclusive (Excel PERCENTILE.INC, Google Sheets PERCENTILE, R default) h = (n − 1)p/100 + 1 interpolate between x⌊h⌋ and the next value
Linear, exclusive (Excel PERCENTILE.EXC) h = (n + 1)p/100 interpolate; defined only when 1 ≤ h ≤ n
Nearest rank L = np/100 round L up and take that value
Textbook average L = np/100 if L is whole, average xL and xL+1; otherwise round up

To interpolate, split h into a whole part k and a decimal part d, then compute xk + d × (xk+1 − xk).

Worked example: the 90th percentile

Scores: 81, 67, 92, 74, 88, 59, 95, 70, 85, 77, 63, 90, 79, 84, 72. Sorted: 59, 63, 67, 70, 72, 74, 77, 79, 81, 84, 85, 88, 90, 92, 95, so n = 15.

  • Inclusive: h = 14 × 0.9 + 1 = 13.6. The 13th value is 90 and the 14th is 92, so P90 = 90 + 0.6 × 2 = 91.2.
  • Exclusive: h = 16 × 0.9 = 14.4, so P90 = 92 + 0.4 × 3 = 93.2.
  • Nearest rank and textbook: L = 15 × 0.9 = 13.5, rounded up to 14, so P90 = 92.

A second example. For 3, 5, 7, 8, 12, 13, 14, 18, 21 (n = 9), the 25th percentile is 7 with the inclusive method (h = 8 × 0.25 + 1 = 3 exactly), 6 with the exclusive method (h = 2.5, halfway between 5 and 7), and 7 by nearest rank (L = 2.25, rounded up to 3).

Percentile rank of a value

Let B be the number of values below x, E the number equal to x, and n the total. Two common definitions are:

  • At or below: percentile rank = (B + E) ÷ n × 100
  • Mid-rank: percentile rank = (B + 0.5E) ÷ n × 100

For a score of 85 in the data above, 10 scores are lower and one is equal. At or below: 11 ÷ 15 ≈ 73.33%. Mid-rank: 10.5 ÷ 15 = 70%. Excel’s PERCENTRANK.INC uses B ÷ (n − 1) = 10 ÷ 14 ≈ 0.714 (71.4%). The calculator shows all of them so you can match your course.

Quartiles and the interquartile range

With the median-of-halves method (the TI-84 and most textbooks), find the median, then the median of each half. For the 15 scores, the median is 79 (the 8th value), the lower half 59 to 77 has median Q1 = 70, and the upper half 81 to 95 has median Q3 = 88. The interquartile range is IQR = 88 − 70 = 18. Values below Q1 − 1.5 × IQR = 43 or above Q3 + 1.5 × IQR = 115 would be outliers, and there are none. Excel’s QUARTILE.INC gives Q1 = 71 and Q3 = 86.5 for the same data, which is why the tool lists both.

From z-score to percentile in a normal distribution

When values follow a normal distribution, you do not need the raw data. Convert x to a z-score with z = (x − μ) ÷ σ, then find the area to the left of z. A score of 85 on a test with mean 70 and standard deviation 10 has z = 1.5, and the area to the left is 0.9332, so it is at about the 93rd percentile.

z-score Percentile
−2 2.28
−1 15.87
0 50
1 84.13
1.28 89.97
1.645 95
1.96 97.5
2 97.72
3 99.87

Common mistakes with percentiles

  • Forgetting to sort. Positions only make sense in sorted data.
  • Confusing a percentile with a percent. The 80th percentile is not 80% of the maximum.
  • Mixing methods. Use the same formula as your textbook or software, especially for small data sets.
  • Using the position as the answer. h = 13.6 is a position; the percentile is the data value there, 91.2.
  • Using the normal table for skewed data. The z-score method only fits roughly bell-shaped data.

Percentiles practice quiz: 10 questions

Test yourself with 10 multiple-choice questions. Choose an answer and press Submit to see if you are right and why. Your score appears at the end.

Question 1 of 10
1. Using h = (n − 1)p/100 + 1 with interpolation, what is the 40th percentile of 2, 4, 6, 8, 10, 12, 14, 16, 18, 20?

Found a mistake? Let us know!

2. Using the nearest-rank method, what is the 30th percentile of 5, 9, 11, 14, 20, 22, 25, 30?

Found a mistake? Let us know!

3. In a class of 20 students, 15 scored below Ana and nobody tied with her. What is her percentile rank (percent at or below)?

Found a mistake? Let us know!

4. Same class: what is Ana’s percentile rank with the mid-rank rule (B + 0.5E) ÷ n?

Found a mistake? Let us know!

5. Which percentile is the same as the median?

Found a mistake? Let us know!

6. Using the median-of-halves method, what is the IQR of 1, 3, 4, 6, 7, 9, 12, 15?

Found a mistake? Let us know!

7. A test has mean 500 and standard deviation 100. About what percentile is a score of 600?

Found a mistake? Let us know!

8. Which z-score is at the 97.5th percentile of the standard normal distribution?

Found a mistake? Let us know!

9. A score is at the 90th percentile. What does that mean?

Found a mistake? Let us know!

10. With Excel’s PERCENTILE.EXC, h = (n + 1)p/100. For n = 9 values, what is h for the 25th percentile?

Found a mistake? Let us know!

Frequently asked questions

Which percentile method is used?

The default is linear interpolation with h = (n − 1)p/100 + 1, the same as Excel PERCENTILE.INC, Google Sheets and R. You can switch to the exclusive method, nearest rank or the textbook average, and the table shows all four results at once.

How do you calculate the 90th percentile?

Sort the data, compute the position (n − 1) × 0.9 + 1, and interpolate between the values on either side. For n = 15, the position is 13.6, so go 60% of the way from the 13th value to the 14th.

What is a percentile rank?

It is the percent of the data at or below a given value (or, with the mid-rank rule, below it plus half of the ties). A percentile rank of 73 means the value is as high as or higher than about 73% of the data.

Does it sort the data for me?

Yes. Enter the numbers in any order. The sorted list appears in the results with the positions used for your answer highlighted.

Is the 50th percentile the same as the median?

Yes. Every method above gives the median for p = 50 when the data has an odd number of values, and the inclusive, exclusive and textbook methods also give the median for an even number.

Related calculators

More statistics calculators

Browse all 541 calculators

Related to This Article

What people say about "Percentile Calculator (Statistics): Value, Rank, Quartiles"?

No one replied yet.

Leave a Reply