Boxplots, 5-Number Summary, Outliers Access tech supplements, videos, and data sets at www.TriolaStats.com TECH CENTER continued Excel 5-Number Summary Use Descriptive Statistics procedure given at the end of Section 3-1 on page 98. XLSTAT Add-In • After Step 3 in the Descriptive Statistics procedure, click the Outputs tab and select Minimum, Maximum, 1st Quartile, Median, 3rd Quartile. Click OK. Excel The Data Analysis add-in provides only the minimum, maximum and median. To obtain quartiles use the following procedure: 1. Click on Insert Function ƒx, select the category Statistical and select the function QUARTILE.INC. 2. Enter the range of data values in the Array box. 3. In the Quart box enter 0 to find the minimum, 1 to find the first 1st Quartile and 2,3,4 to find the remaining values. Boxplots XLSTAT Add-In (Required) 1. Click on the XLSTAT tab in the Ribbon and then click Describing Data. 2. Select Descriptive Statistics from the dropdown menu. 3. Check the Quantitative data box and enter the desired data range. Selecting two or more columns will generate multiple boxplots. If the first row of data contains a label, also check the Variable labels box. 4. Click on the Charts (1) tab and checkmark the Box plots box under Quantitative data. 5. Click OK. Outliers Create a modified boxplot using the above XLSTAT procedure or sort as follows: 1. Click Data tab in the top menu and select the desired range of data values. 2. Click the Sort Smallest to Largest 1ASZ2 button in the ribbon. 3. Examine minimum and maximum values to determine if they are far from other values. 3-3 Measures of Relative Standing and Boxplots 133 R R commands: 5-Number Summary: summary(x) Boxplots: boxplots(x,y,z) Outliers: Outliers are displayed on boxplots (see R command above), or sort data as follows: 1. Use sort(x) command to sort the data in ascending order. 2. Examine minimum and maximum values to determine if they are far from other values. A complete list of R statistical commands is available at TriolaStats.com
RkJQdWJsaXNoZXIy NjM5ODQ=