Percentile Calculator
Find the value at any percentile within a dataset of up to 8 numbers, using linear interpolation between sorted values.
Only the first this-many values below are included.
Your results
Calculation breakdown
- Rank
- rank = p/100 × (n − 1)
- Interpolated value
- linear interpolation between the two nearest sorted values
Worked example
In a dataset of 8 exam scores, the 90th percentile marks the score below which about 90% of the class falls, found by sorting the scores and interpolating between the two nearest ranked values.
Assumptions
- Uses linear interpolation between ranks (the same method as Excel's PERCENTILE.INC), one of several accepted percentile methods.
- Results are only meaningful with a reasonably representative dataset; small samples give a rough estimate.
How this calculator works
Enter up to 8 numeric values and the percentile you want to find. The calculator sorts the data and uses linear interpolation between the two nearest ranked values, the same convention used by common spreadsheet PERCENTILE functions.
Frequently asked questions
What does the 90th percentile mean?
It means about 90% of the values in the dataset fall at or below that point.
Why might different tools give a slightly different percentile?
There are several accepted percentile interpolation methods; this calculator uses linear interpolation, matching Excel's PERCENTILE.INC.
How many values do I need for a reliable percentile?
More data gives a more reliable percentile; with very few values the result is only a rough indication.