The interquartile range (IQR) is a measure of variability that represents the range of the middle 50% of data points in a dataset. It is calculated by subtracting the first quartile (Q1) from the third quartile (Q3). The IQR can be used to identify outliers and to compare the variability of different datasets.
To find the IQR in Excel, you can use the QUARTILE.INC function. The QUARTILE.INC function takes two arguments: the array of data and the quartile number. For example, to find the IQR of the data in cells A1:A100, you would use the following formula:
