SPC_CPK分析Excel版

1、NO测定 D A T A140=SL234567891011121314基基准准表表 工程能力的有无是按照如下基准来判断15A+ 2.0 Cpk 1.67 : 优,应当保持16A 1.67 Cpk 1.33 : 能力良好，状态稳定，但应尽力提升为A级17B 1.33 Cpk 1.00 : 状态一般，制程因素稍有变异即有产生不良的危险18，应利用各种资源及方法将其提升为 A级19C 1.00 Cpk 0.67 : 差 ，制程不良较多，必须提升其能力20D 0.67 Cpk : 不可接受,其能力太差，应考虑重新整改设计制程21结结论论2223 规格中心 () 与 测定 平均值的差异 :242540

2、=SL2627282930313250=33LOT NO测测定定者者样样品品数数(n)100下下限限规规格格 (SL)40.00测测定定设设备备定荷重拉伸机测测定定日日最最大大(Max)0.000上上限限规规格格(SU)60.00客客户户名名做做成成者者最最小小(Min)0.000规规格格中中心心()50.00规规格格做做成成日日平平均均(X-bar)#DIV/0!Cp#DIV/0!测测定定项项目目拉伸标标准准偏偏差差()#DIV/0!Cpk#DIV/0!产产品品名名上上限限不不良良PPM0.0母母集集团团推推定定不不良良率率工工程程名名下下限限不不良良PPM0.00 PPM特特别别备备注注工

3、工程程能能力力分分析析表表0.000.000.000.000.000.000.000.000.000.000.000.000 1 1 60=SU#DIV/0!60=SU 工程能力的有无是按照如下基准来判断A 1.67 Cpk 1.33 : 能力良好，状态稳定，但应尽力提升为A级B 1.33 Cpk 1.00 : 状态一般，制程因素稍有变异即有产生不良的危险C 1.00 Cpk 0.67 : 差 ，制程不良较多，必须提升其能力D 0.67 Cpk : 不可接受,其能力太差，应考虑重新整改设计制程0.000.000.000.000.000.000.000.000.000.000.000.000 1

4、 1 0.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.200K#DIV/0!36.200#DIV/0!DATA36.40036.6000.000 36.8000.0000.0000.00037.0000.0000.0000.00037.2000.0000.0000.000 37.4000.0000.0000.00037.6000.0000.0000.00037.8000.0000.0000.00038.0000.0000.0000.00038.2000.0000.0000.00038.4000.0000.0000.00

5、038.6000.0000.0000.00038.8000.0000.0000.00039.0000.0000.0000.00039.2000.0000.00039.4000.0000.00039.6000.0000.00039.8000.0000.00040.0000.0000.00040.2000.0000.00040.4000.0000.00040.6000.0000.00040.8000.0000.00041.0000.0000.00041.2000.0000.00041.4000.0000.00041.6000.0000.00041.8000.0000.00042.0000.0000

6、.00042.2000.0000.00042.4000.0000.00042.6000.0000.00042.8000.0000.00043.0000.0000.00043.2000.0000.00043.4000.00043.60043.80044.00044.20044.40044.60044.80045.00045.20045.40045.60045.80046.00046.20046.40046.60046.80047.00047.20047.40047.60047.80048.00048.20048.40048.60048.80049.00049.20049.40049.60049.

7、80050.00050.00050.20050.40050.60050.80051.00051.20051.40051.60051.80052.00052.20052.40052.60052.80053.00053.20053.40053.60053.80054.00054.20054.40054.60054.80055.00055.20055.40055.60055.80056.00056.20056.40056.60056.80057.00057.20057.40057.60057.80058.00058.20058.40058.60058.80059.00059.20059.40059.

8、60059.80060.00060.20060.40060.60060.80061.00061.20061.40061.60061.80062.00062.20062.40062.60062.80063.00063.20063.40063.60063.80064.00064.20064.40064.60064.80065.000UUE#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV

9、/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/

10、0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.3

11、99#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0

12、!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!

13、#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6

14、.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#

15、DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#D

16、IV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DI

17、V/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.28

18、32.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV

19、/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/

20、0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0

21、!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.

22、5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!

23、#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#

24、DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#D

25、IV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.507

26、0.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DI

27、V/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV

28、/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/

29、0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.3

30、99#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0

31、!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!6.2832.5070.399#DIV/0!#DIV/0!#DIV/