The Percentile Calculator works in both directions: it finds the value at a chosen percentile in a data set, and it finds the percentile rank of a given score. Paste values separated by commas, spaces or line breaks, choose an interpolation method, and read the position arithmetic beside the result.
Percentiles place a score in context. A raw mark of 72 means little until you know it sits at the 90th percentile of the class.
Find the value at a given percentile
A percentile value is the cut in the sorted list at or below which that percentage of observations fall. Enter the data, choose p such as 90, and the calculator returns the interpolated or ranked value at that position.
Sorted order is mandatory; the tool sorts ascending and shows the ordered list so neighbouring scores are visible when interpolation lands between two values.
Sorted order is mandatory. The tool sorts ascending and shows the ordered list so you can verify neighbours when interpolation lands between two scores.
Find the percentile rank of a value
Percentile rank answers the reverse question: what percentage of the data sits at or below this score? Count how many values are strictly below the score, add an agreed fraction for ties if the chosen rule requires it, divide by n, and multiply by 100.
Tied scores need an explicit rule. Some courses count only values strictly below the score; others credit half of the ties. The results panel states which count it used so a hand check can follow the same convention. On competitive exams, percentile rank is often what students mean when they ask where they stand in the group.
On a test-score list, a student asking "what percentile am I?" wants this direction. Enter the score in the rank field; the calculator reports the percentage and the counts it used.
Apply the percentile formula
The default linear-interpolation rule places the percentile at position equal to p over 100 times n minus 1, then plus 1. If that position is not an integer, the calculator blends the values at the floor and ceiling ranks in proportion to the fractional part.
Other methods replace that position rule entirely, which is why small gaps between tools are often definition gaps.
position = (p / 100) × (n − 1) + 1If position is not an integer, interpolate between the values at floor(position) and ceil(position).
Example setup. Sorted scores: 62, 68, 71, 74, 77, 81, 85, 88, 92, 95. Here n = 10.
For the 90th percentile: position = 0.90 × 9 + 1 = 9.1. The 9th value is 92 and the 10th is 95, so the result is 92 + 0.1 × (95 − 92) = 92.3.
Nearest rank instead uses ceil(p/100 × n) and returns that observed value with no interpolation. Exclusive rank uses p/100 × (n + 1).
Find the 90th percentile of a test score set
The worked list is ten sorted test scores: 62, 68, 71, 74, 77, 81, 85, 88, 92 and 95. With linear interpolation and p equals 90, the position is 9.1, so the result sits one tenth of the way from 92 toward 95.
Nearest rank on the same list returns 92 instead, which is the contrast the method selector exists to explain.
If the assignment key shows 92, the key likely used nearest rank or a related ceiling rule. If it shows 92.3 or 92.5, interpolation is the likely match. Switching the selector is faster than rewriting the arithmetic from scratch, and it teaches the definition difference rather than hiding it.
1. n = 10, p = 90. 2. position = 0.90 × (10 − 1) + 1 = 9.1. 3. Neighbours: x₉ = 92, x₁₀ = 95. 4. Value = 92 + 0.1 × 3 = 92.3.
Nearest rank at p = 90 would take ceil(0.90 × 10) = ceil(9) = 9, returning 92. Same data, different method, different answer. That gap is why the method label sits next to every result.
Choose an interpolation method
Linear interpolation, nearest rank and exclusive rank cover spreadsheet defaults and common textbook variants. Linear interpolation is the default. Nearest rank always returns an observed score. Exclusive rank uses p over 100 times n plus 1.
Pick the method your course or software documents before treating a small disagreement as an arithmetic error on your part. |---|---|---| | Linear interpolation (default) | p/100 × (n − 1) + 1 | Matches common spreadsheet percentile functions | | Nearest rank | ceil(p/100 × n) | Always an observed value | | Exclusive rank | p/100 × (n + 1) | Older textbook variant |
Pick the method your course or software documents. On large n the three usually sit close together. On n near 10, homework keys often match only one of them.
Understand percentiles against quartiles
Special percentiles align with quartiles when the underlying rules match: the 25th with Q1, the 50th with the median and the 75th with Q3. Slight disagreements still appear when the quartile engine uses exclusive hinges and the percentile engine uses linear interpolation. For formal quartile work prefer the Quartile Calculator; for arbitrary p use this page.
- 25th percentile ↔ Q1
- 50th percentile ↔ median (Q2)
- 75th percentile ↔ Q3
Slight disagreements still appear when the quartile engine uses exclusive hinges and the percentile engine uses linear interpolation. For formal quartile work, prefer the Quartile Calculator. For arbitrary p such as 10th or 95th, use this page.
Percentiles in graded work and research
Growth charts, standardised tests and admissions summaries all lean on percentiles because a raw score needs a reference group to mean anything. State the reference group when you quote a percentile: class section, national cohort or clinical sample. The same raw score can sit at very different percentiles in those three frames.
For continuous normal models, a z-score can translate to a percentile through the standard normal curve. That path assumes approximate normality and known mean and standard deviation; it is not a substitute for an empirical percentile computed from an actual class list. Use the Z-Score Calculator for the model-based route and this page for the empirical list-based route.
On very small n, adding or removing one score can jump the 90th percentile by several points. Report n beside any percentile you publish from a short list so readers can judge stability.
Worked checks against spreadsheet functions
Open a blank sheet and enter the ten scores from the worked example in A1:A10. PERCENTILE.INC(A1:A10,0.9) should land near 92.3 under the linear-interpolation family this calculator defaults to. PERCENTILE.EXC uses a different position rule and will disagree on purpose.
Matching the function name to the method selector is the fastest way to reconcile a homework key with an interactive result.
When n grows past a few dozen, method gaps shrink as a share of the score range, but they never vanish entirely at the extreme percentiles. Always state method and n when a percentile supports a high-stakes claim such as a cutoff score.
Stability on short lists
On n near 10, the 90th percentile can move several points when a single high score is added or removed. Quote n beside any percentile used as a cutoff, and prefer a fuller cohort when the decision is high stakes.
Frequently asked questions
What is a percentile?
A percentile is a cut that divides ordered data so that approximately p percent of values fall at or below it. The 90th percentile is the value at or below which about 90% of the observations sit.
What is percentile rank?
Percentile rank is the percentage of the data set that falls at or below a given score. It answers "where do I stand?" rather than "what score sits at the 90th percentile?" State n and the tie rule whenever the rank supports a competitive claim.
Why does Excel give a different percentile?
Excel offers several percentile functions with different position rules. Match the calculator method to the function named in the assignment (PERCENTILE.INC, PERCENTILE.EXC, or older PERCENTILE).
Is the 50th percentile always the median?
It matches the median when both use compatible definitions. Interpolation versus exclusive quartile hinges can still produce tiny gaps on small sets.
Can a percentile fall between two data values?
Yes, under linear interpolation. Nearest rank never does; it always returns an observed point.
How many values do I need?
Technically two or more for a meaningful split. Very small n makes percentiles unstable: adding one point can jump the 90th percentile substantially.
Does the calculator modify my scores?
No. It sorts a copy for calculation. Nothing is stored or uploaded.
Summary
The Percentile Calculator finds the value at a chosen percentile and the percentile rank of a given score, with position arithmetic shown for the active method. Linear interpolation is the default; nearest rank and exclusive rank are available because small data sets disagree across definitions.
The 25th, 50th and 75th percentiles align with Q1, the median and Q3 when rules match. Confirm the method against your course or spreadsheet function before treating a one-point gap as an error.