Interpercentile Ranges

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 $35-65$ interpercentile range is:

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

category: measure of spread

category: statistics