Percentile Calculator

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.