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

Exercise 23

Note: Data for many of the problems in this chapter can be found in the Excel workbook C08Data.xlsx on the Student Companion Site. Click on the appropriate worksheet tab as noted in the problem (e.g., Prob. 8-6, etc.) to access the data.
Samples for three parts made at River City Parts Co. were taken as shown in the worksheet tab Prob. 8-20 in the Excel file C08Data.xlsx on the Student Companion Site for this chapter. Data set 1 is for part 1, data set 2 is for part 2, and data set 3 is for part 3.
a. Calculate the mean and standard deviations for each part and compare them to the following specification limits:

b. Will the production process permit an acceptable fit of all parts into a slot with a specification of 5 ± 0.081 at least 99.73 percent of the time?