We calculate the following values using the data given in the
above problem with the help of EXCEL SHEET.
Data sheet is longer ,so i unable to upload data file.
|
Mean = |
80.25095928 |
|
|
|
|
|
|
|
Standard deviation = |
6.703880411 |
|
|
|
|
|
|
|
Lower Specification Limit or LSL = |
62.6 |
(given) |
|
|
|
|
|
Upper Specification Limit or USL = |
101.8 |
(given) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
cpu=(USL-Mean)/(3*standard deviation) |
|
|
|
|
|
|
cpl=(Mean-LSL)/(3*standard deviation) |
|
|
|
|
|
|
process performance(ppk)=min(cpu,cpl)/(6*standard
deviation) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
cpu = |
1.071471019 |
|
|
|
|
|
|
|
cpl = |
0.877648874 |
|
|
|
|
|
|
|
min(cpu,cpl) = |
0.877648874 |
|
|
|
|
|
|
|
ppk = |
0.021819424 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
RESULT: |
|
|
|
|
|
|
|
|
|
long term process performance (ppk) for the given data with
lower specification 62.6 |
|
and
upper specification 101.8 is equal to 0.0218194. |
|
|
|
|
|
|
|
|
|
|
|
|
|