chapter 11 solutions - Chapter 11- SOLUTIONS TO PROBLEMS...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Chapter 11- SOLUTIONS TO PROBLEMS Note: Data sets for several problems in this chapter are available in the Excel workbook C11Data.xls on the CD- ROM accompanying this text. Click on the appropriate worksheet tab as noted in the problem (e.g., Prob. 11-1) to access the data. 1. Apply the Descriptive Statistics and Histogram analysis tools in Excel to compute the mean, standard deviation, and other relevant statistics, as well as a frequency distribution and histogram for the data found in the Prob. 11-1, Excel data set. From what type of distribution might you suspect the data are drawn? Answer 1. One of the advantages of using Excel ® spreadsheets is that a great deal of analysis can be done easily. The summary statistics follow. Also shown is the histogram constructed by using Excel’s ® Data Analysis tools (found under the “Tools” heading on the spreadsheet). For best results in constructing the histogram, it is suggested that students set up their own “bins” so as to provide 7 to 10 approximately equal sized class intervals for the data. Note that if the program finds that the classes shown in the bins do not extend over the upper or lower range of the data, it will automatically compensate by adding a “Less” or “More” category for the outliers. Column1 Mean 3.5910 Standard Error 0.0809 Median 3.6500 Mode 3.6000 Standard Deviation 0.8088 Sample Variance 0.6542 Kurtosis -0.2919 Skewness -0.2404 Range 3.6000 Minimum 1.7000 Maximum 5.3000 Sum 359.1000 Count 100.0000 Confidence Level(95.0%) 0.1605
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 11 - Statistical Thinking and Applications 2 Frequency Histogram 0 5 10 15 20 1. 9 2. 2 5 8 3. 1 4 7 . 0 3 4. 6 5. More Values Frequencies Frequency The conclusion that can be reached from looking at the summary statistics and the histogram is that these data are fairly normally distributed, with some slight skewing to the left. More detailed data can be found in the Excel ® solution spreadsheet P11- 1&2.xls. 2. Use the data for Staunton Steam Laundry for the weights of loads of clothes processed through their washing department in a week. (See Prob. 11-2 in C11Data.xls). Apply the Descriptive Statistics and Histogram tools in Excel to compute the mean, standard deviation, and other relevant statistics, as well as a frequency distribution and histogram for the following data. From what type of distribution might you suspect the data are drawn? Answer 2. The following results were obtained from the Staunton Steam Laundry Data Column1 Mean 34.280 Standard Error 3.241 Median 25.500 Mode 19.000 Standard Deviation 32.412
Background image of page 2
Chapter 11 - Statistical Thinking and Applications 3 Sample Variance 1050.507 Kurtosis 3.847 Skewness 1.756 Range 169.000 Minimum 1.000 Maximum 170.000 Sum 3428.000 Count 100.000 Largest(1) 170.000 Smallest(1) 1.000 Confidence Level(95.0%) 6.431 Frequency Histogram 0 5 10 15 20 25 30 35 40 15 30 45 60 75 90 105 More Measures Frequency Frequency The conclusion that can be reached from looking at the summary statistics and the histogram is that these data are exponentially distributed, with descending frequencies.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 19

chapter 11 solutions - Chapter 11- SOLUTIONS TO PROBLEMS...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online