Question: how to calculate iqr in excel?
Answer: Step 2: Click a blank cell (for example, click cell B2) and then type =QUARTILE(A2:A10,1). ... 
Step 3: Click a second blank cell (for example, click cell B3) and then type =QUARTILE(A2:A10,3). ... 
Step 4: Click a third blank cell (for example, click cell B4) and then type =B3-B2.