What is a Percentile Calculator?
A percentile rank calculator tells you what share of a dataset falls below a value: PR = (B + 0.5E) / n × 100, where B values are below x and E equal it. A score of 77 in a class of 20, with 11 lower scores, has a percentile rank of (11 + 0.5) / 20 × 100 = 57.5. Run in reverse, the percentile calculator finds the value at a given percentile: the 90th percentile of the same 20 scores is 90.3 by the Excel and NumPy method.
What the Percentile Calculator does
Choose Percentile rank of a value to use it as a percentile rank calculator: where does a score of 77 stand in this class? You get the percentile rank with ties counted as half, plus the plain “% below” and “% at or below” figures that people often mean when they say percentile, and the matching Excel PERCENTRANK.INC and PERCENTRANK.EXC results. If you only need Q1, the median and Q3, the Quartile Calculator compares the quartile conventions in more detail. If you have a mean and standard deviation instead of raw data, use the Z-Score to Percentile Calculator, or the Percentile to Z-Score Calculator to turn a percentile rank into a z-score.
Choose Value at a percentile to turn a percentage into a data value, the kth percentile of a data set for any k: the 90th percentile of exam scores, the P95 of response times, the 10th percentile of birth weights. The calculator sorts the data, shows the position it reads from, and reports the answer under three definitions side by side (nearest rank, inclusive interpolation and exclusive interpolation), together with P10, P25, P50, P75, P90, P95 and P99 for the method you picked.
How to use the Percentile Calculator
- Under Find the, keep Percentile rank of a value (the default) or choose Value at a percentile.
- Type or paste your numbers into Data values, in any order. A column copied from Excel or Google Sheets works.
- For a percentile value, enter Percentile, P (0 to 100) and choose a Percentile method. Use the inclusive option to match Excel’s PERCENTILE.INC, NumPy and R; use nearest rank if the answer must be an actual data value.
- For a percentile rank, enter the Value, x you want to place.
- Read the result, then check the comparison table and the highlighted rows of the sorted data to see exactly where it came from.
How to find the 75th or 80th percentile of a data set
These steps use the 20 exam scores from the worked example below, already sorted: 55, 59, 62, 64, 67, 69, 70, 71, 73, 74, 76, 77, 79, 81, 83, 85, 88, 90, 93, 96. The inclusive method is the one Excel’s PERCENTILE.INC, Google Sheets, NumPy and R use by default.
- Sort the data from smallest to largest and count it: n = 20.
- Write the percentile as a proportion: p = 0.75 for the 75th percentile, 0.80 for the 80th.
- Find the position h = (n − 1)p + 1. For P75, h = 19 × 0.75 + 1 = 15.25. For P80, h = 19 × 0.8 + 1 = 16.2.
- Read or interpolate. P75 sits a quarter of the way from the 15th value (83) to the 16th (85): 83 + 0.25 × 2 = 83.5. P80 sits 0.2 of the way from the 16th value (85) to the 17th (88): 85 + 0.2 × 3 = 85.6.
- State the method. By nearest rank, ⌈0.75 × 20⌉ = 15 and ⌈0.8 × 20⌉ = 16, so P75 = 83 and P80 = 85, both actual scores.
| Percentile | Nearest rank, ⌈pn⌉ | Inclusive, (n − 1)p + 1 | Exclusive, (n + 1)p |
|---|---|---|---|
| 75th (Q3) | 83 | 83.5 | 84.5 |
| 80th | 85 | 85.6 | 87.4 |
| 90th | 90 | 90.3 | 92.7 |
| 95th | 93 | 93.15 | 95.85 |
How to calculate percentile rank, and a percentile from a rank
The percentile rank formula counts the values below x, adds half of any values tied with x, and divides by n: PR = (B + 0.5E) / n × 100. For a score of 88 among the 20 exam scores, 16 scores are lower and one equals it, so PR = (16 + 0.5) / 20 × 100 = 82.5.
If you only know a rank rather than the data, the same formula still works. A value ranked r-th from the bottom of n values, with no ties, has r − 1 values below it, so PR = (r − 0.5) / n × 100. Ranked 5th from the top in a class of 40 means 35 students scored lower: PR = (35 + 0.5) / 40 × 100 = 88.75. Going the other way, the value at percentile rank PR sits at rank r = PR × n / 100 + 0.5, rounded to a whole rank.
Some courses use simpler versions: “% below” is B / n × 100 and “% at or below” is (B + E) / n × 100. For 88 these give 80% and 85%; the tie-splitting formula sits between them. The calculator shows all three, so you can match whichever your textbook uses.
Percentile formula and percentile rank formula
Sort the data so that x₁ ≤ x₂ ≤ … ≤ xₙ and write the percentile as a proportion p = P / 100. The three percentile methods differ only in the position they read.
| Symbol | Meaning |
|---|---|
| xₖ | k-th smallest value |
| n | number of values |
| p | percentile as a proportion (0.9 for the 90th) |
| ⌈ ⌉, ⌊ ⌋ | round up, round down to a whole number |
| B, E | number of values below x, number equal to x |
The inclusive method reaches the minimum at P = 0 and the maximum at P = 100. The exclusive method only covers percentiles from 1 / (n + 1) to n / (n + 1); outside that range this calculator returns the minimum or maximum and says so, while Excel returns an error.
For nearest rank, P = 0 gives rank 0, which does not exist, so the minimum is used.
Worked example
Worked example: the 90th percentile of 20 exam scores
Problem. Twenty students score 62, 71, 55, 88, 93, 67, 74, 81, 59, 77, 85, 69, 90, 73, 64, 79, 96, 70, 83, 76. Find the 90th percentile, and the percentile rank of a score of 77.
- 01Sort: 55, 59, 62, 64, 67, 69, 70, 71, 73, 74, 76, 77, 79, 81, 83, 85, 88, 90, 93, 96 (n = 20).
- 02Inclusive interpolation: h = 19 × 0.9 + 1 = 18.1, so P90 = x₁₈ + 0.1 × (x₁₉ − x₁₈) = 90 + 0.1 × (93 − 90) = 90.3.
- 03Nearest rank: r = ⌈0.9 × 20⌉ = 18, so P90 = x₁₈ = 90.
- 04Exclusive interpolation: h = 21 × 0.9 = 18.9, so P90 = 90 + 0.9 × 3 = 92.7.
- 05Percentile rank of 77: B = 11 scores are lower and E = 1 equals it, so PR = (11 + 0.5) / 20 × 100 = 57.5.
Answer. The 90th percentile is 90.3 by the Excel/NumPy default, 90 by nearest rank and 92.7 by the exclusive method. A score of 77 has a percentile rank of 57.5: 55% of the class scored lower and 60% scored 77 or lower.
Percentile, percentile rank and percentage are three different things
A percentage describes one result on its own scale: 77 marks out of 100 is 77%. A percentile is a value in the units of the data, chosen so that a stated share of the data lies at or below it. A percentile rank is the reverse lookup: the share of the data that a particular value beats.
So a student can score 77% on a test and be at the 57.5th percentile rank of the class, while the 90th percentile of the same class is a score of 90.3. Mixing these up is the most common mistake in reading test reports and growth charts.
| Term | Question it answers | Units | Example (the 20 scores above) |
|---|---|---|---|
| Percentage | How much of the maximum was achieved? | % | 77 out of 100 = 77% |
| Percentile (value) | Which value has P% of the data at or below it? | Same as the data | P90 = 90.3 marks |
| Percentile rank | What share of the data is below this value? | 0 to 100 | A score of 77 → 57.5 |
Percentile methods: nearest rank, inclusive and exclusive interpolation
There is no single agreed definition of a sample percentile, and for small datasets the choices give visibly different answers. Hyndman and Fan (1996) list nine in common use; this calculator covers the three you are most likely to need. All of them converge as n grows. Match the method to the tool you need to agree with:
| Tool | Method on this page |
|---|---|
| Excel PERCENTILE and PERCENTILE.INC, Google Sheets PERCENTILE | Inclusive interpolation, (n − 1)p + 1 |
| NumPy percentile and pandas quantile (default “linear”), R quantile (default type 7) | Inclusive interpolation, (n − 1)p + 1 |
| Excel PERCENTILE.EXC, Minitab, SPSS, R quantile type 6, NumPy method “weibull” | Exclusive interpolation, (n + 1)p |
| R quantile type 1, NumPy method “inverted_cdf”, many service-level and latency reports | Nearest rank, ⌈p × n⌉ |
Percentile of grouped data
When you only have a frequency table, not the raw values, locate the class that contains the pN-th observation and interpolate inside it: Pₖ = L + ((pN − F) / f) × h. Here L is the lower boundary of that class, F the cumulative frequency before it, f its frequency, h the class width and N the total count.
Grouping the 20 exam scores into classes of width 10, each including its lower limit, gives the table below. For the 75th percentile, pN = 0.75 × 20 = 15. The cumulative frequency passes 15 in the 80–90 class, so P75 = 80 + ((15 − 13) / 4) × 10 = 85. That is close to the raw-data answer of 83.5 but not equal, because grouping assumes the values are spread evenly across each class. Use raw data in this calculator whenever you have it; the Frequency Distribution Calculator builds the grouped table from raw data.
| Class | f | Cumulative f |
|---|---|---|
| 50–60 | 2 | 2 |
| 60–70 | 4 | 6 |
| 70–80 | 7 | 13 |
| 80–90 (contains the 15th value) | 4 | 17 |
| 90–100 | 3 | 20 |
Common use cases
- Test scores and admissions: convert a raw score into a percentile rank within a class or cohort.
- Performance monitoring: report P90, P95 or P99 response times, which describe slow requests far better than the mean does.
- Growth and health data: place a measurement against a reference group, or find the cut-off for the lowest 10%.
- Pay and pricing: find the 25th, 50th and 75th percentile of salaries or bids to set a band.
- Checking software output: see at once whether a mismatch with Excel, R or Python is only a different percentile definition.
Assumptions and limitations
- Percentiles from small samples are rough. With 20 values, anything beyond the 95th percentile is decided by the largest one or two values, whatever method you pick.
- The methods here work on raw data. Percentiles of grouped (binned) data use the class-boundary formula in the grouped data section above and are only approximate.
- A percentile rank describes position within this dataset only. To rank a value against a theoretical normal population, convert it to a z-score and use the Z-Score to Percentile Calculator.
- For Q1 and Q3 by the median-of-halves rule used on TI calculators and in most textbooks, use the Quartile Calculator; that rule is not a percentile formula and can give a different P25 and P75.
- Percentile ranks are ordinal: the gap between the 50th and 60th rank is usually a much smaller change in the raw value than the gap between the 89th and 99th.
Frequently asked questions
How do you calculate a percentile by hand?
What is the difference between a percentile and a percentile rank?
Why does Excel give a different percentile from my textbook?
What is the difference between PERCENTILE.INC and PERCENTILE.EXC?
Is the 50th percentile the same as the median?
How do you find the 80th percentile of a data set?
What is the 95th percentile?
How much percentile is 75 marks?
How do you convert a percentile rank to a z-score?
How are ties handled in a percentile rank?
Can a value be at the 100th percentile?
Cite this page
Statculator. (2026, November 14). Percentile Calculator. Retrieved November 14, 2026, from https://statculator.com/descriptive-statistics/percentile-calculator/