IQR - Interquartile Range

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

  1. 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.
  2. 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.
  3. 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

Comments

Article is closed for comments.

Was this article helpful?
0 out of 1 found this helpful