Percentile Value
Find the value at an editable percentile of a data set.
Your numbers
Percentile value
Uses type-7 interpolation, including minimum at 0% and maximum at 100%.
Scenario comparison
Up to three snapshots in this tab. Loading one replaces the current inputs.
Formula
h=(n−1)p; interpolate between neighbouring sorted observations.
Find the value at an editable percentile of a data set.
Worked example
- Observations, separated by commas
- 1, 2, 3, 4, 5
- Percentile (%)
- 75
- Percentile value
- 4
Scope and limitations
Uses type-7 interpolation, including minimum at 0% and maximum at 100%.
Inputs are checked for missing values and allowed ranges. A result outside the finite numeric range is not displayed. Rounding affects display, while the calculation uses the model’s numeric precision.
Check your units and assumptions before relying on a result. Changing a label does not convert a currency or physical unit.
Formula version: 396d26b17b09 · Example checked: