notes
Interpercentile Ranges

Interpercentile and Interquartile Range

Definition

Definition

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.

Spreadsheet

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