CPK控制图分析计算工具.xls

1、过过 程程 能能 力力 研研 究究(CPK分析报告)工 厂部 门一分厂工 序冲孔计算控制限日期2003/9/27工程规范15.25016.750 机器编号冲冲床床日 期2003/9/27特 性尺寸160.2样本容量/频率5件/1H零件名称/编号DL138GD-12400插接片组件时间8:208:409:009:209:4010:0010:2010:4011:0011:2012:1012:3012:5013:1013:3013:5014:1014:3014:5015:1015:30115.70016.20015.90015.90015.90015.80015.90015.80015.90015.

2、90015.80015.90016.10015.80016.10016.20015.90015.90015.80015.90015.900读215.80016.00015.90016.10016.00015.90016.00015.90016.00015.70015.80016.10016.20015.80016.20015.90015.90015.80016.00016.00016.000316.00016.10016.10016.20016.20015.80016.20016.20016.00015.80016.00016.20016.00015.90016.00016.20016.100

3、16.10015.90015.90015.900数416.00015.90016.00015.80016.20016.00016.10016.10016.10015.90016.20016.10016.30016.00015.90015.70016.00015.90015.80016.10016.100516.10016.00015.80015.90015.90015.80016.30016.20016.20016.00016.00016.10016.00016.10016.20015.80016.10015.90016.20016.20016.200和79.6080.2079.7079.90

4、80.2079.3080.5080.2080.2079.3079.8080.4080.6079.6080.4079.8080.0079.6079.7080.1080.10X=和/（读数数量）15.9216.0415.9415.9816.0415.8616.1016.0416.0415.8615.9616.0816.1215.9216.0815.9616.0015.9215.9416.0216.02R=最高最低0.40000.3000.3000.4000.3000.2000.4000.4000.3000.3000.4000.3000.3000.3000.3000.5000.2000.3000.4

5、000.3000.300S=STDEV(C6:V10)=s=0.1472147对特殊原因采取的措施的说明：d2d2A2D3D4 *任何超出控制限的点。X=15.99 R=0.3292 21.131.131.881.88*3.273.27 *连续7点全在中心线之上或之下。子子3 31.691.021.02*2.572.57 *连续7点上升或下降。4 42.060.730.73*2.282.28 *任何其它明显非随机的图形。UCLX=X+A2R=16.18 UCLR=D4R=0.6932857组组5 52.330.580.58*2.112.11USL=USL=16.75Cpk1=(USL-X)/3

6、s=1.7156 62.530.480.48*2.002.00采取措施的说明：容容7 72.70.420.420.080.081.921.92 1。LCLX=X A2R=15.80 LCLR=D3R=082.850.370.370.140.141.861.86 2。LSL=15.25Cpk2=(X-LSL)/3s=1.681量量92.970.340.340.180.181.821.82 3。Cpk=min(Cpk1,Cpk2)=1.68110103.080.310.310.220.221.781.78 4。*在确定过程能力之前，过程必须受控。5 5。*样本容量小于7时，没有极差的下控制线。UC

7、L16.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.18 X15.9915.9915.9915.9915.9915.9915.9915.9915.9915.9915.9915.9915.9915.9915.9915.9915.9915.9915.9915.9915.99LCL15.8015.8015.8015.8015.8015.8015.8015.8015.8015.8015.8015.8015.8015.8015.8015.8015.8

8、015.8015.8015.8015.80UCL0.6932857 0.6932857 0.6932857 0.6932857 0.6932857 0.69328570.693286 0.6932860.693 0.6932857 0.69328570.6932857 0.6932857 0.69328570.6932860.6932860.6932860.6932860.693286 0.693290.693285714 R0.3290.3290.3290.3290.3290.3290.3290.3290.3290.3290.3290.3290.3290.3290.3290.3290.329

9、0.3290.3290.3290.329LCL000000000000000000000研研究究评评定定:由以上计算结果可知CPK=1.3651.33,性能指数能够满足.若批准,开始生产并按照已批准的控制计划进行.1X 控 制 图12345678910111213141516171819202115.7015.8015.9016.0016.1016.2016.30UCL XLCLAVG.R 控 制 图12345678910111213141516171819202100.030.060.090.120.150.180.210.240.270.30.330.360.390.420.450.480.510.540.570.60.630.660.690.720.75UCL RLCLRANGE2