CPK计算表格EXCEL讲解学习.xls

100.21100100.34100.25100.25双上限规格公差上限 USL100.40 输入上限值100.2100.26100.34100.28100.28公差下限 LSL100.00 输入下限值100.2100.28100.27100.17100.17规格中心 U(USL+LSL)/2100.2100.19100.18100.32100.23100.23规格公差 TUSL-LSL0.4100.26100.21100.19100.32100.15X 平均值na100.23100.19100.22100.27100.22100.22标准差 STDEV0.06100.14100.27100.31100.3100.3最大值MAX100.34100.23100.27100.33100.26100.26最小值Min100.10100.19100.24100.29100.28100.16CPKU(USL-x)/3 0.91100.24100.31100.34100.32100.32CPKL(x-LSL)/31.28100.15100.21100.21100.2100.2CPKMin(CPKU,CPKL)0.91100.2100.3100.21100.25100.25100.18100.23100.29100.32100.32Cp 离散趋势精确度(USL-LSL)/6 1.10100.13100.2100.18100.22100.22Ca 集中趋势精确度(X-U)/(T/2)0.17100.21100.28100.29100.32100.19Cpk Cp*(1-|Ca|)0.91100.14100.17100.3100.25100.25100.15100.23100.32100.31100.31100.11100.15100.25100.22100.22100.21100.3100.31100.31100.31100.1100.15100.2100.18100.18100.18100.24100.2100.28100.28100.1100.17100.24100.19100.19100.21100.2100.27100.25100.25100.2100.2100.32100.24100.24100.2100.2100.32100.24100.24只有上限规格公差上限 USL100.4 输入上限值只有下限规格公差下限 USL100 输入下限值X 平均值AVERAGE100.23X 平均值AVERAGE100.23标准差 STDEV0.06标准差 STDEV0.06最大值MAX100.34最小值MIN100.00CPK(USL-x)/3 0.91CPK(x-LSL)/31.28CPK计算表格，左则为数据区域，可以根据需要任意增减