CPK计算表格EXCEL模板

1、,100.21,100,100.34,100.25,100.25,双上限规格,公差上限 USL,100.40,输入上限值,只有上限规格,公差上限 USL,100.4,输入上限值,只有下限规格,公差下限 USL,100,输入下限值100.2,100.26,100.34,100.28,100.28,公差下限 LSL,100.00,输入下限值,100.2,100.28,100.27,100.17,100.17,规格中心 U,(USL+LSL)/2,100.2,100.19,100.18,100.32,100.23,100.23,规格公差 T,USL-LSL,0.4,100.26,100.21,100

2、.19,100.32,100.15,X 平均值,na,100.23,100.19,100.22,100.27,100.22,100.22,标准差 ,STDEV,0.06,100.14,100.27,100.31,100.3,100.3,最大值,MAX,100.34,100.23,100.27,100.33,100.26,100.26,最小值,Min,100.10,100.19,100.24,100.29,100.28,100.16,CPKU, ( USL-x ) / 3 ,0.91,100.24,100.31,100.34,100.32,100.32,CPKL, ( x -LSL )/ 3,1

3、.28,100.15,100.21,100.21,100.2,100.2,CPK,Min(CPKU ,CPKL),0.91,100.2,100.3,100.21,100.25,100.25,X 平均值,AVERAGE,100.23,X 平均值,AVERAGE,100.23100.18,100.23,100.29,100.32,100.32,Cp 离散趋势精确度,(USL-LSL) / 6 ,1.10,标准差 ,STDEV,0.06,标准差 ,STDEV,0.06100.13,100.2,100.18,100.22,100.22,Ca 集中趋势精确度,(X-U)/(T/2),0.17,最大值,M

4、AX,100.34,最小值,MIN,100.00100.21,100.28,100.29,100.32,100.19,Cpk, Cp * ( 1 - |Ca|),0.91,CPK,(USL-x ) / 3 ,0.91,CPK, ( x -LSL )/ 3,1.28100.14,100.17,100.3,100.25,100.25,100.15,100.23,100.32,100.31,100.31,100.11,100.15,100.25,100.22,100.22,100.21,100.3,100.31,100.31,100.31,100.1,100.15,100.2,100.18,100.18,100.18,100.24,100.2,100.28,100.28,CPK计算表格，左则为数据区域，可以根据需要任意增减,100.1,100.17,100.24,100.19,100.19,100.21,100.2,100.27,100.25,100.