CPK计算表格EXCEL

36.269736.274公差上限USL36.35输入上限值36.268836.2545公差下限LSL36.20输入下限值36.264236.2855规格中心U(USL+LSL)/236.27536.272836.2837规格公差TUSL-LSL0.1536.246736.274X平均值na36.2736.29136.2673标准差σSTDEV0.0236.255336.3228最大值MAX36.3236.23636.2865最小值Min36.2336.275236.2573CPKU(USL-ˉx)/3σ1.4336.27136.2795CPKL(ˉx-LSL)/3σ1.3036.2736.3145CPKMin(CPKU,CPKL)1.3036.269736.286736.25536.2597Cp离散趋势精确度(USL-LSL)/6σ1.3636.235336.2707Ca集中趋势精确度(X-U)/(T/2)-0.0536.257736.2727CpkCp*(1-|Ca|)1.3036.243236.268336.2636.276836.22536.284536.288836.272836.267336.287236.280836.263736.269536.265336.276836.313236.258836.275336.277536.2763双上限规格公差上限USL输入上限值公差下限USL输入下限值X平均值AVERAGE36.27X平均值AVERAGE36.27标准差σSTDEV0.02标准差σSTDEV0.02最大值MAX36.32最小值MIN36.23CPK(USL-ˉx)/3σ-660.10CPK(ˉx-LSL)/3σ660.10CPK计算表格，左则为数据区域，可以根据需要任意增减只有上限规格只有下限规格