Menu
On the Insert tab, in the Charts group, click the Statistic Chart symbol.3. Click Box and Whisker.Result:Explanation: the interquartile range (IQR) is defined as the distance between the 1st quartile and the 3rd quartile. In this example, IQR = Q 3 - Q 1 = 15 - 2 = 13.
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.
Oct 08, 2019 By comparing these, you can see which features in Excel for Windows are not included in Excel for the Mac. Analysis ToolPak Guide: This is a supplement to our books for those of you who would like to use Excel’s built-in Analysis ToolPak add-in, rather than StatTools, for statistical analysis.
IQR = 15 + 1.5. 13 = 34.5).
Therefore, in this example, 35 is considered an outlier. As a result, the top whisker extends to the largest value (18) within this range.4. Change the last data point to 34.Result:Explanation: all data points are between -17.5 and 34.5. As a result, the whiskers extend to the minimum value (2) and maximum value (34). Box Plot CalculationsMost of the time, you can cannot easily determine the 1st quartile and 3rd quartile without performing calculations.1. For example, select the even number of data points below.2. On the Insert tab, in the Charts group, click the Statistic Chart symbol.3.
Click Box and Whisker.Result:Explanation: Excel uses the QUARTILE.EXC function to calculate the 1st quartile (Q 1), 2nd quartile (Q 2 or median) and 3rd quartile (Q 3). This function interpolates between two values to calculate a quartile. In this example, n = 8 (number of data points).4.
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. You can verify this number by using the QUARTILE.EXC function or looking at the box and whisker plot.5. Q 2 = 1/2.(n+1)th value = 1/2.(8+1)th value = 4 1/2th value = 8 + 1/2. (10-8) = 9.
This makes sense, the median is the average of the middle two numbers.6. 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. Again, you can verify this number by using the QUARTILE.EXC function or looking at the box and whisker plot.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |