#Box plots on excel statplus series#
#Box plots on excel statplus mac#

This makes sense, the median is the average of the middle two numbers.Ħ. The first quartile (Q1) is greater than 25 of the data and less than the other 75. Q 2 = 1/2*(n+1)th value = 1/2*(8+1)th value = 4 1/2th value = 8 + 1/2 * (10-8) = 9. Construction of a box plot is based around a dataset’s quartiles, or the values that divide the dataset into equal fourths. 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). 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). Microsoft has crippled Excels most powerful tools in OS X.

#Box plots on excel statplus mac#

Forgive the glibness, but the state of Mac Office is a bloated horror show. 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. Answer (1 of 2): In a Parallels VM running Windows. Main Menu by School by Literature Title by Subject by Study Guides Textbook Solutions Expert Tutors Earn. Therefore, in this example, 35 is considered an outlier. Once StatPlus is open it might look as shown below The StatPlus menu is circled from MATH 1053 at University of South Australia. 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. It features a detailed migration guide for users switching from Analysis Toolpak to StatPlus:mac and has the Excel interface you already know StatPlus:mac LE is fully compatible with Excel 20042021 and is the Microsoft recommended replacement of its own. Q 3 = 15.Įxplanation: the interquartile range (IQR) is defined as the distance between the 1st quartile and the 3rd quartile. This handy add-on replaces Microsoft Analysis Toolpak in Excel 2008-2021 for Mac. 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. The x in the box represents the mean (also 8 in this example).

#Box plots on excel statplus series#

Right-click on the chart, select the Format Data Series option, then select the Show inner points option. Step 2: Select the Box and Whisker option, which specifies the Box and Whisker plot. You will have several graphical options under the Charts section. 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). Step 1: Select the data and navigate to the Insert option in the Excel ribbon.