当前位置:文档之家› SPC_CPK分析Excel版有正态分布图

SPC_CPK分析Excel版有正态分布图

NO

测定 D A T A 1

5.31 5.20 5.35 5.37 5.28 4.8=SL 2

5.23 5.24 5.20 5.31 5.343

5.37 5.36 5.37 5.34 5.454

5.45 5.24 5.28 5.37 5.365

5.45 5.38 5.45 5.24 5.326

5.36 5.39 5.31 5.25 5.347

5.38 5.24 5.28 5.37 5.258

5.37 5.38 5.45 5.24 5.249

5.32 5.39 5.31 5.25 5.2710

5.37 5.42 5.23 5.20 5.2311

5.29 5.28 5.37 5.37 5.2912

5.28 5.38 5.45 5.24 5.4313

5.29 5.39 5.31 5.25 5.2714

5.28 5.42 5.23 5.24 5.20基准表★ 工程能力的有无是按照如下基准来判断15

5.24 5.28 5.37 5.29 5.45A+? 2.0 > Cpk ≥ 1.67 : 优,应当保持16

5.38 5.45 5.37 5.42 5.23A ? 1.67 > Cpk ≥ 1.33 : 能力良好,状态稳定,但应尽力提升为17

5.39 5.31 5.29 5.28 5.37 B ? 1.33 > Cpk ≥ 1.00 : 状态一般,制程因素稍有变异即有产生不18

5.26 5.39 5.28 5.38 5.45C ? 1.00 > Cpk ≥ 0.67 : 差 制程不良较多,必须提升其能力19

5.38 5.42 5.29 5.39 5.31 D ? 0.67 > Cpk : 不可接受,其能力太差,应考虑重新整改设计制20

5.30 5.37 5.39 5.31 5.25结论21

22

23

? 规格中心 (μ) 与 测定 平均值的差异 :24

25

4.8=SL 26

27

28

29

30

31

32

5.3=μ33

LOT NO 测定者样品数(n)

100下限规格 (SL) 4.80测定设备功率表测定日最大(Max)

5.450上限规格(SU) 5.80客户名做成者最小(Min)

5.200规格中心(μ) 5.30规格做成日平均(X-bar)

5.327Cp 2.33测定项目功率标准偏差(σ)

0.072Cpk 2.20 2.202产品名上限不良PPM

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

0.00PPM

特别备注工程能力分析表

0 2 4 6 8 10 12 14 16 18 5.17 5.20 5.23 5.26 5.29 5.33 5.36 5.39

55.0000.9179.917

9.917

56.0000.9339.9339.933

57.0000.9509.9509.950

58.0000.9679.9679.967

59.0000.9839.9839.983

5.0000.0839.083

有变异即有产生不良的危险,应利用各种资源及方法将其提升为 A级

0.967

5.169 5.200 5.231 5.263 5.294 5.325 5.356 5.388 5.419 5.450 5.481 5.513

0.010 K???

0.053 4.610

2.202 4.620??? 4.630

0.031???? 4.640

5.1840.0000.000 4.650

5.216 4.000 4.000 4.660

5.24714.00014.000 4.670

5.2788.0008.000 4.680

5.3091

6.00016.000 4.690

5.34113.00013.000 4.700

5.37217.00017.000 4.710

5.40314.00014.000 4.720

5.434 5.000 5.000 4.730

5.4669.0009.000 4.740

5.4970.0000.000 4.750

5.5280.0000.000 4.760

5.5590.000 4.770

5.5910.000 4.780

5.6220.000 4.790

5.6530.000 4.800

5.6840.000 4.810

5.7160.000 4.820

5.7470.000 4.830

5.7780.000 4.840

5.8090.000 4.850

5.8410.000 4.860

5.8720.000 4.870

5.9030.000 4.880

5.9970.000 4.910

6.0280.000 4.920 6.0590.000 4.930 6.0910.000 4.940 6.1220.000 4.950 6.1530.000 4.960 6.1840.000 4.970

100.000 4.980

4.990

5.000

5.010

5.020

5.030

5.040

5.050

5.060

5.070

5.080

5.090

5.100

5.110

5.120

5.130

5.140

5.150

5.160

5.170

5.180

5.190

5.200

5.210

5.220

5.230

5.240

5.250

5.260

5.270

5.280

5.290

5.300 5.300

5.310

5.320

5.330

5.340

5.350

5.360

5.370

5.380

5.390

5.400

5.410

5.460 5.470 5.480 5.490 5.500 5.510 5.520 5.530 5.540 5.550 5.560 5.570 5.580 5.590 5.600 5.610 5.620 5.630 5.640 5.650 5.660 5.670 5.680 5.690 5.700 5.710 5.720 5.730 5.740 5.750 5.760 5.770 5.780 5.790 5.800 5.810 5.820 5.830 5.840 5.850 5.860 5.870 5.880 5.890 5.900 5.910 5.920 5.930 5.940

5.990

6.000 6.010 6.020 6.030 6.040 6.050

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

5.3270.072(9.996)(49.957)0.000

6.283 2.5070.3990.000

5.3270.072(9.856)(48.572)0.000

6.283 2.5070.3990.000

5.3270.072(9.717)(47.207)0.000

6.283 2.5070.3990.000

5.3270.072(9.577)(45.861)0.000

6.283 2.5070.3990.000

5.3270.072(9.438)(44.535)0.000

6.283 2.5070.3990.000

5.3270.072(9.298)(43.228)0.000

6.283 2.5070.3990.000

5.3270.072(9.159)(41.941)0.000

6.283 2.5070.3990.000

5.3270.072(9.019)(40.673)0.000

6.283 2.5070.3990.000

5.3270.072(8.880)(39.424)0.000

6.283 2.5070.3990.000

5.3270.072(8.740)(38.195)0.000

6.283 2.5070.3990.000

5.3270.072(8.601)(3

6.985)0.000 6.283 2.5070.3990.000

5.3270.072(8.461)(35.795)0.000

6.283 2.5070.3990.000

5.3270.072(8.322)(34.625)0.000

6.283 2.5070.3990.000

5.3270.072(8.182)(33.473)0.000

6.283 2.5070.3990.000

5.3270.072(8.043)(32.342)0.000

6.283 2.5070.3990.000

5.3270.072(7.903)(31.229)0.000

6.283 2.5070.3990.000

5.3270.072(7.764)(30.137)0.000

6.283 2.5070.3990.000

5.3270.072(7.624)(29.063)0.000

6.283 2.5070.3990.000

5.3270.072(7.485)(28.009)0.000

6.283 2.5070.3990.000

5.3270.072(7.345)(2

6.975)0.000 6.283 2.5070.3990.000

5.3270.072(7.206)(25.960)0.000

6.283 2.5070.3990.000

5.3270.072(7.066)(24.965)0.000

6.283 2.5070.3990.000

5.3270.072(

6.927)(23.989)0.000 6.283 2.5070.3990.000

5.3270.072(

6.787)(23.032)0.000 6.283 2.5070.3990.000

5.3270.072(

6.648)(22.095)0.000 6.283 2.5070.3990.000

5.3270.072(

6.508)(21.177)0.000 6.283 2.5070.3990.000

5.3270.072(

6.369)(20.279)0.000 6.283 2.5070.3990.000

5.3270.072(

6.229)(19.400)0.000 6.283 2.5070.3990.000

5.3270.072(

6.090)(18.541)0.000 6.283 2.5070.3990.000

5.3270.072(5.950)(17.701)0.000

6.283 2.5070.3990.000

5.3270.072(5.810)(1

6.881)0.000 6.283 2.5070.3990.000 5.3270.072(5.671)(16.080)0.000 6.283 2.5070.3990.000 5.3270.072(5.531)(15.299)0.000 6.283 2.5070.3990.000 5.3270.072(5.392)(14.537)0.000 6.283 2.5070.3990.000 5.3270.072(5.252)(13.794)0.000 6.283 2.5070.3990.000 5.3270.072(5.113)(13.071)0.000 6.283 2.5070.3990.000 5.3270.072(4.973)(12.368)0.000 6.283 2.5070.3990.000 5.3270.072(4.834)(11.683)0.000 6.283 2.5070.3990.000 5.3270.072(4.694)(11.019)0.000 6.283 2.5070.3990.000 5.3270.072(4.555)(10.374)0.000 6.283 2.5070.3990.000 5.3270.072(4.415)(9.748)0.000 6.283 2.5070.3990.000 5.3270.072(4.276)(9.142)0.000 6.283 2.5070.3990.000 5.3270.072(4.136)(8.555)0.000 6.283 2.5070.3990.000 5.3270.072(3.997)(

7.988)0.000 6.283 2.5070.3990.000 5.3270.072(3.857)(7.440)0.001 6.283 2.5070.3990.000 5.3270.072(3.718)(6.911)0.001 6.283 2.5070.3990.000 5.3270.072(3.578)(6.402)0.002 6.283 2.5070.3990.001 5.3270.072(3.439)(5.913)0.003 6.283 2.5070.3990.001 5.3270.072(3.299)(5.443)0.004 6.283 2.5070.3990.002 5.3270.072(3.160)(4.992)0.007 6.283 2.5070.3990.003 5.3270.072(3.020)(4.561)0.010 6.283 2.5070.3990.004 5.3270.072(2.881)(4.150)0.016 6.283 2.5070.3990.006 5.3270.072(2.741)(3.757)0.023 6.283 2.5070.3990.009 5.3270.072(2.602)(3.385)0.034 6.283 2.5070.3990.014 5.3270.072(2.462)(3.031)0.048 6.283 2.5070.3990.019 5.3270.072(2.323)(2.698)0.067 6.283 2.5070.3990.027 5.3270.072(2.183)(2.383)0.092 6.283 2.5070.3990.037 5.3270.072(2.044)(2.089)0.124 6.283 2.5070.3990.049 5.3270.072(1.904)(1.813)0.163 6.283 2.5070.3990.065 5.3270.072(1.765)(1.557)0.211 6.283 2.5070.3990.084 5.3270.072(1.625)(1.321)0.267 6.283 2.5070.3990.106 5.3270.072(1.486)(1.104)0.332 6.283 2.5070.3990.132 5.3270.072(1.346)(0.906)0.404 6.283 2.5070.3990.161 5.3270.072(1.207)(0.728)0.483 6.283 2.5070.3990.193 5.3270.072(1.067)(0.569)0.566 6.283 2.5070.3990.226 5.3270.072(0.928)(0.430)0.650 6.283 2.5070.3990.259 5.3270.072(0.788)(0.311)0.733 6.283 2.5070.3990.292 5.3270.072(0.649)(0.210)0.810 6.283 2.5070.3990.323 5.3270.072(0.509)(0.130)0.878 6.283 2.5070.3990.350 5.3270.072(0.370)(0.068)0.934 6.283 2.5070.3990.373 5.3270.072(0.230)(0.026)0.974 6.283 2.5070.3990.389 5.3270.072(0.091)(0.004)0.996 6.283 2.5070.3990.397 5.3270.0720.049(0.001)0.999 6.283 2.5070.3990.398 5.3270.0720.188(0.018)0.982 6.283 2.5070.3990.392 5.3270.0720.328(0.054)0.948 6.283 2.5070.3990.378 5.3270.0720.467(0.109)0.897 6.283 2.5070.3990.358 5.3270.0720.607(0.184)0.832 6.283 2.5070.3990.332 5.3270.0720.746(0.279)0.757 6.283 2.5070.3990.302 5.3270.0720.886(0.392)0.675 6.283 2.5070.3990.269 5.3270.072 1.025(0.526)0.591 6.283 2.5070.3990.236 5.3270.072 1.165(0.678)0.507 6.283 2.5070.3990.202 5.3270.072 1.304(0.851)0.427 6.283 2.5070.3990.170 5.3270.072 1.444(1.042)0.353 6.283 2.5070.3990.141

5.3270.072 1.583(1.254)0.285

6.283 2.5070.3990.114 5.3270.072 1.723(1.484)0.227 6.283 2.5070.3990.090 5.3270.072 1.862(1.734)0.177 6.283 2.5070.3990.070 5.3270.072 2.002(2.004)0.135 6.283 2.5070.3990.054 5.3270.072 2.141(2.293)0.101 6.283 2.5070.3990.040 5.3270.072 2.281(2.601)0.074 6.283 2.5070.3990.030 5.3270.072 2.420(2.929)0.053 6.283 2.5070.3990.021 5.3270.072 2.560(3.277)0.038 6.283 2.5070.3990.015 5.3270.072 2.699(3.644)0.026 6.283 2.5070.3990.010 5.3270.072 2.839(4.030)0.018 6.283 2.5070.3990.007 5.3270.072 2.978(4.436)0.012 6.283 2.5070.3990.005 5.3270.072 3.118(4.861)0.008 6.283 2.5070.3990.003 5.3270.072 3.257(5.306)0.005 6.283 2.5070.3990.002 5.3270.072 3.397(5.770)0.003 6.283 2.5070.3990.001 5.3270.072 3.537(6.253)0.002 6.283 2.5070.3990.001 5.3270.072 3.676(6.757)0.001 6.283 2.5070.3990.000 5.3270.072 3.816(

7.279)0.001 6.283 2.5070.3990.000 5.3270.072 3.955(7.821)0.000 6.283 2.5070.3990.000 5.3270.072 4.095(

8.383)0.000 6.283 2.5070.3990.000 5.3270.072 4.234(8.964)0.000 6.283 2.5070.3990.000 5.3270.072 4.374(

9.564)0.000 6.283 2.5070.3990.000 5.3270.072 4.513(10.184)0.000 6.283 2.5070.3990.000 5.3270.072 4.653(10.823)0.000 6.283 2.5070.3990.000 5.3270.072 4.792(11.482)0.000 6.283 2.5070.3990.000 5.3270.072 4.932(12.160)0.000 6.283 2.5070.3990.000 5.3270.072 5.071(12.858)0.000 6.283 2.5070.3990.000 5.3270.072 5.211(13.575)0.000 6.283 2.5070.3990.000 5.3270.072 5.350(14.312)0.000 6.283 2.5070.3990.000 5.3270.072 5.490(15.068)0.000 6.283 2.5070.3990.000 5.3270.072 5.629(15.844)0.000 6.283 2.5070.3990.000 5.3270.072 5.769(16.639)0.000 6.283 2.5070.3990.000 5.3270.072 5.908(17.453)0.000 6.283 2.5070.3990.000 5.3270.072 6.048(18.287)0.000 6.283 2.5070.3990.000 5.3270.072 6.187(19.140)0.000 6.283 2.5070.3990.000 5.3270.072 6.327(20.013)0.000 6.283 2.5070.3990.000 5.3270.072 6.466(20.906)0.000 6.283 2.5070.3990.000 5.3270.072 6.606(21.817)0.000 6.283 2.5070.3990.000 5.3270.072 6.745(22.749)0.000 6.283 2.5070.3990.000 5.3270.072 6.885(23.699)0.000 6.283 2.5070.3990.000 5.3270.0727.024(24.670)0.000 6.283 2.5070.3990.000 5.3270.0727.164(25.659)0.000 6.283 2.5070.3990.000 5.3270.0727.303(26.668)0.000 6.283 2.5070.3990.000 5.3270.0727.443(27.697)0.000 6.283 2.5070.3990.000 5.3270.0727.582(28.745)0.000 6.283 2.5070.3990.000 5.3270.0727.722(29.813)0.000 6.283 2.5070.3990.000 5.3270.0727.861(30.900)0.000 6.283 2.5070.3990.000 5.3270.0728.001(32.006)0.000 6.283 2.5070.3990.000 5.3270.0728.140(33.132)0.000 6.283 2.5070.3990.000 5.3270.0728.280(34.277)0.000 6.283 2.5070.3990.000 5.3270.0728.419(35.442)0.000 6.283 2.5070.3990.000 5.3270.0728.559(36.626)0.000 6.283 2.5070.3990.000 5.3270.0728.698(37.830)0.000 6.283 2.5070.3990.000 5.3270.0728.838(39.053)0.000 6.283 2.5070.3990.000

5.3270.0728.977(40.296)0.000

6.283 2.5070.3990.000 5.3270.0729.117(41.558)0.000 6.283 2.5070.3990.000 5.3270.0729.256(42.840)0.000 6.283 2.5070.3990.000 5.3270.0729.396(44.141)0.000 6.283 2.5070.3990.000 5.3270.0729.535(45.461)0.000 6.283 2.5070.3990.000 5.3270.0729.675(46.801)0.000 6.283 2.5070.3990.000 5.3270.0729.814(48.161)0.000 6.283 2.5070.3990.000 5.3270.0729.954(49.540)0.000 6.283 2.5070.3990.000 5.3270.07210.093(50.938)0.000 6.283 2.5070.3990.000

0.3190.319

0.3980.398

0.3190.319

相关主题
文本预览
相关文档 最新文档