The interquartile vary (IQR) is a measure of variability that represents the variability of the center 50% of information issues in a dataset. It’s calculated by way of subtracting the primary quartile (Q1) from the 1/3 quartile (Q3). The IQR can be utilized to spot outliers and to check the variety of various datasets.
To search out the IQR in Excel, you’ll use the QUARTILE.INC serve as. The QUARTILE.INC serve as takes two arguments: the array of information and the quartile quantity. As an example, to search out the IQR of the knowledge in cells A1:A100, you could possibly use the next method:
