搜档网
当前位置:搜档网 › SPC_CPK分析Excel版

SPC_CPK分析Excel版

NO

测定 D A T A 1

1.02 1.02 1.03 1.02 1.01 1.02 1.02 1.030.99=SL 2

1.05 1.04 1.05 1.03 1.05 1.04 1.06 1.043

1.04 1.05 1.04 1.03 1.03 1.05 1.04 1.044

1.04 1.03 1.04 1.05 1.06 1.03 1.04 1.045

1.03 1.04 1.04 1.05 1.03 1.04 1.02 1.046

1.05 1.04 1.06 1.03 1.04 1.04 1.05 1.047

1.05 1.06 1.02 1.04 1.04 1.04 1.05 1.068

1.04 1.03 1.05 1.04 1.05 1.03 1.05 1.059

1.05 1.04 1.04 1.06 1.05 1.05 1.03 1.0410

1.04 1.05 1.04 1.05 1.03 1.04 1.04 1.0411

12

13

14

基准表15

A+? 2.0 > Cpk 16

A ? 1.67 > Cpk 17

B ? 1.33 > Cpk 18

C ? 1.00 > Cpk 19

D ? 0.67 > Cpk : 20

结论21

22

23

? 规格中心24

25

0.99=SL 26

27

28

29

30

31

32

33

LOT NO 样品数(n)

80下限规格 (SL)0.99测定设备最大(Max)

1.060上限规格(SU) 1.09客户名最小(Min)

1.010规格中心(mm) 1.04规格平均(X-bar)

1.040Cp 1.52测定项目标准偏差(σ)

0.011Cpk 1.52产品名上限不良PPM

0.0母集团推定不良率工程名下限不良PPM

0.00PPM

特别备注0 5 10 15 20 25 30 35 1.00

1.09=SU

1.01 1.02 1.02 1.03 1.04 1.04 1.05 1.05 1.06 1.07 1.07

★工程能力的有无是按照如下基准来判断

0 > Cpk ≥ 1.67 : 优,应当保持

7 > Cpk ≥ 1.33 : 能力良好,状态稳定,但应尽力提升为A+级

33 > Cpk ≥ 1.00 : 状态一般,制程因素稍有变异即有产生不良的危险,应利用各种资源及方法将其提升为 A级 0 > Cpk ≥ 0.67 : 差制程不良较多,必须提升其能力

67 > Cpk : 不可接受,其能力太差,应考虑重新整改设计制程

规格中心 (mm) 与测定平均值的差异 :0.000

0.99=SL 1.09=SU

1.04mm

测定者

功率表测定日

做成者

做成日

功率

K?

0.002

1.516

???

0.006????

1.004 1.0070.0000.000 1.010 1.013 1.000 1.000

1.016 1.0190.0000.000 1.023 1.0267.0007.000 1.029 1.03214.00014.000 1.035 1.038 1.000 1.000 1.041 1.04431.00031.000 1.048 1.05120.00020.000 1.054 1.0570.0000.000 1.060 1.063 6.000 6.000 1.066 1.0690.0000.000 1.073 1.0760.0000.000

1.0820.000

1.0880.000

1.0940.000

1.1010.000

1.1070.000

1.1130.000

1.1190.000

1.1260.000

1.1320.000

1.1380.000

1.1440.000

1.1510.000

1.1570.000

1.1630.000

1.1690.000 1.1760.000 1.1820.000 1.1880.000 1.1940.000 1.2010.000 1.2070.000

80.000

0.001

??????U?U??E?

0.971 1.0400.011(6.294)(19.806)0.000

0.972 1.0400.011(6.203)(19.237)0.000

0.973 1.0400.011(6.112)(18.676)0.000

0.974 1.0400.011(6.021)(18.123)0.000

0.975 1.0400.011(5.929)(17.579)0.000

0.976 1.0400.011(5.838)(17.043)0.000

0.977 1.0400.011(5.747)(16.515)0.000

0.978 1.0400.011(5.656)(15.995)0.000

0.979 1.0400.011(5.565)(15.484)0.000

0.980 1.0400.011(5.474)(14.981)0.000

0.981 1.0400.011(5.383)(14.487)0.000

0.982 1.0400.011(5.292)(14.000)0.000

0.983 1.0400.011(5.200)(13.522)0.000

0.984 1.0400.011(5.109)(13.053)0.000

0.985 1.0400.011(5.018)(12.591)0.000

0.986 1.0400.011(4.927)(12.138)0.000

0.987 1.0400.011(4.836)(11.693)0.000

0.988 1.0400.011(4.745)(11.257)0.000

0.989 1.0400.011(4.654)(10.829)0.000

0.990 1.0400.011(4.563)(10.409)0.000

0.991 1.0400.011(4.472)(9.997)0.000

0.992 1.0400.011(4.380)(9.594)0.000

0.993 1.0400.011(4.289)(9.199)0.000

0.994 1.0400.011(4.198)(8.812)0.000

0.995 1.0400.011(4.107)(8.434)0.000

0.996 1.0400.011(4.016)(8.064)0.000

0.997 1.0400.011(3.925)(7.702)0.000

0.998 1.0400.011(3.834)(7.349)0.001

0.999 1.0400.011(3.743)(7.004)0.001

1.000 1.0400.011(3.651)(6.667)0.001

1.001 1.0400.011(3.560)(6.338)0.002

1.002 1.0400.011(3.469)(6.018)0.002

1.003 1.0400.011(3.378)(5.706)0.003

1.004 1.0400.011(3.287)(5.402)0.005

1.005 1.0400.011(3.196)(5.107)0.006

1.006 1.0400.011(3.105)(4.820)0.008

1.007 1.0400.011(3.014)(4.541)0.011

1.008 1.0400.011(

2.923)(4.271)0.014

1.009 1.0400.011(

2.831)(4.009)0.018

1.010 1.0400.011(

2.740)(

3.755)0.023

1.011 1.0400.011(

2.649)(

3.509)0.030

1.012 1.0400.011(

2.558)(

3.272)0.038

1.013 1.0400.011(

2.467)(

3.043)0.048

1.014 1.0400.011(

2.376)(2.822)0.059

1.015 1.0400.011(

2.285)(2.610)0.074

1.016 1.0400.011(

2.194)(2.406)0.090

1.017 1.0400.011(

2.103)(2.210)0.110

1.018 1.0400.011(

2.011)(2.023)0.132

1.019 1.0400.011(1.920)(1.844)0.158

1.020 1.0400.011(1.829)(1.673)0.188

1.021 1.0400.011(1.738)(1.510)0.221

1.022 1.0400.011(1.647)(1.356)0.258

1.023 1.0400.011(1.556)(1.210)0.298

1.024 1.0400.011(1.465)(1.073)0.342

1.025 1.0400.011(1.374)(0.943)0.389

1.026 1.0400.011(1.282)(0.822)0.439

1.027 1.0400.011(1.191)(0.710)0.492

1.028 1.0400.011(1.100)(0.605)0.546

1.029 1.0400.011(1.009)(0.509)0.601

1.030 1.0400.011(0.918)(0.421)0.656

1.031 1.0400.011(0.827)(0.342)0.710

1.032 1.0400.011(0.736)(0.271)0.763

1.033 1.0400.011(0.645)(0.208)0.812

1.034 1.0400.011(0.554)(0.153)0.858

1.035 1.0400.011(0.462)(0.107)0.899

1.036 1.0400.011(0.371)(0.069)0.933

1.037 1.0400.011(0.280)(0.039)0.962

1.038 1.0400.011(0.189)(0.018)0.982

1.039 1.0400.011(0.098)(0.005)0.995 1.040 1.040 1.0400.011(0.007)(0.000) 1.000

1.041 1.0400.0110.084(0.004)0.996

1.042 1.0400.0110.175(0.015)0.985

1.043 1.0400.0110.267(0.036)0.965

1.044 1.0400.0110.358(0.064)0.938

1.045 1.0400.0110.449(0.101)0.904

1.046 1.0400.0110.540(0.146)0.864

1.047 1.0400.0110.631(0.199)0.819

1.048 1.0400.0110.722(0.261)0.771

1.049 1.0400.0110.813(0.331)0.718

1.050 1.0400.0110.904(0.409)0.664

1.051 1.0400.0110.995(0.495)0.609

1.052 1.0400.011 1.087(0.590)0.554

1.053 1.0400.011 1.178(0.693)0.500

1.054 1.0400.011 1.269(0.805)0.447 1.055 1.0400.011 1.360(0.925)0.397 1.056 1.0400.011 1.451(1.053)0.349 1.057 1.0400.011 1.542(1.189)0.304 1.058 1.0400.011 1.633(1.334)0.263 1.059 1.0400.011 1.724(1.487)0.226 1.060 1.0400.011 1.815(1.648)0.192 1.061 1.0400.011 1.907(1.818)0.162 1.062 1.0400.011 1.998(1.995)0.136 1.063 1.0400.011

2.089(2.182)0.113 1.064 1.0400.011 2.180(2.376)0.093 1.065 1.0400.011 2.271(2.579)0.076 1.066 1.0400.011 2.362(2.790)0.061 1.067 1.0400.011 2.453(

3.009)0.049 1.068 1.0400.011 2.544(3.237)0.039 1.069 1.0400.011 2.636(3.473)0.031 1.070 1.0400.011 2.727(3.717)0.024 1.071 1.0400.011 2.818(3.970)0.019 1.072 1.0400.011 2.909(

4.231)0.015 1.073 1.0400.011 3.000(4.500)0.011 1.074 1.0400.011 3.091(4.778)0.008 1.075 1.0400.011 3.182(

5.063)0.006 1.076 1.0400.011 3.273(5.357)0.005 1.077 1.0400.011 3.364(5.660)0.003 1.078 1.0400.011 3.456(5.971)0.003 1.079 1.0400.011 3.547(

6.290)0.002 1.080 1.0400.011 3.638(6.617)0.001 1.081 1.0400.011 3.729(6.952)0.001 1.082 1.0400.011 3.820(

7.296)0.001 1.083 1.0400.011 3.911(7.649)0.000 1.084 1.0400.011 4.002(

8.009)0.000 1.085 1.0400.011 4.093(8.378)0.000 1.086 1.0400.011 4.185(8.755)0.000 1.087 1.0400.011 4.276(

9.141)0.000 1.088 1.0400.011 4.367(9.534)0.000 1.089 1.0400.011 4.458(9.936)0.000 1.090 1.0400.011 4.549(10.347)0.000 1.091 1.0400.011 4.640(10.765)0.000 1.092 1.0400.011 4.731(11.192)0.000 1.093 1.0400.011 4.822(11.627)0.000 1.094 1.0400.011 4.913(12.071)0.000 1.095 1.0400.011 5.005(12.523)0.000 1.096 1.0400.011 5.096(12.983)0.000 1.097 1.0400.011 5.187(13.451)0.000 1.098 1.0400.011 5.278(13.928)0.000 1.099 1.0400.011 5.369(14.413)0.000 1.100 1.0400.011 5.460(14.907)0.000 1.101 1.0400.011 5.551(15.408)0.000 1.102 1.0400.011 5.642(15.918)0.000 1.103 1.0400.011 5.734(16.437)0.000 1.104 1.0400.011 5.825(16.963)0.000 1.105 1.0400.011 5.916(17.498)0.000 1.106 1.0400.011 6.007(18.041)0.000

1.107 1.0400.011 6.098(18.593)0.000 1.108 1.0400.011 6.189(19.152)0.000 1.109 1.0400.011 6.280(19.720)0.000 1.110 1.0400.011 6.371(20.297)0.000 1.111 1.0400.011 6.462(20.882)0.000 1.112 1.0400.011 6.554(21.474)0.000 1.113 1.0400.011 6.645(2

2.076)0.000 1.114 1.0400.011 6.736(22.685)0.000 1.115 1.0400.011 6.827(2

3.303)0.000

??????

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.0000.3190.319 6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.001

6.283 2.5070.3990.002

6.283 2.5070.3990.002

6.283 2.5070.3990.003

6.283 2.5070.3990.004

6.283 2.5070.3990.006

6.283 2.5070.3990.007

6.283 2.5070.3990.009

6.283 2.5070.3990.012

6.283 2.5070.3990.015

6.283 2.5070.3990.019

6.283 2.5070.3990.024

6.283 2.5070.3990.029

6.283 2.5070.3990.036

6.283 2.5070.3990.044

6.283 2.5070.3990.053

6.283 2.5070.3990.063

6.283 2.5070.3990.075

6.283 2.5070.3990.088

6.283 2.5070.3990.103

6.283 2.5070.3990.119

6.283 2.5070.3990.136

6.283 2.5070.3990.155

6.283 2.5070.3990.175

6.283 2.5070.3990.196

6.283 2.5070.3990.218

6.283 2.5070.3990.240

6.283 2.5070.3990.262

6.283 2.5070.3990.283

6.283 2.5070.3990.304

6.283 2.5070.3990.324

6.283 2.5070.3990.342

6.283 2.5070.3990.358

6.283 2.5070.3990.372

6.283 2.5070.3990.384

6.283 2.5070.3990.392

6.283 2.5070.3990.397

6.283 2.5070.3990.3990.3990.399 6.283 2.5070.3990.398

6.283 2.5070.3990.393

6.283 2.5070.3990.385

6.283 2.5070.3990.374

6.283 2.5070.3990.361

6.283 2.5070.3990.345

6.283 2.5070.3990.327

6.283 2.5070.3990.307

6.283 2.5070.3990.287

6.283 2.5070.3990.265

6.283 2.5070.3990.243

6.283 2.5070.3990.139

6.283 2.5070.3990.121

6.283 2.5070.3990.105

6.283 2.5070.3990.090

6.283 2.5070.3990.077

6.283 2.5070.3990.065

6.283 2.5070.3990.054

6.283 2.5070.3990.045

6.283 2.5070.3990.037

6.283 2.5070.3990.030

6.283 2.5070.3990.025

6.283 2.5070.3990.020

6.283 2.5070.3990.016

6.283 2.5070.3990.012

6.283 2.5070.3990.010

6.283 2.5070.3990.008

6.283 2.5070.3990.006

6.283 2.5070.3990.004

6.283 2.5070.3990.003

6.283 2.5070.3990.003

6.283 2.5070.3990.002

6.283 2.5070.3990.001

6.283 2.5070.3990.001

6.283 2.5070.3990.001

6.283 2.5070.3990.001

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.0000.3190.319 6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000

6.283 2.5070.3990.000 6.283 2.5070.3990.000 6.283 2.5070.3990.000 6.283 2.5070.3990.000 6.283 2.5070.3990.000 6.283 2.5070.3990.000 6.283 2.5070.3990.000

相关主题