For the data from Speciatronics, Ltd. (Prob04-09 in Ch04Data.xlsx on the Student Companion Site), the upper specification
Question:
For the data from Speciatronics, Ltd. (Prob04-09 in Ch04Data.xlsx on the Student Companion Site), the upper specification limit was USL = 5.25, and the lower specification limit was LSL = 1.75. Compute the process capability and discuss its meaning in managerial terms.
Process Capability Analysis | ||||||||||||||||
This spreadsheet is designed to handle up to 150 observations. Enter data ONLY in yellow-shaded cells. | ||||||||||||||||
Nominal specification | 3.50 | Average | 3.5279 | Cp | 1.49 | |||||||||||
Upper tolerance limit | 5.75 | Standard deviation | 0.5042 | Cpl | 1.51 | |||||||||||
Lower tolerance limit | 1.25 | Cpu | 1.47 | |||||||||||||
Cpk | 1.47 | |||||||||||||||
DATA | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | |
1 | 3.42 | 3.15 | 4.27 | 4.75 | 3.77 | 3.72 | 3.97 | 4.21 | 3.74 | 2.92 | 3.64 | 3.42 | 4.29 | 3.42 | 4.18 | |
2 | 2.76 | 4.04 | 3.76 | 3.38 | 3.91 | 3.88 | 3.18 | 3.04 | 4.08 | 3.68 | 2.76 | 4.28 | 2.33 | 3.30 | 4.24 | |
3 | 3.44 | 3.50 | 3.26 | 4.16 | 4.52 | 3.58 | 3.06 | 2.67 | 3.22 | 3.29 | 3.21 | 4.00 | 2.80 | 3.25 | 3.15 | |
4 | 2.79 | 3.92 | 3.29 | 2.94 | 3.41 | 3.15 | 3.20 | 3.37 | 3.91 | 3.23 | 3.98 | 3.55 | 3.28 | 4.09 | 3.70 | |
5 | 3.93 | 3.29 | 3.53 | 2.80 | 4.57 | 3.61 | 3.00 | 3.41 | 3.15 | 3.20 | ||||||
6 | 3.31 | 4.54 | 3.16 | 3.97 | 3.47 | 3.40 | 3.74 | 3.29 | 3.21 | 4.00 | ||||||
7 | 3.77 | 2.97 | 3.75 | 2.77 | 4.01 | 4.41 | 3.36 | 4.24 | 3.31 | 4.54 | ||||||
8 | 3.46 | 3.68 | 2.96 | 2.84 | 3.52 | 3.16 | 2.85 | 3.53 | 3.82 | 2.80 | ||||||
9 | ||||||||||||||||
10 | ||||||||||||||||
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 Improvement
ISBN: 9781133604587
2nd Edition
Authors: James R. Evans, William M. Lindsay
Question Posted: