How it works
Sort the data; use position (n−1)×p/100, then interpolate between adjacent values (R type 7 convention).
Input definitions
- Numeric values
- Plain text; maximum 200,000 characters.
- Percentile (0–100)
- Enter the value in the labeled unit.
A worked example
- Numeric values
- 10, 20, 30, 40
- Percentile (0–100)
- 25
Assumptions & limits
At least one value; duplicates are retained. Other percentile definitions can give different results on small datasets.
Sources & review
Maintained by AnsRio. Methods and examples use automated checks; this does not imply independent professional certification.
Method updated 2026-10-17. Content checked against the stated method and examples. Our verification approach.
Common questions
Why does my spreadsheet show a different percentile?
Percentile conventions vary. This tool uses linear interpolation at (n−1)p, also called type 7; nearest-rank and exclusive formulas can differ, especially for small samples.
Why can statistical results differ between tools?
Denominator, interpolation and boundary conventions can differ. Use the method and assumptions on this page to compare the same definition; displayed decimals may also be rounded.
How does the Percentile with linear interpolation tool work?
Sort the data; use position (n−1)×p/100, then interpolate between adjacent values (R type 7 convention).
What are the assumptions and limits of Percentile with linear interpolation?
At least one value; duplicates are retained. Other percentile definitions can give different results on small datasets.