# 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.

=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)