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
Here it is with your numbers:
- Put the 29 numbers in order, smallest first.
- Position: 70 ÷ 100 × (29 + 1) = 21
- 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
Here it is with your numbers:
- Count the numbers below 58: 18. Count those equal to it: 1.
- Rank: (18 + 0.5 × 1) ÷ 29 × 100 = 63.79
- 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:
| Percentile | Value | Excel .INC |
|---|---|---|
| 25th percentile | 29.5 | 30 |
| 50th percentile | 47 | 47 |
| 70th percentile | 64 | 63.2 |
| 75th percentile | 68 | 67 |
| 83rd percentile | 71.9 | 71.24 |
| 90th percentile | 74 | 73.2 |
| 95th percentile | 76.5 | 75.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.
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%.
Sources
- NIST/SEMATECH e-Handbook: 7.2.6.2 Percentiles
- OpenStax: Introductory Statistics 2e, 2.3 Measures of the Location of the Data (percentiles)
- CDC: Principles of Epidemiology, Lesson 2, Section 7: Measures of spread (quartiles)
- Microsoft Support: PERCENTILE.EXC function
- Microsoft Support: PERCENTILE.INC function