If you don’t want to do it in parts, you can get the IQR directly with this single formula: =QUARTILE.INC(B2:B16,3)-QUARTILE.INC(B2:B16,1) So, this is a simple formula you can use to calculate IQR in Excel. Excel has three Quartile functions – QUARTILE, QUARTILE.INC, and QUAR...
The “1” in this Excel formula(A2:A10,1) represents the first quartile (i.e the point lying at 25% of the data set). Click a second blank cell (for example, click cell B3) and then type =QUARTILE(A2:A10,3). Replace A2:A10 with the actual values from your data set. The “3...
2. Next, we need to calculate Q3. To calculate Q3 in Excel, simply find an empty cell and enter the formula ‘=QUARTILE(array, 3)‘. Again, replacing the ‘array‘ part with the cells that contain the data of interest. 3. Finally, to calculate the IQR, simply subtract the Q1 value...
To find outliers, you’ll need to know your data’s IQR, Q1, and Q3 values. Take these values and input them into the equations below. Statisticians call the result for each equation an outlier gate. I’ve included these calculations in the IQR example Excel file. Q1 − 1.5 * IQR: ...