![]() ![]() Again, you can verify this number by using the QUARTILE.EXC function or looking at the box and whisker plot. Determine the mean when only given the box and whisker plot with help from a professional private tutor in this free video clip. ![]() 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. Determining the mean when only given the box and whisker plot will require you to pay close attention to the number line. 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.ĥ. 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). Half of the values lie below it and half above. Median (Q2) It is the mid-point of the dataset. First Quartile (Q1) 25 of the data lies below the First (lower) Quartile. Minimum It is the minimum value in the dataset excluding the outliers. Most of the time, you can cannot easily determine the 1st quartile and 3rd quartile without performing calculations.ġ. A box plot gives a five-number summary of a set of data which is. 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. On the Insert tab, in the Charts group, click the Statistic Chart symbol.Įxplanation: the interquartile range (IQR) is defined as the distance between the 1st quartile and the 3rd quartile. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |