CPK计算表格EXCEL

100.21100.2100.2100.19100.26100.19100.14100.23100.19100.24100.15100.2100.18100.13100.21100.14100.15100.11100.21100.1100.18100.1100.21100.2100.2100100.26100.28100.18100.21100.22100.27100.27100.24100.31100.21100.3100.23100.2100.28100.17100.23100.15100.3100.15100.24100.17100.2100.2100.2100.34100.34100.27100.32100.19100.27100.31100.33100.29100.34100.21100.21100.29100.18100.29100.3100.32100.25100.31100.2100.2100.24100.27100.32100.32100.25100.28100.17100.23100.32100.22100.3100.26100.28100.32100.2100.25100.32100.22100.32100.25100.31100.22100.31100.18100.28100.19100.25100.24100.24100.25100.28100.17100.23100.15100.22100.3100.26100.16100.32100.2100.25100.32100.22100.19100.25100.31100.22100.31100.18100.28100.19100.25100.24100.24双上限规格公差上限 USL公差下限 LSL规格中心 U规格公差 TX 平均值标准差 σ最大值最小值CPKUCPKLCPKCp 离散趋势精确度Ca 集中趋势精确度Cpk100.40输入上限值100.00输入下限值(USL+LSL)/2100.2USL-LSL0.4na100.23STDEV0.06MAX100.34Min100.10 ( USL-ˉx ) / 3σ0.91 ( ˉx -LSL )/ 3σ1.28Min(CPKU ,CPKL)0.91(USL-LSL) / 6σ(X-U)/(T/2) Cp * ( 1 - |Ca|)1.100.170.91公差上限 USL100.4输入上限值公差下限 USL100输入下限值只有上限规格X 平均值标准差 σ最大值CPKAVERAGESTDEVMAX(USL-ˉx ) / 3σ100.230.06100.340.91只有下限规格X 平均值标准差 σ最小值CPKAVERAGESTDEVMIN ( ˉx -LSL )/ 3σ100.230.06100.001.28CPK计算表格，左则为数