![1 2 3 4 5 6 7 8 1 2 3 4 5 6 7 8](https://i.ebayimg.com/images/i/150858681251-0-1/s-l1000.jpg)
![1 2 3 4 5 6 7 8 1 2 3 4 5 6 7 8](https://i.ytimg.com/vi/sZCsC-VM_uU/maxresdefault.jpg)
For example, if you typed your data into B2 to B50, the equation is =QUARTILE(B2:B50,1). You’ll need to replace A2:A10 with the actual values from your data set. Step 2: Click a blank cell (for example, click cell B2) and then type =QUARTILE(A2:A10,1). For example, type your data in cells A2 to A10. Step 1: Enter your data into a single Excel column on a worksheet. Watch the video or read the steps below to find an interquartile range in Excel 2007:
#1 2 3 4 5 6 7 8 HOW TO#
Tip: If you don’t see descriptive statistics show in a window, click “Window” on the toolbar, then click “Tile.” Click the Session window (this is where descriptive statistics appear) and then scroll up to see your results.īack to Top Interquartile Range in Excel 2007 How to Find an Interquartile Range Excel 2007 The IQR for the GPA in this particular data set is 1.8. Step 6: Click the “OK” button (a new window will open with the result). Step 3: Click a variable name in the left window and then click the “Select” button to transfer the variable name to the right-hand window.
![1 2 3 4 5 6 7 8 1 2 3 4 5 6 7 8](https://i.etsystatic.com/16996792/r/il/e3b68f/2640200810/il_fullxfull.2640200810_44yt.jpg)
Step 2: Click “Stat,” then click “Basic Statistics,” then click “Display Descriptive Statistics” to open the Descriptive Statistics menu. Step 1: Type your data into a Minitab worksheet. Interquartile Range in Minitab: StepsĮxample question: Find an interquartile range in Minitab for the Grade Point Average (GPA) in the following data set:
![1 2 3 4 5 6 7 8 1 2 3 4 5 6 7 8](https://cdn.architecturendesign.net/wp-content/uploads/2014/09/20-Most-Incredible-Living-Rooms-4.jpg)
This leads to two halves with an even set of numbers, so you can follow the steps above to find the IQR.īack to Top Box Plot interquartile range: How to find itĬan’t see the video? Click here. For example, in the following set of numbers: 1, 2, 5, 6, 7, 9, 12, 15, 18, 19, 27 some statisticians would break it into two halves, including the median (9) in both halves: Q1 = 7 and Q3 = 16.īack to Top Find an interquartile range for an odd set of numbers: Alternate MethodĪs you may already know, nothing is “set in stone” in statistics: when some statisticians find an interquartile range for a set of odd numbers, they include the median in both both quartiles. Q1 is the median (the middle) of the lower half of the data, and Q3 is the median (the middle) of the upper half of the data.