Excel for statistics topic list > Find an Interquartile Range Excel 2007
How to Find an Interquartile Range Excel 2007
The interquartile range(IQR) is a measure of how dispersed your data is around a mean. It tells you where the middle fifty percent of your data is. It’s normally used along with the mean and median of a data set to give you a general picture about your data. There are several ways to find an IQR (the easiest of which is probably our online interquartile range calculator). However, you can also Find an Interquartile Range in Excel 2007 in a few easy steps.
Interquartile Range Excel 2007: Steps
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). You’ll need to replace A2:A10 with the actual values from your data set. For example, if you typed your data into B2 to B50, the equation will be =QUARTILE(B2:B50,1). The “1” in this Excel formula(A2:A10,1) represents the first quartile (i.e the point lying at 25% of the data set).
Step 3: 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” in this Excel formula (A2:A10,3) represents the third quartile (i.e. the point lying at 75% of the data set).
Step 4: Click a third blank cell (for example, click cell B4) and then type =B3-B2. If your quartile functions from Step 2 and 3 are in different locations, change the cell references.
Step 5:Press the “Enter” key. Excel will return the IQR in the cell you clicked in Step 4
Check out our YouTube channel for more Excel stats tips.