ELEMENTARY APPLIED STATISTICS
ELEMENTARY APPLIED STATISTICS STAT 280
Popular in Course
Popular in Statistics
This 4 page Class Notes was uploaded by Miss Sabina Grimes on Monday October 19, 2015. The Class Notes belongs to STAT 280 at Rice University taught by Staff in Fall. Since its upload, it has received 8 views. For similar materials see /class/225041/stat-280-rice-university in Statistics at Rice University.
Reviews for ELEMENTARY APPLIED STATISTICS
Report this Material
What is Karma?
Karma is the currency of StudySoup.
Date Created: 10/19/15
Page 1 of4 How to create a BoxPlotBox and Whisker Chart in Excel Article ID 155130 00 80 Last Review January 7 2005 60 40 Revision 30 20 0 This article was previously published under Q155130 SUMMARY Microsoft Excel charts do not include a BoxPlotBox amp Whisker chart type However you can create a reasonable representation of this type of chart by following the steps outlined in this article MORE INFORMATION To create a sample BoxPlotBox and Whisker chart use the appropriate method for your version of Excel Excel 2004 X 2001 and 98 1 In a new worksheet type the following data Al Statistic Bl a Cl b Dl c A2 median B2 40 C2 45 D2 50 A3 ql B3 20 C3 22 D3 30 A4 min B4 10 C4 15 D4 18 A5 max B5 100 C5 110 D5 90 A6 q3 B6 70 C6 75 D6 57 See matrix below 2 Select cells A1D6 On the Insert menu click Chart 3 On the Standard types tab click Stock under Chart type and then click the fourth 39 chart subtype The following explanation appears below the chart subtype VolumeOpenHighLowClose Requires five series of values in this order 4 Click Next 5 On the Data Range tab click Rows under Series in and then click Next 6 On the Legend tab click to clear the Show legend check box 7 On the Axes tab click to clear the Value Y Axis check box under Secondary 39 axis and then click Finish 8 Click once on any one of the colored columns to select the series Do not click one of the white columns 9 On the Chart menu click Chart Type Under Chart type click Line and then click 39 OK A line that connects the three white columns appears in the chart Page 2 of4 10 Click once on the line and then click Selected Data Series on the Format menu For Line select NONE for Marker select CUSTOM then your preference a horizontal line works well default is an X Step 1 Data statistic A b c median 40 45 50 q1 20 22 30 min 10 15 18 max 100 110 90 q3 70 75 57 11 You will probably want to right click in the plot area and select Format Plot Area and select Area NONE Also get rid of the horizontal lines by clicking near the top and under Chart Options Gridlines Clear Value Y Axis Major Gridlines Dr D Recc Acceptable would be nice to have full line for the median In Excel 2004 for Mac 1 Click the Colors and Line tab Under Line for Color click No Line 2 Under Marker select the plus sign 3 In the Foreground list click the black color In the Background list click No Color Click OK In Excel X and earlier Page 3 of4 Click the Patterns tab Under Line click None Under Marker click Custom In the Style list click the plus sign In the Foreground list click the black color In the Background list click No Color Click OK Excel 50 and Excel 70 In a new worksheet type the following data A1 Statistic Bl a C1 10 D1 3 A2 median B2 40 C2 45 D2 50 A3 ql B3 20 C3 22 D3 30 A4 min B4 10 C4 15 D4 18 A5 max B5 100 C5 110 D5 90 A6 q3 B6 70 C6 75 D6 57 Select cells A1D6 On the Insert menu point to Chart and then click On This Sheet Click and drag the area for the chart In the Step 1 of 5 dialog box of the ChartWizard click Next In the Step 2 of 5 dialog box click the Combination chart type and then click Next In the Step 3 of 5 dialog box click the sixth chart style and then click Next The following message appears in an Alert Box A volumeopenhighlowclose stock chart must contain five series Click OK In the Step 4 of 5 dialog box click Rows under Data Series in and then click Next In the Step 5 of 5 dialog box click No under Add a Legend and then click Finish Doubleclick the chart to activate it On the Insert menu click Axes Under Secondary Axis click to clear the Value Y Axis check box and then click OK Click once on any one of the colored columns to select the series Do not click one of the white columns On the Format menu click Chart Type In the list of chart types click Line and then click OK A line that connects the three white columns appears in the chart Page 4 of4 12 Click once on the line and then click Selected Data Series on the Format menu 13 Click the Patterns tab Under Line click None 14 Under Marker click Custom In the Style list click the plus sign In the Foreground list click the black color In the Background list click None Click OK REFERENCES Excel X and later versions For more information about creating charts click Excel Help on the Help menu type about charts click Search and then click a topic to view it Excel 98 and Excel 2001 For more information about creating charts click the Office Assistant type charts click Search and then click a topic to view it Note If the Assistant is hidden click the Office Assistant button on the Standard toolbar Excel 70 For more information about creating charts click Answer Wizard on the Help menu and type how do I create a chart Excel 50 For more information about creating charts choose the Search button in Help and type charts APPLIES TO Microsoft Excel 95 Standard Edition Microsoft Excel 50a Microsoft Excel 95a Microsoft Excel 50 Standard Edition Microsoft Excel 50c Microsoft Excel 98 for Macintosh Microsoft Excel 50 for Macintosh Microsoft Excel 50a for Macintosh Microsoft Excel 2001 for Mac Microsoft Excel 2004 for Mac Thanks to Laura Bruynell Rice University STAT 280 2102005 for providing this reference Source URL httpsupportmicrosoftcomdefaultaspxscidkb39enus155130