SPC-CPK分析Excel版有正态分布图表格推荐下载.xlsx

1、NO测定 D A T A11.0201.0211.0221.0211.0211.014=SL21.0191.0201.0211.0191.01931.0211.0221.0201.0211.01941.0211.0221.0211.0191.02251.0201.0211.0221.0211.02161.0191.0201.0211.0191.01971.0211.0221.0201.0211.01981.0211.0221.0211.0191.02291.0211.0221.0211.0211.021101.0201.0211.0191.0191.019111.0211.0221.0201.

2、0211.019121.0211.0221.0211.0191.022131.0201.0211.0221.0211.021141.0191.0201.0211.0191.019基基准准表表 工程能力的有无是按照如下基准来判断151.0211.0221.0201.0211.019A+2.0 Cpk 1.67:#优,应当保持161.0211.0221.0211.0191.022A 1.67 Cpk 1.33:#能力良好，状态稳定，但应尽力提升为A级171.0211.0221.0211.0211.021B 1.33 Cpk 1.00:#状态一般，制程因素稍有变异即有产生不良的危险，应利用各种资源及

3、方法将其提升为 A级181.0201.0211.0191.0191.019C 1.00 Cpk 0.67:#差 制程不良较多，必须提升其能力191.0221.0201.0211.0191.021D 0.67 Cpk :#不可接受,其能力太差，应考虑重新整改设计制程201.0211.0221.0211.0201.022结结论论212223 规格中心（）与 测定 平均值的差异:#24251.014=SL262728293031321.02=33LOT NOGD201601测测定定者者样样品品数数（n）100下下限限规规格格（SL）1.014测测定定设设备备千分尺测测定定日日最最大大（Max）1.0

4、22上上限限规规格格（SU）1.026客客户户名名Guangda做做成成者者最最小小（Min）1.019规规格格中中心心（）1.020规规格格1.02ccs做做成成日日平平均均（X-bar）1.021Cp1.88测测定定项项目目外径标标准准偏偏差差（）0.001Cpk1.701.696产产品品名名CCS上上限限不不良良PPM0.0不不良良率率工工程程名名下下限限不不良良PPM0.00 PPM特特别别备备注注光大科技1.02CCS外径SPC控制图，共生产了20个批次SPCSPC质质量量分分析析表表1.021.021.021.021.021.021.021.021.021.021.021.020

5、5 10 15 20 25 30 35 40 45 1.026=SU0.0011.026=SUQ3拉丝车间2016年1月份A 1.67 Cpk 1.33:#能力良好，状态稳定，但应尽力提升为A级B 1.33 Cpk 1.00:#状态一般，制程因素稍有变异即有产生不良的危险，应利用各种资源及方法将其提升为 A级C 1.00 Cpk 0.67:#差 制程不良较多，必须提升其能力D 0.67 Cpk :#不可接受,其能力太差，应考虑重新整改设计制程1.021.021.021.021.021.021.021.021.021.021.021.020 5 10 15 20 25 30 35 40 45 1

6、.0191.0191.0191.0201.0201.0211.0211.0211.0221.0221.0221.0230.000K0.0971.0121.696 1.0121.0120.000 1.0121.0190.0000.0001.0121.01924.00024.0001.0121.0200.0000.000 1.0121.0200.0000.0001.0131.02014.00014.0001.0131.0210.0000.0001.0131.02142.00042.0001.0131.0210.0000.0001.0131.0220.0000.0001.0131.02220.000

7、20.0001.0131.0230.0000.0001.0131.0230.0000.0001.0141.0230.0001.0141.0240.0001.0141.0240.0001.0141.0240.0001.0141.0250.0001.0141.0250.0001.0141.0260.0001.0141.0260.0001.0141.0260.0001.0151.0270.0001.0151.0270.0001.0151.0270.0001.0151.0280.0001.0151.0280.0001.0151.0290.0001.0151.0290.0001.0151.0290.00

8、01.0161.0300.0001.0161.0300.0001.0161.0300.0001.0161.0310.0001.016100.0001.0161.0161.0161.0171.0171.0171.0171.0171.0171.0171.0171.0171.0181.0181.0181.0181.0181.0181.0181.0181.0191.0191.0191.0191.0191.0191.0191.0191.0201.0201.0201.0201.0201.0201.0201.0201.0201.0201.0211.0211.0211.0211.0211.0211.0211.

9、0211.0221.0221.0221.0221.0221.0221.0221.0221.0231.0231.0231.0231.0231.0231.0231.0231.0231.0241.0241.0241.0241.0241.0241.0241.0241.0251.0251.0251.0251.0251.0251.0251.0251.0261.0261.0261.0261.0261.0261.0261.0261.0261.0271.0271.0271.0271.0271.0271.0271.0271.0281.0281.0281.0281.0281.0281.0281.0281.0291.

10、0291.0291.0291.029UUE1.0210.001（8.317）（34.583）0.0006.2832.5070.3990.0001.0210.001（8.204）（33.652）0.0006.2832.5070.3990.0001.0210.001（8.091）（32.735）0.0006.2832.5070.3990.0001.0210.001（7.979）（31.830）0.0006.2832.5070.3990.0001.0210.001（7.866）（30.937）0.0006.2832.5070.3990.0001.0210.001（7.753）（30.058）0.00

11、06.2832.5070.3990.0001.0210.001（7.641）（29.191）0.0006.2832.5070.3990.0001.0210.001（7.528）（28.336）0.0006.2832.5070.3990.0001.0210.001（7.415）（27.495）0.0006.2832.5070.3990.0001.0210.001（7.303）（26.666）0.0006.2832.5070.3990.0001.0210.001（7.190）（25.849）0.0006.2832.5070.3990.0001.0210.001（7.078）（25.046）0.00

12、06.2832.5070.3990.0001.0210.001（6.965）（24.255）0.0006.2832.5070.3990.0001.0210.001（6.852）（23.477）0.0006.2832.5070.3990.0001.0210.001（6.740）（22.711）0.0006.2832.5070.3990.0001.0210.001（6.627）（21.959）0.0006.2832.5070.3990.0001.0210.001（6.514）（21.218）0.0006.2832.5070.3990.0001.0210.001（6.402）（20.491）0.00

13、06.2832.5070.3990.0001.0210.001（6.289）（19.776）0.0006.2832.5070.3990.0001.0210.001（6.176）（19.074）0.0006.2832.5070.3990.0001.0210.001（6.064）（18.385）0.0006.2832.5070.3990.0001.0210.001（5.951）（17.708）0.0006.2832.5070.3990.0001.0210.001（5.839）（17.044）0.0006.2832.5070.3990.0001.0210.001（5.726）（16.393）0.00

14、06.2832.5070.3990.0001.0210.001（5.613）（15.754）0.0006.2832.5070.3990.0001.0210.001（5.501）（15.128）0.0006.2832.5070.3990.0001.0210.001（5.388）（14.515）0.0006.2832.5070.3990.0001.0210.001（5.275）（13.914）0.0006.2832.5070.3990.0001.0210.001（5.163）（13.327）0.0006.2832.5070.3990.0001.0210.001（5.050）（12.751）0.00

15、06.2832.5070.3990.0001.0210.001（4.937）（12.189）0.0006.2832.5070.3990.0001.0210.001（4.825）（11.639）0.0006.2832.5070.3990.0001.0210.001（4.712）（11.102）0.0006.2832.5070.3990.0001.0210.001（4.599）（10.578）0.0006.2832.5070.3990.0001.0210.001（4.487）（10.066）0.0006.2832.5070.3990.0001.0210.001（4.374）（9.567）0.000

16、6.2832.5070.3990.0001.0210.001（4.262）（9.080）0.0006.2832.5070.3990.0001.0210.001（4.149）（8.607）0.0006.2832.5070.3990.0001.0210.001（4.036）（8.146）0.0006.2832.5070.3990.0001.0210.001（3.924）（7.697）0.0006.2832.5070.3990.0001.0210.001（3.811）（7.262）0.0016.2832.5070.3990.0001.0210.001（3.698）（6.839）0.0016.2832

17、.5070.3990.0001.0210.001（3.586）（6.429）0.0026.2832.5070.3990.0011.0210.001（3.473）（6.031）0.0026.2832.5070.3990.0011.0210.001（3.360）（5.646）0.0046.2832.5070.3990.0011.0210.001（3.248）（5.274）0.0056.2832.5070.3990.0021.0210.001（3.135）（4.915）0.0076.2832.5070.3990.0031.0210.001（3.023）（4.568）0.0106.2832.5070.

18、3990.0041.0210.001（2.910）（4.234）0.0146.2832.5070.3990.0061.0210.001（2.797）（3.912）0.0206.2832.5070.3990.0081.0210.001（2.685）（3.604）0.0276.2832.5070.3990.0111.0210.001（2.572）（3.307）0.0376.2832.5070.3990.0151.0210.001（2.459）（3.024）0.0496.2832.5070.3990.0191.0210.001（2.347）（2.753）0.0646.2832.5070.3990.0

19、251.0210.001（2.234）（2.495）0.0826.2832.5070.3990.0331.0210.001（2.121）（2.250）0.1056.2832.5070.3990.0421.0210.001（2.009）（2.018）0.1336.2832.5070.3990.0531.0210.001（1.896）（1.798）0.1666.2832.5070.3990.0661.0210.001（1.783）（1.590）0.2046.2832.5070.3990.0811.0210.001（1.671）（1.396）0.2486.2832.5070.3990.0991.02

20、10.001（1.558）（1.214）0.2976.2832.5070.3990.1181.0210.001（1.446）（1.045）0.3526.2832.5070.3990.1401.0210.001（1.333）（0.888）0.4116.2832.5070.3990.1641.0210.001（1.220）（0.745）0.4756.2832.5070.3990.1891.0210.001（1.108）（0.613）0.5416.2832.5070.3990.2161.0210.001（0.995）（0.495）0.6106.2832.5070.3990.2431.0210.001

21、（0.882）（0.389）0.6786.2832.5070.3990.2701.0210.001（0.770）（0.296）0.7446.2832.5070.3990.2971.0210.001（0.657）（0.216）0.8066.2832.5070.3990.3211.0210.001（0.544）（0.148）0.8626.2832.5070.3990.3441.0210.001（0.432）（0.093）0.9116.2832.5070.3990.3631.0210.001（0.319）（0.051）0.9506.2832.5070.3990.3791.0210.001（0.207

22、）（0.021）0.9796.2832.5070.3990.3911.0210.001（0.094）（0.004）0.9966.2832.5070.3990.3971.0210.0010.019（0.000）1.0006.2832.5070.3990.3991.0210.0010.131（0.009）0.9916.2832.5070.3990.3961.0210.0010.244（0.030）0.9716.2832.5070.3990.3871.0210.0010.357（0.064）0.9386.2832.5070.3990.3741.0210.0010.469（0.110）0.8966.2

23、832.5070.3990.3571.0210.0010.582（0.169）0.8446.2832.5070.3990.3371.0210.0010.695（0.241）0.7866.2832.5070.3990.3131.0210.0010.807（0.326）0.7226.2832.5070.3990.2881.0210.0010.920（0.423）0.6556.2832.5070.3990.2611.0210.0011.033（0.533）0.5876.2832.5070.3990.2341.0210.0011.145（0.656）0.5196.2832.5070.3990.2071

24、.0210.0011.258（0.791）0.4536.2832.5070.3990.1811.0210.0011.370（0.939）0.3916.2832.5070.3990.1561.0210.0011.483（1.100）0.3336.2832.5070.3990.1331.0210.0011.596（1.273）0.2806.2832.5070.3990.1121.0210.0011.708（1.459）0.2326.2832.5070.3990.0931.0210.0011.821（1.658）0.1916.2832.5070.3990.0761.0210.0011.934（1.8

25、70）0.1546.2832.5070.3990.0621.0210.0012.046（2.094）0.1236.2832.5070.3990.0491.0210.0012.159（2.331）0.0976.2832.5070.3990.0391.0210.0012.272（2.580）0.0766.2832.5070.3990.0301.0210.0012.384（2.842）0.0586.2832.5070.3990.0231.0210.0012.497（3.117）0.0446.2832.5070.3990.0181.0210.0012.609（3.405）0.0336.2832.507

