Returns the interquartile range (IQR), also called the midspread or middle fifty.

## Syntax

**IQR**(**X**)

- X
- is the input data series (one/two-dimensional array of cells (e.g., rows or columns)).

## Remarks

- The input time series data may include missing values (e.g., #N/A, #VALUE!, #NUM!, empty cell), but they will not be included in the calculations.
- The Interquartile range is defined as follows:

$$\mathrm{IQR}=Q_3-Q_1$$

Where:

- $Q_3$ is the third
**quartile**. - $Q_1$ is the first
**quartile**.

- $Q_3$ is the third
- The interquartile range (IQR) is a robust statistic because it has a breakdown point of 25%. It is often preferred to the total range.

## Files Examples

## Related Links

## References

- Hamilton, J .D. Time Series Analysis. Princeton University Press. (1994). ISBN 0-691-04289-6.
- Tsay, Ruey S. Analysis of Financial Time Series. John Wiley & SONS. (2005). ISBN 0-471-690740.

## Comments

Article is closed for comments.