The interquartile vary (IQR) is a measure of variability that represents the variability of the center 50% of knowledge issues in a dataset. It’s calculated via subtracting the primary quartile (Q1) from the 1/3 quartile (Q3). The IQR can be utilized to spot outliers and to check the range of various datasets.
To search out the IQR in Excel, you’ll be able to use the QUARTILE.INC serve as. The QUARTILE.INC serve as takes two arguments: the array of knowledge and the quartile quantity. For instance, to seek out the IQR of the knowledge in cells A1:A100, you might use the next system:
