What this calculator does
Percentiles divide an ordered data set into 100 parts. The 75th percentile, for example, is the value at or below which about 75% of the observations fall under the interpolation method used here. This calculator accepts comma-separated numbers and returns the requested percentile, the median, the count, and the minimum and maximum. It is useful for test scores, measurements, and any list where you want a position rather than a simple average.
How to use it
- Paste the values into the data field, separated by commas.
- Enter the percentile you want as a number from 0 to 100.
- Read the percentile value, median, count, minimum, and maximum.
- Compare the percentile with the median and the full range.
How it works
Example calculations
Example 1: 75th percentile of 1 to 5
For 1, 2, 3, 4, 5, n = 5 and r = 1 + 0.75 x 4 = 4, so the 75th percentile is 4. Median 3, count 5, minimum 1, maximum 5.
Example 2: 90th percentile of five values
For 10, 20, 30, 40, 50, n = 5 and r = 1 + 0.90 x 4 = 4.6. The value falls between 40 and 50: 40 + 0.6 x 10 = 46. Median 30, count 5, range 10 to 50.
Example 3: 25th percentile of four values
For 5, 10, 15, 20, n = 4 and r = 1 + 0.25 x 3 = 1.75. Interpolating between 5 and 10 gives 5 + 0.75 x 5 = 8.75. Median 12.5, count 4, range 5 to 20.
What the result means
The percentile tells you position in this particular list. A 90th percentile of 46 means the value sits above about 90% of the observations and below about 10%, subject to rounding and method. It does not mean the value is 90% correct or that 90% of people score below it outside this sample. The median is the 50th percentile and is less affected by extreme values than the mean. The minimum and maximum show the range and help flag values that may be typos or true outliers. With very small lists, percentiles are unstable, and the interpolation choice can shift the result. Report the method and sample size when the number matters.
Common mistakes
- Calculating before sorting the data from smallest to largest.
- Entering 0.75 when the field expects the percentile as 75.
- Reading a percentile as a percent correct or a percent of a total.
- Trusting a percentile from a very small sample as a stable benchmark.
- Comparing percentiles calculated with different software methods.
Assumptions and limits
- All entries are finite numbers separated by commas.
- The list is the complete set you want to describe, not a weighted sample.
- The requested percentile is between 0 and 100.
- Linear interpolation between neighboring order statistics is acceptable.
- Repeated values count as separate observations.
Frequently asked questions
What does the 75th percentile mean?
It is the value at or below which about 75% of observations fall under this method. For 1, 2, 3, 4, 5, it is 4.
Why is the result between two data values?
The rank often falls between positions, so the calculator interpolates linearly between neighboring values.
Is the median the 50th percentile?
Yes. Under this method, p = 50 gives the median, which is the average of the two middle values for an even count.
Can I use 0 or 100 as the percentile?
Yes. The 0th percentile is the minimum and the 100th is the maximum. Values outside that range are invalid.
Why does Excel give a different answer?
Packages use different percentile definitions, especially for small samples. This page uses linear interpolation, a common but not universal convention.
How are duplicate values handled?
Each duplicate counts separately. A value that appears three times adds three positions to the sorted list.
Sources
2026 update
How to use the professional output
This page is not just a formula box. The result is designed to be checked, compared, and taken away.
- Professional worksheet. The result includes the inputs used, the method and scope, and a one-variable sensitivity check for finance calculators.
- A/B scenarios. Save two input sets in the browser and compare the primary, secondary, and breakdown figures side by side.
- Print / PDF and CSV. Print a branded worksheet, or export the year-by-year table when the calculator produces one.
The formulas and assumptions above still govern the number. The worksheet makes the estimate auditable; it does not make it a lender quote, tax return, or personalized advice.
Go deeper
