![how to make a box and whiskers plot excel how to make a box and whiskers plot excel](https://i.ytimg.com/vi/09Cx7xuIXig/maxresdefault.jpg)
Again, you can verify this number by using the QUARTILE.EXC function or looking at the box and whisker plot. Modify the data display range, color, title, etc. Optional This is the only process for creating the box plots. With the data selected, click the Insert>Insert Statistic Chart>Box and Whisker command button in the ribbon. Q 3 = 3/4*(n+1)th value = 3/4*(8+1)th value = 6 3/4th value = 12 + 3/4 * (15-12) = 14 1/4. First, select the data range where you want to create the box plot as shown in the figure below. This makes sense, the median is the average of the middle two numbers.Ħ. You can verify this number by using the QUARTILE.EXC function or looking at the box and whisker plot.ĥ. You can also see the median, 1st and 3rd quartile, min, and max values inside the data you input. Q 1 = 1/4*(n+1)th value = 1/4*(8+1)th value = 2 1/4th value = 4 + 1/4 * (5-4) = 4 1/4. The Box and Whisker Plot Maker is using for showing the data sets.
![how to make a box and whiskers plot excel how to make a box and whiskers plot excel](https://www.exceltip.com/wp-content/uploads/2020/01/002-1.png)
In this example, n = 8 (number of data points).Ĥ. This function interpolates between two values to calculate a quartile. For example, select the even number of data points below.Įxplanation: Excel uses the QUARTILE.EXC function to calculate the 1st quartile (Q 1), 2nd quartile (Q 2 or median) and 3rd quartile (Q 3). Most of the time, you can cannot easily determine the 1st quartile and 3rd quartile without performing calculations.ġ. As a result, the whiskers extend to the minimum value (2) and maximum value (34). As a result, the top whisker extends to the largest value (18) within this range.Įxplanation: all data points are between -17.5 and 34.5. Therefore, in this example, 35 is considered an outlier. A data point is considered an outlier if it exceeds a distance of 1.5 times the IQR below the 1st quartile (Q 1 - 1.5 * IQR = 2 - 1.5 * 13 = -17.5) or 1.5 times the IQR above the 3rd quartile (Q 3 + 1.5 * IQR = 15 + 1.5 * 13 = 34.5). In this example, IQR = Q 3 - Q 1 = 15 - 2 = 13. Q 3 = 15.Įxplanation: the interquartile range (IQR) is defined as the distance between the 1st quartile and the 3rd quartile. The 3rd quartile (Q 3) is the median of the second half. The 1st quartile (Q 1) is the median of the first half. The median divides the data set into a bottom half. STEP 5: In our example, let us go to Chart Tools > Design and pick one of the alternate designs. STEP 4: You can further customize the look and feel of your Excel Box and Whisker Plot, by going to Chart Tools > Design / Format. STEP 3: Now you have your Box and Whisker Chart. The x in the box represents the mean (also 8 in this example). STEP 2: Select All Charts > Box and Whisker > OK. On the Insert tab, in the Charts group, click the Statistic Chart symbol.Įxplanation: the middle line of the box represents the median or middle number (8).