CPK计算表格EXCEL1表格文件下载.xls
《CPK计算表格EXCEL1表格文件下载.xls》由会员分享,可在线阅读,更多相关《CPK计算表格EXCEL1表格文件下载.xls(2页珍藏版)》请在冰豆网上搜索。
PPK自动计算表数数据据收收集集区区公公式式区区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.16PPKU(USL-x)/30.91100.24100.31100.34100.32100.32PPKL(x-LSL)/31.28100.15100.21100.21100.2100.2PPKMin(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.19PpkCp*(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.00PPK(USL-x)/30.91PPK(x-LSL)/31.28CPK计算表格,左则为数据区域,可以根据需要任意增减PPK自动计算表公公式式区区