Managing for Quality and Performance Excellence 10th Edition by James Evans ,William Lindsay

Exercise 14

Note: Data sets for many problems in this chapter are available in the Excel workbook C06Data.xlsx on the Student Companion Site. Click on the appropriate worksheet tab as noted in the problem (e.g., Prob. 6-1) to access the data. In addition, the spreadsheet templates illustrated in the chapter are also available to aid in solving many of these problems.
Use the data for Twenty-first Century Laundry for the weights of loads of clothes processed through their washing department in a week. (See Prob. 6-11 in C06Data workbook.)
a. Apply the Excel Descriptive Statistics tool to compute the mean, standard deviation, and other relevant statistics, and interpret the results in a meaningful fashion.
b. Use the Frequency Distribution and Histogram Excel template to construct a frequency distribution and histogram for the data. From what type of distribution might you suspect the data are drawn? Experiment with the number of cells to create a visually appealing histogram and use the Excel Histogram tool to verify the results.