Question: A machining process has a required dimension on a part of 0.515 0.007 inches. Twenty-five parts were measured as found in the Ch04Data.xlsx file
A machining process has a required dimension on a part of 0.515 ± 0.007 inches. Twenty-five parts were measured as found in the Ch04Data.xlsx file for Prob04-10 on the Student Companion Site. What is its capability for producing within acceptable limits?
| Machining Process I - Process Capability Analysis | ||||||||||||||||||||||
| 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.4970 | |||||||||||||||||||
| Upper specification limit | 0.522 | Data Maximum | 0.5270 | |||||||||||||||||||
| Lower specification limit | 0.508 | |||||||||||||||||||||
| Enter number of cells below (10 or less) | ||||||||||||||||||||||
| Number of Cells | 10 | |||||||||||||||||||||
| 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. | ||||||
| 1 | 0.497 | 0.516 | 0.517 | 0.504 | 0.520 | The lower limit should be slightly less than the data minimum. | ||||||||||||||||
| 2 | 0.506 | 0.518 | 0.514 | 0.513 | 0.524 | The upper limit should be slightly larger than the data maximum. | ||||||||||||||||
| 3 | 0.527 | 0.517 | 0.513 | 0.519 | 0.520 | |||||||||||||||||
| 4 | 0.518 | 0.522 | 0.515 | 0.513 | 0.518 | Lower limit | 0.4950 | |||||||||||||||
| 5 | 0.505 | 0.516 | 0.516 | 0.512 | 0.514 | Upper limit | 0.5300 | |||||||||||||||
| 6 | Cell width | 0.0035 | ||||||||||||||||||||
| 7 | ||||||||||||||||||||||
| 8 | From | To (inclusive) | Frequency | |||||||||||||||||||
| 9 | Cell | -Infinity | 0.4950 | 0 | ||||||||||||||||||
| 10 | 1 | 0.4950 | 0.4985 | 1 | ||||||||||||||||||
| 2 | 0.4985 | 0.5020 | 0 | |||||||||||||||||||
| 3 | 0.5020 | 0.5055 | 2 | |||||||||||||||||||
| Process Capability Index Calculations | 4 | 0.5055 | 0.5090 | 1 | ||||||||||||||||||
| Average | 0.5150 | 5 | 0.5090 | 0.5125 | 1 | |||||||||||||||||
| Standard deviation | 0.0065 | 6 | 0.5125 | 0.5160 | 9 | |||||||||||||||||
| 7 | 0.5160 | 0.5195 | 6 | |||||||||||||||||||
| 8 | 0.5195 | 0.5230 | 3 | |||||||||||||||||||
| Cp | 0.3567 | 9 | 0.5230 | 0.5265 | 1 | |||||||||||||||||
| Cpl | 0.3547 |
Step by Step Solution
★★★★★
3.53 Rating (174 Votes ) There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
For sample statistics for the Machining Process I see sprea... View full answer
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
| ||||||||||||||||||||
