The Interquartile Vary (IQR) is a measure of variability, which represents the vary of the center 50% of a dataset. It’s calculated by subtracting the primary quartile (Q1) from the third quartile (Q3). In Excel, you’ll be able to calculate the IQR utilizing the QUARTILE.EXC perform.
The QUARTILE.EXC perform takes two arguments: the array or vary of knowledge, and the quartile you wish to calculate. For instance, to calculate the IQR of the info in cells A1:A10, you’d use the next components: