CPK控制图分析计算工具表格文件下载.xls

CPK控制图分析计算工具表格文件下载.xls

《CPK控制图分析计算工具表格文件下载.xls》由会员分享，可在线阅读，更多相关《CPK控制图分析计算工具表格文件下载.xls（2页珍藏版）》请在冰豆网上搜索。

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.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.10016.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.9080.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.4000.3000.300S=STDEV（C6:

V10）=s=0.1472147对特殊原因采取的措施的说明：

d2d2A2D3D4*任何超出控制限的点。

X=15.99R=0.329221.131.131.881.88*3.273.27*连续7点全在中心线之上或之下。

子子331.691.021.02*2.572.57*连续7点上升或下降。

442.060.730.73*2.282.28*任何其它明显非随机的图形。

UCLX=X+A2R=16.18UCLR=D4R=0.6932857组组552.330.580.58*2.112.11USL=USL=16.75Cpk1=（USL-X）/3s=1.715662.530.480.48*2.002.00采取措施的说明：

容容772.70.420.420.080.081.921.921。

LCLX=XA2R=15.80LCLR=D3R=082.850.370.370.140.141.861.862。

LSL=15.25Cpk2=（X-LSL）/3s=1.681量量92.970.340.340.180.181.821.823。

Cpk=min（Cpk1,Cpk2）=1.68110103.080.310.310.220.221.781.784。

*在确定过程能力之前，过程必须受控。

55。

*样本容量小于7时，没有极差的下控制线。

UCL16.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.1816.18X15.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.8015.8015.8015.8015.80UCL0.69328570.69328570.69328570.69328570.69328570.69328570.6932860.6932860.6930.69328570.69328570.69328570.69328570.69328570.6932860.6932860.6932860.6932860.6932860.693290.693285714R0.3290.3290.3290.3290.3290.3290.3290.3290.3290.3290.3290.3290.3290.3290.3290.3290.3290.3290.3290.3290.329LCL000000000000000000000研研究究评评定定:

由以上计算结果可知CPK=1.3651.33,性能指数能够满足.若批准,开始生产并按照已批准的控制计划进行.1X控制图12345678910111213141516171819202115.7015.8015.9016.0016.1016.2016.30UCLXLCLAVG.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.75UCLRLCLRANGE2