CPK計(jì)算表格EXCEL模板

1、,100.21,100,100.34,100.25,100.25,雙上限規(guī)格,公差上限 USL,100.40,輸入上限值,只有上限規(guī)格,公差上限 USL,100.4,輸入上限值,只有下限規(guī)格,公差下限 USL,100,輸入下限值100.2,100.26,100.34,100.28,100.28,公差下限 LSL,100.00,輸入下限值,100.2,100.28,100.27,100.17,100.17,規(guī)格中心 U,(USL+LSL)/2,100.2,100.19,100.18,100.32,100.23,100.23,規(guī)格公差 T,USL-LSL,0.4,100.26,100.21,100

2、.19,100.32,100.15,X 平均值,na,100.23,100.19,100.22,100.27,100.22,100.22,標(biāo)準(zhǔn)差 ,STDEV,0.06,100.14,100.27,100.31,100.3,100.3,最大值,MAX,100.34,100.23,100.27,100.33,100.26,100.26,最小值,Min,100.10,100.19,100.24,100.29,100.28,100.16,CPKU, ( USL-x ) / 3 ,0.91,100.24,100.31,100.34,100.32,100.32,CPKL, ( x -LSL )/ 3,1

3、.28,100.15,100.21,100.21,100.2,100.2,CPK,Min(CPKU ,CPKL),0.91,100.2,100.3,100.21,100.25,100.25,X 平均值,AVERAGE,100.23,X 平均值,AVERAGE,100.23100.18,100.23,100.29,100.32,100.32,Cp 離散趨勢(shì)精確度,(USL-LSL) / 6 ,1.10,標(biāo)準(zhǔn)差 ,STDEV,0.06,標(biāo)準(zhǔn)差 ,STDEV,0.06100.13,100.2,100.18,100.22,100.22,Ca 集中趨勢(shì)精確度,(X-U)/(T/2),0.17,最大值,M

4、AX,100.34,最小值,MIN,100.00100.21,100.28,100.29,100.32,100.19,Cpk, Cp * ( 1 - |Ca|),0.91,CPK,(USL-x ) / 3 ,0.91,CPK, ( x -LSL )/ 3,1.28100.14,100.17,100.3,100.25,100.25,100.15,100.23,100.32,100.31,100.31,100.11,100.15,100.25,100.22,100.22,100.21,100.3,100.31,100.31,100.31,100.1,100.15,100.2,100.18,100.18,100.18,100.24,100.2,100.28,100.28,CPK計(jì)算表格，左則為數(shù)據(jù)區(qū)域，可以根據(jù)需要任意增減,100.1,100.17,100.24,100.19,100.19,100.21,100.2,100.27,100.25,100.