Interpercentile Ranges

Interpercentile and Interquartile Range



An interpercentile range of a population or a sample of a population is a measure of spread. It is specified by giving a lower percentile and an upper percentile and is defined as the difference of the two.

The interquartile range is defined as the difference of the upper quartile and the lower quartile.


In a spreadsheet, the formula to calculate the interquartile range of a range is:

=quartile(<range>,3) - quartile(<range>,1)

The formula to calculate, for example, the 356535-65 interpercentile range is:

=percentile(<range>,0.65) - percentile(<range>,0.35)

category: statistics