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.
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
| Percentile | Name | Value |
|---|---|---|
| 25th | First quartile (Q1) | 18.5 |
| 50th | Median (Q2) | 23.5 |
| 75th | Third quartile (Q3) | 29.5 |
| 90th | 90th percentile | 35.5 |
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.
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.
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.
Yes. The median, the 50th percentile and the second quartile are the same value.