Percentile Calculator
Percentile Calculator
Enter a list of numbers and a percentile between 0 and 100. This finds the value at that percentile using linear interpolation — the same method Excel's PERCENTILE.INC function uses, so results match what you'd get in a spreadsheet.
The Nth percentile is the value below which N% of the data falls — for example, scoring in the 90th percentile on a test means 90% of test-takers scored at or below your result. When the exact percentile rank falls between two data points rather than landing precisely on one, this calculator interpolates linearly between them instead of simply rounding to the nearest value, which is why the result lines up with spreadsheet software rather than a simpler nearest-rank method some other tools use.
- What a percentile means: the Nth percentile is the value below which N% of the data falls — the 90th percentile means 90% of values are at or below that point.
- Interpolation method: when the exact percentile rank falls between two data points, this calculator linearly interpolates between them rather than rounding to the nearest actual value.
- Common percentiles: the 25th, 50th, and 75th percentiles are the quartiles (Q1, median, Q3) — see our dedicated Quartile & IQR Calculator if that's specifically what you need.
What's the difference between percentile and percentage?
A percentage describes a proportion of a whole (like "80% correct"), while a percentile describes a position within a ranked dataset (like "scored better than 80% of test-takers") — they're related but not interchangeable concepts.
Why don't different calculators always agree on percentile values?
There are several accepted percentile calculation methods (this one matches Excel's default), which can give slightly different results, especially on small datasets — always check which method a tool uses when precision matters.
Percentile Calculator
Enter a list of numbers and a percentile between 0 and 100. This finds the value at that percentile using linear interpolation — the same method Excel's PERCENTILE.INC function uses, so results match what you'd get in a spreadsheet.
The Nth percentile is the value below which N% of the data falls — for example, scoring in the 90th percentile on a test means 90% of test-takers scored at or below your result. When the exact percentile rank falls between two data points rather than landing precisely on one, this calculator interpolates linearly between them instead of simply rounding to the nearest value, which is why the result lines up with spreadsheet software rather than a simpler nearest-rank method some other tools use.
- What a percentile means: the Nth percentile is the value below which N% of the data falls — the 90th percentile means 90% of values are at or below that point.
- Interpolation method: when the exact percentile rank falls between two data points, this calculator linearly interpolates between them rather than rounding to the nearest actual value.
- Common percentiles: the 25th, 50th, and 75th percentiles are the quartiles (Q1, median, Q3) — see our dedicated Quartile & IQR Calculator if that's specifically what you need.
What's the difference between percentile and percentage?
A percentage describes a proportion of a whole (like "80% correct"), while a percentile describes a position within a ranked dataset (like "scored better than 80% of test-takers") — they're related but not interchangeable concepts.
Why don't different calculators always agree on percentile values?
There are several accepted percentile calculation methods (this one matches Excel's default), which can give slightly different results, especially on small datasets — always check which method a tool uses when precision matters.