What this calculator does
Value at a percentile works out finds the data value at any percentile using linear interpolation. Enter your own figures above and the answer updates as you type: nothing is fixed in the code, so the result reflects exactly the numbers you supply.
The formula this calculator evaluates is printed under the tool and explained below, so you can check the working by hand or reuse it in a spreadsheet.
The formula
FormulaRank i = (n−1)×p; value = a[⌊i⌋] + (a[⌊i⌋+1] − a[⌊i⌋]) × (i − ⌊i⌋)
The inputs explained
| Field | What to enter |
|---|---|
| Data (comma or space separated) | A list of numbers, separated by commas or spaces. |
| Percentile (%) | A number, measured in %. Starts at 90. |
Worked examples
Every figure in the tables below is produced by this page’s own calculator at build time, so the numbers and the tool always agree. Select any row to load that scenario.
How the answer changes with percentile
Every other input is held at the calculator’s starting values while percentile varies. Select any row to load that scenario into the calculator.