Percentile Calculator
Find the value at any percentile rank in a dataset using linear interpolation.
About Percentile Calculator
A percentile indicates the value below which a given percentage of observations fall. This calculator uses the R-7 linear interpolation method, consistent with Excel's PERCENTILE.INC.
Formula
Index = (p/100) × (n − 1); interpolate between adjacent values
- p
- Desired percentile (0–100)
- n
- Number of data points
Worked example
With the default values below, Percentile Calculator returns Percentile Value of 46.0000. Change any input above and every figure here is recalculated in your browser.
Inputs used
- Data (comma separated)
- 15, 20, 35, 40, 50
- Percentile (0–100)accepts 0–100
- 90
Results
- Percentile Value
- 46.0000
- Data Count
- 5
Step by step
- 1Values used
- 2Formula applied
- 3Percentile Value= 46.0000
- 4Data Count= 5
Assumptions and limits
- The result is derived only from the 2 inputs listed above. Anything not among them is not part of the calculation.
- In particular, this calculator does not take inflation, tax, fees or charges or compounding frequency into account.
- Figures are rounded for display to 4 decimal places, so totals built from several rounded parts can differ slightly from the unrounded arithmetic.
How these calculators are built and tested is described on the Methodology page. If a figure looks wrong, please report it.
Frequently Asked Questions
What does the 90th percentile mean?
It means 90% of the data values fall at or below this value.
Are quartiles the same as percentiles?
Yes — Q1 is the 25th percentile, Q2 the 50th, and Q3 the 75th percentile.