SPC_CPK分析Excel版有正态分布图

123W风扇电机 NO 测定DATA 1 5.31 5.20 5.35 5.37 5.28 4.8=SL 5.8=SU 2 5.23 5.24 5.20 5.31 5.34 3 5.37 5.36 5.37 5.34 5.45 55.000 0.917 9.917 9.917 4 5.45 5.24 5.28 5.37 5.36 56.000 0.933 9.933 9.933 5 5.45 5.38 5.45 5.24 5.32 57.000 0.950 9.950 9.950 6 5.36 5.39 5.31 5.25 5.34 58.000 0.967 9.967 9.967 7 5.38 5.24 5.28 5.37 5.25 59.000 0.983 9.983 9.983 8 5.37 5.38 5.45 5.24 5.24 5.000 0.083 9.083 9 5.32 5.39 5.31 5.25 5.27 10 5.37 5.42 5.23 5.20 5.23 11 5.29 5.28 5.37 5.37 5.29 12 5.28 5.38 5.45 5.24 5.43 13 5.29 5.39 5.31 5.25 5.27 14 5.28 5.42 5.23 5.24 5.20 基准 表 关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf ★工程能力的有无是按照如下基准来判断 15 5.24 5.28 5.37 5.29 5.45 A+▶2.0>Cpk≥1.67:优,应当保持 16 5.38 5.45 5.37 5.42 5.23 A▶1.67>Cpk≥1.33:能力良好，状态稳定，但应尽力提升为A＋级 17 5.39 5.31 5.29 5.28 5.37 B▶1.33>Cpk≥1.00:状态一般，制程因素稍有变异即有产生不良的危险，应利用各种资源及 方法 快递客服问题件处理详细方法山木方法pdf计算方法pdf华与华方法下载八字理论方法下载 将其提升为A级 18 5.26 5.39 5.28 5.38 5.45 C▶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 ▶规格中心(μ)与测定平均值的差异: 0.026 24 25 4.8=SL 5.8=SU 26 27 28 29 30 31 32 5.3=μ 33 LOTNO 测定者 0.967 样品数(n) 100 下限规格(SL) 4.80 测定设备 功率表 测定日 最大(Max) 5.450 上限规格(SU) 5.80 客户名 做成者 最小(Min) 5.200 规格中心(μ) 5.30 规格 做成日 平均(X-bar) 5.327 Cp 2.33 测定项目 功率 标准偏差(σ) 0.072 Cpk 2.20 2.202 产品名 上限不良PPM 0.0 母集团推定不良率 工程名 下限不良PPM 0.0 0 PPM 特别备注 0.010 K값 치수 평균 편차 U값 U제곱 E값 제곱근 함수값 0.053 4.610 5.327 0.072 (9.996) (49.957) 0.000 6.283 2.507 0.399 0.000 2.202 4.620 5.327 0.072 (9.856) (48.572) 0.000 6.283 2.507 0.399 0.000 구간치 4.630 5.327 0.072 (9.717) (47.207) 0.000 6.283 2.507 0.399 0.000 0.031 계급의수 4.640 5.327 0.072 (9.577) (45.861) 0.000 6.283 2.507 0.399 0.000 5.169 5.184 0.000 0.000 4.650 5.327 0.072 (9.438) (44.535) 0.000 6.283 2.507 0.399 0.000 5.200 5.216 4.000 4.000 4.660 5.327 0.072 (9.298) (43.228) 0.000 6.283 2.507 0.399 0.000 5.231 5.247 14.000 14.000 결 작성 담당 팀장 4.670 5.327 0.072 (9.159) (41.941) 0.000 6.283 2.507 0.399 0.000 5.263 5.278 8.000 8.000 4.680 5.327 0.072 (9.019) (40.673) 0.000 6.283 2.507 0.399 0.000 5.294 5.309 16.000 16.000 4.690 5.327 0.072 (8.880) (39.424) 0.000 6.283 2.507 0.399 0.000 5.325 5.341 13.000 13.000 재 4.700 5.327 0.072 (8.740) (38.195) 0.000 6.283 2.507 0.399 0.000 5.356 5.372 17.000 17.000 4.710 5.327 0.072 (8.601) (36.985) 0.000 6.283 2.507 0.399 0.000 5.388 5.403 14.000 14.000 4.720 5.327 0.072 (8.461) (35.795) 0.000 6.283 2.507 0.399 0.000 5.419 5.434 5.000 5.000 4.730 5.327 0.072 (8.322) (34.625) 0.000 6.283 2.507 0.399 0.000 5.450 5.466 9.000 9.000 4.740 5.327 0.072 (8.182) (33.473) 0.000 6.283 2.507 0.399 0.000 5.481 5.497 0.000 0.000 4.750 5.327 0.072 (8.043) (32.342) 0.000 6.283 2.507 0.399 0.000 5.513 5.528 0.000 0.000 4.760 5.327 0.072 (7.903) (31.229) 0.000 6.283 2.507 0.399 0.000 5.559 0.000 4.770 5.327 0.072 (7.764) (30.137) 0.000 6.283 2.507 0.399 0.000 5.591 0.000 4.780 5.327 0.072 (7.624) (29.063) 0.000 6.283 2.507 0.399 0.000 5.622 0.000 4.790 5.327 0.072 (7.485) (28.009) 0.000 6.283 2.507 0.399 0.000 5.653 0.000 4.800 5.327 0.072 (7.345) (26.975) 0.000 6.283 2.507 0.399 0.000 0.319 0.319 5.684 0.000 4.810 5.327 0.072 (7.206) (25.960) 0.000 6.283 2.507 0.399 0.000 5.716 0.000 4.820 5.327 0.072 (7.066) (24.965) 0.000 6.283 2.507 0.399 0.000 5.747 0.000 4.830 5.327 0.072 (6.927) (23.989) 0.000 6.283 2.507 0.399 0.000 5.778 0.000 4.840 5.327 0.072 (6.787) (23.032) 0.000 6.283 2.507 0.399 0.000 5.809 0.000 4.850 5.327 0.072 (6.648) (22.095) 0.000 6.283 2.507 0.399 0.000 5.841 0.000 4.860 5.327 0.072 (6.508) (21.177) 0.000 6.283 2.507 0.399 0.000 5.872 0.000 4.870 5.327 0.072 (6.369) (20.279) 0.000 6.283 2.507 0.399 0.000 5.903 0.000 4.880 5.327 0.072 (6.229) (19.400) 0.000 6.283 2.507 0.399 0.000 5.934 0.000 4.890 5.327 0.072 (6.090) (18.541) 0.000 6.283 2.507 0.399 0.000 5.966 0.000 4.900 5.327 0.072 (5.950) (17.701) 0.000 6.283 2.507 0.399 0.000 5.997 0.000 4.910 5.327 0.072 (5.810) (16.881) 0.000 6.283 2.507 0.399 0.000 6.028 0.000 4.920 5.327 0.072 (5.671) (16.080) 0.000 6.283 2.507 0.399 0.000 6.059 0.000 4.930 5.327 0.072 (5.531) (15.299) 0.000 6.283 2.507 0.399 0.000 6.091 0.000 4.940 5.327 0.072 (5.392) (14.537) 0.000 6.283 2.507 0.399 0.000 6.122 0.000 4.950 5.327 0.072 (5.252) (13.794) 0.000 6.283 2.507 0.399 0.000 6.153 0.000 4.960 5.327 0.072 (5.113) (13.071) 0.000 6.283 2.507 0.399 0.000 6.184 0.000 4.970 5.327 0.072 (4.973) (12.368) 0.000 6.283 2.507 0.399 0.000 100.000 4.980 5.327 0.072 (4.834) (11.683) 0.000 6.283 2.507 0.399 0.000 4.990 5.327 0.072 (4.694) (11.019) 0.000 6.283 2.507 0.399 0.000 5.000 5.327 0.072 (4.555) (10.374) 0.000 6.283 2.507 0.399 0.000 5.010 5.327 0.072 (4.415) (9.748) 0.000 6.283 2.507 0.399 0.000 5.020 5.327 0.072 (4.276) (9.142) 0.000 6.283 2.507 0.399 0.000 5.030 5.327 0.072 (4.136) (8.555) 0.000 6.283 2.507 0.399 0.000 5.040 5.327 0.072 (3.997) (7.988) 0.000 6.283 2.507 0.399 0.000 5.050 5.327 0.072 (3.857) (7.440) 0.001 6.283 2.507 0.399 0.000 5.060 5.327 0.072 (3.718) (6.911) 0.001 6.283 2.507 0.399 0.000 5.070 5.327 0.072 (3.578) (6.402) 0.002 6.283 2.507 0.399 0.001 5.080 5.327 0.072 (3.439) (5.913) 0.003 6.283 2.507 0.399 0.001 5.090 5.327 0.072 (3.299) (5.443) 0.004 6.283 2.507 0.399 0.002 5.100 5.327 0.072 (3.160) (4.992) 0.007 6.283 2.507 0.399 0.003 5.110 5.327 0.072 (3.020) (4.561) 0.010 6.283 2.507 0.399 0.004 5.120 5.327 0.072 (2.881) (4.150) 0.016 6.283 2.507 0.399 0.006 5.130 5.327 0.072 (2.741) (3.757) 0.023 6.283 2.507 0.399 0.009 5.140 5.327 0.072 (2.602) (3.385) 0.034 6.283 2.507 0.399 0.014 5.150 5.327 0.072 (2.462) (3.031) 0.048 6.283 2.507 0.399 0.019 5.160 5.327 0.072 (2.323) (2.698) 0.067 6.283 2.507 0.399 0.027 5.170 5.327 0.072 (2.183) (2.383) 0.092 6.283 2.507 0.399 0.037 5.180 5.327 0.072 (2.044) (2.089) 0.124 6.283 2.507 0.399 0.049 5.190 5.327 0.072 (1.904) (1.813) 0.163 6.283 2.507 0.399 0.065 5.200 5.327 0.072 (1.765) (1.557) 0.211 6.283 2.507 0.399 0.084 5.210 5.327 0.072 (1.625) (1.321) 0.267 6.283 2.507 0.399 0.106 5.220 5.327 0.072 (1.486) (1.104) 0.332 6.283 2.507 0.399 0.132 5.230 5.327 0.072 (1.346) (0.906) 0.404 6.283 2.507 0.399 0.161 5.240 5.327 0.072 (1.207) (0.728) 0.483 6.283 2.507 0.399 0.193 5.250 5.327 0.072 (1.067) (0.569) 0.566 6.283 2.507 0.399 0.226 5.260 5.327 0.072 (0.928) (0.430) 0.650 6.283 2.507 0.399 0.259 5.270 5.327 0.072 (0.788) (0.311) 0.733 6.283 2.507 0.399 0.292 5.280 5.327 0.072 (0.649) (0.210) 0.810 6.283 2.507 0.399 0.323 5.290 5.327 0.072 (0.509) (0.130) 0.878 6.283 2.507 0.399 0.350 5.300 5.300 5.327 0.072 (0.370) (0.068) 0.934 6.283 2.507 0.399 0.373 0.398 0.398 5.310 5.327 0.072 (0.230) (0.026) 0.974 6.283 2.507 0.399 0.389 5.320 5.327 0.072 (0.091) (0.004) 0.996 6.283 2.507 0.399 0.397 5.330 5.327 0.072 0.049 (0.001) 0.999 6.283 2.507 0.399 0.398 5.340 5.327 0.072 0.188 (0.018) 0.982 6.283 2.507 0.399 0.392 5.350 5.327 0.072 0.328 (0.054) 0.948 6.283 2.507 0.399 0.378 5.360 5.327 0.072 0.467 (0.109) 0.897 6.283 2.507 0.399 0.358 5.370 5.327 0.072 0.607 (0.184) 0.832 6.283 2.507 0.399 0.332 5.380 5.327 0.072 0.746 (0.279) 0.757 6.283 2.507 0.399 0.302 5.390 5.327 0.072 0.886 (0.392) 0.675 6.283 2.507 0.399 0.269 5.400 5.327 0.072 1.025 (0.526) 0.591 6.283 2.507 0.399 0.236 5.410 5.327 0.072 1.165 (0.678) 0.507 6.283 2.507 0.399 0.202 5.420 5.327 0.072 1.304 (0.851) 0.427 6.283 2.507 0.399 0.170 5.430 5.327 0.072 1.444 (1.042) 0.353 6.283 2.507 0.399 0.141 5.440 5.327 0.072 1.583 (1.254) 0.285 6.283 2.507 0.399 0.114 5.450 5.327 0.072 1.723 (1.484) 0.227 6.283 2.507 0.399 0.090 5.460 5.327 0.072 1.862 (1.734) 0.177 6.283 2.507 0.399 0.070 5.470 5.327 0.072 2.002 (2.004) 0.135 6.283 2.507 0.399 0.054 5.480 5.327 0.072 2.141 (2.293) 0.101 6.283 2.507 0.399 0.040 5.490 5.327 0.072 2.281 (2.601) 0.074 6.283 2.507 0.399 0.030 5.500 5.327 0.072 2.420 (2.929) 0.053 6.283 2.507 0.399 0.021 5.510 5.327 0.072 2.560 (3.277) 0.038 6.283 2.507 0.399 0.015 5.520 5.327 0.072 2.699 (3.644) 0.026 6.283 2.507 0.399 0.010 5.530 5.327 0.072 2.839 (4.030) 0.018 6.283 2.507 0.399 0.007 5.540 5.327 0.072 2.978 (4.436) 0.012 6.283 2.507 0.399 0.005 5.550 5.327 0.072 3.118 (4.861) 0.008 6.283 2.507 0.399 0.003 5.560 5.327 0.072 3.257 (5.306) 0.005 6.283 2.507 0.399 0.002 5.570 5.327 0.072 3.397 (5.770) 0.003 6.283 2.507 0.399 0.001 5.580 5.327 0.072 3.537 (6.253) 0.002 6.283 2.507 0.399 0.001 5.590 5.327 0.072 3.676 (6.757) 0.001 6.283 2.507 0.399 0.000 5.600 5.327 0.072 3.816 (7.279) 0.001 6.283 2.507 0.399 0.000 5.610 5.327 0.072 3.955 (7.821) 0.000 6.283 2.507 0.399 0.000 5.620 5.327 0.072 4.095 (8.383) 0.000 6.283 2.507 0.399 0.000 5.630 5.327 0.072 4.234 (8.964) 0.000 6.283 2.507 0.399 0.000 5.640 5.327 0.072 4.374 (9.564) 0.000 6.283 2.507 0.399 0.000 5.650 5.327 0.072 4.513 (10.184) 0.000 6.283 2.507 0.399 0.000 5.660 5.327 0.072 4.653 (10.823) 0.000 6.283 2.507 0.399 0.000 5.670 5.327 0.072 4.792 (11.482) 0.000 6.283 2.507 0.399 0.000 5.680 5.327 0.072 4.932 (12.160) 0.000 6.283 2.507 0.399 0.000 5.690 5.327 0.072 5.071 (12.858) 0.000 6.283 2.507 0.399 0.000 5.700 5.327 0.072 5.211 (13.575) 0.000 6.283 2.507 0.399 0.000 5.710 5.327 0.072 5.350 (14.312) 0.000 6.283 2.507 0.399 0.000 5.720 5.327 0.072 5.490 (15.068) 0.000 6.283 2.507 0.399 0.000 5.730 5.327 0.072 5.629 (15.844) 0.000 6.283 2.507 0.399 0.000 5.740 5.327 0.072 5.769 (16.639) 0.000 6.283 2.507 0.399 0.000 5.750 5.327 0.072 5.908 (17.453) 0.000 6.283 2.507 0.399 0.000 5.760 5.327 0.072 6.048 (18.287) 0.000 6.283 2.507 0.399 0.000 5.770 5.327 0.072 6.187 (19.140) 0.000 6.283 2.507 0.399 0.000 5.780 5.327 0.072 6.327 (20.013) 0.000 6.283 2.507 0.399 0.000 5.790 5.327 0.072 6.466 (20.906) 0.000 6.283 2.507 0.399 0.000 5.800 5.327 0.072 6.606 (21.817) 0.000 6.283 2.507 0.399 0.000 0.319 0.319 5.810 5.327 0.072 6.745 (22.749) 0.000 6.283 2.507 0.399 0.000 5.820 5.327 0.072 6.885 (23.699) 0.000 6.283 2.507 0.399 0.000 5.830 5.327 0.072 7.024 (24.670) 0.000 6.283 2.507 0.399 0.000 5.840 5.327 0.072 7.164 (25.659) 0.000 6.283 2.507 0.399 0.000 5.850 5.327 0.072 7.303 (26.668) 0.000 6.283 2.507 0.399 0.000 5.860 5.327 0.072 7.443 (27.697) 0.000 6.283 2.507 0.399 0.000 5.870 5.327 0.072 7.582 (28.745) 0.000 6.283 2.507 0.399 0.000 5.880 5.327 0.072 7.722 (29.813) 0.000 6.283 2.507 0.399 0.000 5.890 5.327 0.072 7.861 (30.900) 0.000 6.283 2.507 0.399 0.000 5.900 5.327 0.072 8.001 (32.006) 0.000 6.283 2.507 0.399 0.000 5.910 5.327 0.072 8.140 (33.132) 0.000 6.283 2.507 0.399 0.000 5.920 5.327 0.072 8.280 (34.277) 0.000 6.283 2.507 0.399 0.000 5.930 5.327 0.072 8.419 (35.442) 0.000 6.283 2.507 0.399 0.000 5.940 5.327 0.072 8.559 (36.626) 0.000 6.283 2.507 0.399 0.000 5.950 5.327 0.072 8.698 (37.830) 0.000 6.283 2.507 0.399 0.000 5.960 5.327 0.072 8.838 (39.053) 0.000 6.283 2.507 0.399 0.000 5.970 5.327 0.072 8.977 (40.296) 0.000 6.283 2.507 0.399 0.000 5.980 5.327 0.072 9.117 (41.558) 0.000 6.283 2.507 0.399 0.000 5.990 5.327 0.072 9.256 (42.840) 0.000 6.283 2.507 0.399 0.000 6.000 5.327 0.072 9.396 (44.141) 0.000 6.283 2.507 0.399 0.000 6.010 5.327 0.072 9.535 (45.461) 0.000 6.283 2.507 0.399 0.000 6.020 5.327 0.072 9.675 (46.801) 0.000 6.283 2.507 0.399 0.000 6.030 5.327 0.072 9.814 (48.161) 0.000 6.283 2.507 0.399 0.000 6.040 5.327 0.072 9.954 (49.540) 0.000 6.283 2.507 0.399 0.000 6.050 5.327 0.072 10.093 (50.938) 0.000 6.283 2.507 0.399 0.000工程能力分析表123W风扇电机 &A&P쪽280W风扇电机 &A&P쪽 NO 测定DATA 1 4.38 4.30 4.24 4.37 4.31 3.8=SL 4.8=SU 2 4.41 4.46 4.30 4.27 4.24 3 4.27 4.41 4.46 4.42 4.31 4 4.46 4.38 4.30 4.34 4.24 5 4.42 4.41 4.46 4.41 4.32 6 4.41 4.30 4.27 4.39 4.29 7 4.38 4.27 4.34 4.24 4.24 8 4.32 4.34 4.32 4.32 4.41 9 4.29 4.4 4.27 4.34 4.29 10 4.24 4.38 4.34 4.32 4.41 11 4.34 4.29 4.27 4.34 4.42 12 4.32 4.38 4.34 4.32 4.34 13 4.33 4.27 4.32 4.33 4.41 14 4.30 4.27 4.29 4.39 4.29 基准表 ★工程能力的有无是按照如下基准来判断 15 4.34 4.34 4.24 4.24 4.32 A+▶2.0>Cpk≥1.67:优,应当保持 16 4.33 4.4 4.34 4.46 4.29 A▶1.67>Cpk≥1.33:能力良好，状态稳定，但应尽力提升为A＋级 17 4.30 4.27 4.32 4.34 4.24 B▶1.33>Cpk≥1.00:状态一般，制程因素稍有变异即有产生不良的危险，应利用各种资源及方法将其提升为A级 18 4.34 4.34 4.33 4.32 4.34 C▶1.00>Cpk≥0.67:差制程不良较多，必须提升其能力 19 4.31 4.31 4.30 4.27 4.32 D▶0.67>Cpk:不可接受,其能力太差，应考虑重新整改设计制程 20 4.27 4.29 4.43 4.27 4.33 结论 21 22 23 ▶规格中心(μ)与测定平均值的差异: 0.031 24 25 3.8=SL 4.8=SU 5.000 0.083 0.083 9.083 9.083 26 53.000 0.883 0.883 8.883 8.883 27 54.000 0.900 0.900 8.900 8.900 28 55.000 0.917 0.917 8.917 8.917 29 56.000 0.933 0.933 8.933 8.933 30 57.000 0.950 0.950 8.950 8.950 31 58.000 0.967 0.967 8.967 8.967 32 4.3=μ 59.000 0.983 0.983 8.983 8.983 33 LOTNO 测定者 样品数(n) 100 下限规格(SL) 3.80 测定设备 功率表 测定日 最大(Max) 4.46 上限规格(SU) 4.80 客户名 做成者 最小(Min) 4.24 规格中心(μ) 4.30 规格 做成日 平均(X-bar) 4.33 Cp 2.84 测定项目 功率 标准偏差(σ) 0.06 Cpk 2.66 产品名 上限不良PPM 0.0 母集团推定不良率 工程名 下限不良PPM 0.0 0 PPM 特别备注 0.010 K값 치수 평균 편차 U값 U제곱 E값 제곱근 함수값 0.062 3.610 4.331 0.059 (12.294) (75.575) 0.000 6.283 2.507 0.399 0.000 2.665 3.620 4.331 0.059 (12.124) (73.493) 0.000 6.283 2.507 0.399 0.000 구간치 3.630 4.331 0.059 (11.953) (71.441) 0.000 6.283 2.507 0.399 0.000 0.028 계급의수 3.640 4.331 0.059 (11.783) (69.418) 0.000 6.283 2.507 0.399 0.000 4.213 4.226 0.000 0.000 3.650 4.331 0.059 (11.612) (67.423) 0.000 6.283 2.507 0.399 0.000 4.240 4.254 9.000 9.000 3.660 4.331 0.059 (11.442) (65.458) 0.000 6.283 2.507 0.399 0.000