Question: how to iqr in excel?
Answer: Step 1: Enter your data into a single Excel column on a worksheet. For example, type your data in cells A2 to A10. Don't leave any gaps in your data. Step 2: Click a blank cell (for example, click cell B2) and then type =QUARTILE(A2:A10,1).