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

Exercise 20

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.
The data for Prob. 6-13 found in C06Data Excel workbook shows the weight of a set of castings (in kilograms) being made in the Fillmore Metalwork foundry. Construct an Excel spreadsheet to compute the mean and standard deviation using formulas (6.15) and (6.19). Verify your results using Excel functions.