26、0.3990.0131.0210.0012.722（3.705）0.0256.2832.5070.3990.0101.0210.0012.835（4.018）0.0186.2832.5070.3990.0071.0210.0012.947（4.344）0.0136.2832.5070.3990.0051.0210.0013.060（4.682）0.0096.2832.5070.3990.0041.0210.0013.173（5.033）0.0076.2832.5070.3990.0031.0210.0013.285（5.397）0.0056.2832.5070.3990.0021.0210.0

27、013.398（5.773）0.0036.2832.5070.3990.0011.0210.0013.511（6.162）0.0026.2832.5070.3990.0011.0210.0013.623（6.564）0.0016.2832.5070.3990.0011.0210.0013.736（6.978）0.0016.2832.5070.3990.0001.0210.0013.849（7.406）0.0016.2832.5070.3990.0001.0210.0013.961（7.845）0.0006.2832.5070.3990.0001.0210.0014.074（8.298）0.00

28、06.2832.5070.3990.0001.0210.0014.186（8.763）0.0006.2832.5070.3990.0001.0210.0014.299（9.241）0.0006.2832.5070.3990.0001.0210.0014.412（9.732）0.0006.2832.5070.3990.0001.0210.0014.524（10.235）0.0006.2832.5070.3990.0001.0210.0014.637（10.751）0.0006.2832.5070.3990.0001.0210.0014.750（11.280）0.0006.2832.5070.39

29、90.0001.0210.0014.862（11.821）0.0006.2832.5070.3990.0001.0210.0014.975（12.375）0.0006.2832.5070.3990.0001.0210.0015.088（12.942）0.0006.2832.5070.3990.0001.0210.0015.200（13.521）0.0006.2832.5070.3990.0001.0210.0015.313（14.113）0.0006.2832.5070.3990.0001.0210.0015.425（14.718）0.0006.2832.5070.3990.0001.0210

30、.0015.538（15.335）0.0006.2832.5070.3990.0001.0210.0015.651（15.966）0.0006.2832.5070.3990.0001.0210.0015.763（16.608）0.0006.2832.5070.3990.0001.0210.0015.876（17.264）0.0006.2832.5070.3990.0001.0210.0015.989（17.932）0.0006.2832.5070.3990.0001.0210.0016.101（18.613）0.0006.2832.5070.3990.0001.0210.0016.214（19

31、.307）0.0006.2832.5070.3990.0001.0210.0016.327（20.013）0.0006.2832.5070.3990.0001.0210.0016.439（20.732）0.0006.2832.5070.3990.0001.0210.0016.552（21.464）0.0006.2832.5070.3990.0001.0210.0016.665（22.208）0.0006.2832.5070.3990.0001.0210.0016.777（22.965）0.0006.2832.5070.3990.0001.0210.0016.890（23.735）0.0006.

32、2832.5070.3990.0001.0210.0017.002（24.517）0.0006.2832.5070.3990.0001.0210.0017.115（25.312）0.0006.2832.5070.3990.0001.0210.0017.228（26.120）0.0006.2832.5070.3990.0001.0210.0017.340（26.941）0.0006.2832.5070.3990.0001.0210.0017.453（27.774）0.0006.2832.5070.3990.0001.0210.0017.566（28.620）0.0006.2832.5070.39

33、90.0001.0210.0017.678（29.478）0.0006.2832.5070.3990.0001.0210.0017.791（30.349）0.0006.2832.5070.3990.0001.0210.0017.904（31.233）0.0006.2832.5070.3990.0000.3190.319 0.3990.3990.3190.319NO测定 D A T A11.0201.0211.0221.0211.0211.014=SL21.0191.0201.0211.0191.01931.0211.0221.0201.0211.01941.0211.0221.0211.0191.02251.0201.0211.0221.0211.02161.0191.0201.0211.0191.01971.0211.0221.0201.0211.01981.0211.0221.0211.0191.0229