CPK计算表格.xls

CPK计算表格.xls

《CPK计算表格.xls》由会员分享，可在线阅读，更多相关《CPK计算表格.xls（2页珍藏版）》请在冰豆网上搜索。

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）/30.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）/61.10100.13100.2100.18100.22100.22Ca集中趋势精确度（X-U）/（T/2）0.17100.21100.28100.29100.32100.19CpkCp*（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）/30.91CPK（x-LSL）/31.28CPK计算表格，左则为数据区域，可以根据需要任意增减