Adjustments were made in the process discussed in Problem 10, and 25 more samples were taken. The
Question:
Adjustments were made in the process discussed in Problem 10, and 25 more samples were taken. The results are given in the Ch04Data.xlsx file for Prob04-11 on the Student Companion Site. What can you observe about the process? What is its capability for producing within acceptable limits now?
Machining Process II | |||||||||||||||||||||||||||
Frequency Distribution and Histogram | |||||||||||||||||||||||||||
This spreadsheet is designed to handle up to 150 observations. Enter data ONLY in yellow-shaded cells. | |||||||||||||||||||||||||||
Nominal specification | 0.515 | Data Minimum | 0.5130 | ||||||||||||||||||||||||
Upper specification limit | 0.522 | Data Maximum | 0.5190 | ||||||||||||||||||||||||
Lower specification limit | 0.508 | ||||||||||||||||||||||||||
Enter number of cells below (10 or less) | 0.5750 | Cp | 0.7644 | Cp | 1.3838 | ||||||||||||||||||||||
Number of Cells | 8 | 0.0065 | Cpl | 1.5267 | Cpl | 1.4866 | |||||||||||||||||||||
Cpu | 0.0020 | Cpu | 1.281 | ||||||||||||||||||||||||
DATA | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | Enter smallest and largest limits for the frequency distribution below. | Cpk | 0.0020 | Cpk | 1.281 | |||||||
1 | 0.513 | 0.518 | 0.516 | 0.519 | 0.514 | The lower limit should be slightly less than the data minimum. | |||||||||||||||||||||
2 | 0.515 | 0.515 | 0.513 | 0.517 | 0.516 | The upper limit should be slightly larger than the data maximum. | |||||||||||||||||||||
3 | 0.513 | 0.514 | 0.516 | 0.515 | 0.519 | ||||||||||||||||||||||
4 | 0.516 | 0.517 | 0.517 | 0.514 | 0.515 | Lower limit | 0.5130 | ||||||||||||||||||||
5 | 0.516 | 0.514 | 0.515 | 0.515 | 0.516 | Upper limit | 0.5200 | ||||||||||||||||||||
6 | Cell width | 0.001 | |||||||||||||||||||||||||
7 | |||||||||||||||||||||||||||
8 | From | To (inclusive) | Frequency | ||||||||||||||||||||||||
9 | Cell | -Infinity | 0.5130 | 3 | |||||||||||||||||||||||
10 | 1 | 0.5130 | 0.5139 | 0 | |||||||||||||||||||||||
2 | 0.5139 | 0.5148 | 4 | ||||||||||||||||||||||||
3 | 0.5148 | 0.5156 | 6 | ||||||||||||||||||||||||
Process Capability Index Calculations |
Transcribed Image Text:
Frequency 7 6 5 t 3 2 1 0 Frequency all. 0.5130 0.5139 0.5148 0.5156 0.5165 0.5174 0.5183 0.5191 0.5200 Cell Upper Limit Frequency
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
An Introduction To Six Sigma And Process ImprovementISBN: 9781133604587 2nd Edition Authors: James R. Evans, William M. Lindsay
Question Posted:
|