Percentile Rank
Find a value’s position using below, inclusive or midrank conventions.
Your numbers
Percentile rank
Use consistent units. The result follows the assumptions you enter.
Scenario comparison
Up to three snapshots in this tab. Loading one replaces the current inputs.
Formula
Use R = 100(B+wE)/n. B counts observations below the target, E counts equal observations, and n is sample count. Convention weight w is 0 for strictly below, 0.5 for midrank, or 1 for inclusive rank.
Find a value’s position using below, inclusive or midrank conventions.
Worked example
- Observations
- 1, 2, 3, 3, 4
- Target value
- 3
- Rank convention
- Midrank
- Percentile rank
- 60 %
- Equal observations
- 2
Scope and limitations
Use consistent units. The result follows the assumptions you enter.
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: eebbc12588f1 · Example checked: