Find the value below which a given percentage of the data falls, or turn it around and find the percentile rank of a particular value. Several percentiles can be calculated at once, and all three common methods are shown side by side.
Methods
- Linear (inclusive): Excel PERCENTILE.INC, R and Python default.
- Exclusive: Excel PERCENTILE.EXC and SPSS.
- Nearest rank: the textbook method, which always returns an actual data value.
Percentile rank
The percentile rank of a value is the percentage of values below it, counting half of any ties: PR = (B + 0.5E) ÷ n × 100.