Percentile Calculator

Percentile rank of a value

Percentile Calculator

By Dr. Meilin Zhou, Senior Education Advisor, Percentage Calculators Hub · How we check our answers

A percentile tells you where a value sits within a data set. The 75th percentile is the value that 75% of the data is at or below. Enter your numbers and the percentile you want to find the matching value.

Use the second calculator to find the percentile rank of a single score, for example where a test score of 82 sits among a class.

Formula

Position of the k-th percentile in sorted data = (k ÷ 100) × (n − 1) + 1, interpolating between neighbours (the method used by Excel PERCENTILE.INC and Google Sheets PERCENTILE)

Percentile rank = (number of values below + 0.5 × number equal) ÷ n × 100

How to use this calculator

  1. Enter your numbers in the boxes on the calculator.
  2. Press Calculate. The answer appears straight away, with every step of the working.
  3. Press Clear to start again.

Worked examples

75th percentile of 12, 15, 18, 20, 22, 25, 28, 30, 35, 40

  1. n = 10, so the position is 0.75 × 9 + 1 = 7.75
  2. The 7th value is 28 and the 8th is 30
  3. 28 + 0.75 × (30 − 28) = 29.5

Percentile rank of 82 in 55, 62, 68, 70, 74, 78, 82, 85, 90, 96

  1. 6 values are below 82 and 1 is equal
  2. (6 + 0.5 × 1) ÷ 10 × 100 = 65th percentile

Common percentiles of 12, 15, 18, 20, 22, 25, 28, 30, 35, 40

PercentileNameValue
25thFirst quartile (Q1)18.5
50thMedian (Q2)23.5
75thThird quartile (Q3)29.5
90th90th percentile35.5

Frequently asked questions

What does the 90th percentile mean?

A value at the 90th percentile is higher than or equal to about 90% of the values in the data set. Only about 10% are higher.

Is percentile the same as percentage?

No. A percentage is a score out of 100. A percentile is a position compared with other people or values. Scoring 70% on a test could put you in the 95th percentile if most people scored lower.

Why do calculators give slightly different percentiles?

There are several accepted methods for small data sets. This calculator uses the inclusive interpolation method used by Excel PERCENTILE.INC and Google Sheets. Large data sets give almost the same result with any method.

Is the median the 50th percentile?

Yes. The median, the 50th percentile and the second quartile are the same value.

More percentage calculators