Percentile and Percentile Rank Calculator

A percentile tells you where a value sits in a list: about 70% of the numbers are below the 70th percentile. Paste your numbers to find any percentile, or switch to percentile rank to see where one value, like your score, stands.

Separate numbers with commas, spaces or new lines. Type 1200, not 1,200.

70th percentile
64

The 70th percentile of these 29 numbers is 64: about 70% of them are below it.

Position in order 21
Excel PERCENTILE.INC 63.2
How many numbers 29

What is a percentile?

The 70th percentile is a value with about 70% of the numbers below it and about 30% above. The 50th percentile is the median. A percentile rank works the other way round: it starts from a value, like a test score, and tells you which percentile it is at.

Source NIST/SEMATECH e-Handbook · 7.2.6.2 Percentiles ↗

How to calculate a percentile

Position = k ÷ 100 × (n + 1); go that far along the numbers in order

Here it is with your numbers:

  1. Put the 29 numbers in order, smallest first.
  2. Position: 70 ÷ 100 × (29 + 1) = 21
  3. Number 21 in order is 64.

It means about 70% of the numbers are below 64 and about 30% are above it.

How to calculate percentile rank

Percentile rank = (numbers below + ½ × numbers equal) ÷ n × 100

Here it is with your numbers:

  1. Count the numbers below 58: 18. Count those equal to it: 1.
  2. Rank: (18 + 0.5 × 1) ÷ 29 × 100 = 63.79
  3. Round to a whole number: the 64th percentile.

It means about 64% of the list is below 58, counting half of any numbers equal to it.

Source OpenStax · Introductory Statistics 2e, 2.3 Measures of the Location of the Data (percentiles) ↗

Which percentile method is this?

There is no single agreed way to find a percentile that falls between two numbers. This calculator uses NIST’s method, position k ÷ 100 × (n + 1), which matches Excel’s PERCENTILE.EXC. Excel’s PERCENTILE.INC uses 1 + k ÷ 100 × (n − 1) and is shown in the second box. Some textbooks, OpenStax among them, average the two neighbours instead of going part of the way. On small lists the answers can differ.

Source Microsoft Support · PERCENTILE.EXC function ↗Microsoft Support · PERCENTILE.INC function ↗

Percentile examples

Percentiles of OpenStax’s 29 actors’ ages:

PercentileValueExcel .INC
25th percentile29.530
50th percentile4747
70th percentile6463.2
75th percentile6867
83rd percentile71.971.24
90th percentile7473.2
95th percentile76.575.2

FAQs

How to calculate 70 percentile?

Put the numbers in order and find position 0.7 × (n + 1), where n is how many numbers there are. For 29 numbers that is position 21, so the 70th percentile is the 21st number. If the position falls between two numbers, go that fraction of the way from one to the next.

Source NIST/SEMATECH e-Handbook · 7.2.6.2 Percentiles ↗

What is 25 percentile and 75 percentile?

The 25th percentile is the first quartile (Q1) and the 75th percentile is the third quartile (Q3). About a quarter of the numbers are below Q1 and about three quarters below Q3.

Source CDC · Principles of Epidemiology, Lesson 2, Section 7: Measures of spread (quartiles) ↗

How do I calculate my percentile rank?

Count the values below yours (x) and those equal to it (y), then work out (x + 0.5y) ÷ n × 100 and round to a whole number. In OpenStax’s list of 29 ages, 18 are below 58 and one equals it: 18.5 ÷ 29 × 100 is 63.79, the 64th percentile.

Source OpenStax · Introductory Statistics 2e, 2.3 Measures of the Location of the Data (percentiles) ↗

Is top 5% the 95th percentile?

Yes. At the 95th percentile, at most 95% of the values are below it and at most 5% above, so a value there is in the top 5%.

Source NIST/SEMATECH e-Handbook · 7.2.6.2 Percentiles ↗

Sources

Related calculators