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

Exercise 32

Note: Data sets for many problems in this chapter are available in the Excel workbook C09Data.xlsx on the Student Companion Site. Click the appropriate worksheet tab as noted in the problem ( e.g. Prob. 9-12, etc.) to access the data. We also recommend using the ASQ Learn about Quality Excel templates noted in this chapter to facilitate your solutions to appropriate problems.
The number of defects found in 25 samples of 100 Malossdientes Candy Company lemon drops taken on a daily basis from a production line over a five-week period is given in the worksheet Prob. 9-18.
a. Compute dpmo and find the sigma level.
b. Plot these data on a run chart. Can you identify any special causes?
c. Plot the data on the appropriate control chart. Does this confirm your answer to part (b) or does it provide better information?