CPK計算表格完整

,,,,,,,,,,,,,,,,,,

,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.19,100.32,100.15,,X平均值,na,100.23,,,,,,,,

,100.19,100.22,100.27,100.22,100.22,,標準差σ,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.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.23

,100.18,100.23,100.29,100.32,100.32,,Cp離散趨勢精確度,(USL-LSL)/6σ,1.10,,標準差σ,STDEV,0.06,,標準差σ,STDEV,0.06

,100.13,100.2,100.18,100.22,100.22,,Ca集中趨勢精確度,(X-U)/(T/2),0.17,,最大值,MAX,100.34,,最小值,MIN,100.00

,100.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.28

,100.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,,,,,,,,,,,,

,100.1,100.17,100.24,100.19,100.19,,,,,,,,,,,,

,100.21,100.2,100.27,100.25,100.25,,,,,,,,,,,,

,100.2,100.2,100.32,100.24,100.24,,,,,,,,,,,,

,100.2,100.2,100.32,100.24,100.24,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,

3.511,3.477,3.476,3.474,3.489,3.49,,公差上限USL,3.60,3.55,,,,,,,,

3.524,3.508,3.508,3.52,3.535,3.472,,公差下限LSL,3.40,3.45,,,,,,,,

3.488,3.495,3.504,3.49,3.491,3.484,,規(guī)格中心U,(USL+LSL)/2,3.5,,,,,,,,

3.533,3.489,3.546,3.541,3.492,3.511,,規(guī)格公差T,USL-LSL,0.2,,,,,,,,

3.527,3.52,3.467,3.466,3.541,3.463,,X平均值,na,3.50,,,,,,,,

3.522,3.518,3.515,3.537,3.503,3.453,,標準差σ,STDEV,0.03,,,,,,,,

3.456,3.503,3.455,3.524,3.534,3.527,,最大值,MAX,3.55,,,,,,,,

3.514,3.455,3.486,3.46,3.483,3.493,,最小值,Min,3.45,,,,,,,,

3.518,3.508,3.457,3.495,3.482,3.467,,CPKU,(USL-ˉx)/3σ,1.14,,,,,,,,

3.527,3.476,3.454,3.46,3.466,3.543,,CPKL,(ˉx-LSL)/3σ,1.10,,,,,,,,

3.451,3.48,3.529,3.494,3.492,3.533,,CPK,"Min(CPKU,CPKL)",1.10,,,,,,,,

3.528,3.481,3.541,3.524,3.508,3.487,,,,,,,,,,,,

3.46,3.538,3.464,3.456,3.467,3.526,,Cp離散趨勢精確度,(USL-LSL)/6σ,1.12,,,,,,,,

3.52,3.546,3.521,3.53,3.537,3.454,,Ca集中趨勢精確度,(X-U)/(T/2),-0.02,,,,,,,,

3.525,3.466,3.496,3.508,3.456,3.528,,Cpk,Cp*(1-|Ca|),1.10,,,,,,,,

3.523,3.533,3.463,3.486,3.511,3.539,,,,,,,,,,,,

3.484,3.472,3.548,3.495,3.47,3.498,,,,,,,,,,,,

3.539,3.455,3.488,3.458,3.542,3.541,,,,,,,,,,,,

3.548,3.465,3.547,3.487,3.537,3.456,,,,,,,,,,,,

3.45,3.532,3.451,3.477,3.513,3.548,,,,,,,,,,,,

3.46,3.461,3.49,3.493,3.526,3.504,,,,,,,,,,,,

3.542,3.505,3.45,3.502,3.505,3.461,,,,,,,,,,,,

3.537,3.457,3.464,3.523,3.518,3.465,,,,,,,,,,,,

3.478,3.489,3.46,3.472,3.486,3.542,,,,,,,,,,,,

3.514,3.496,3.534,3.525,3.495,3.491,,,,,,,,,,,,

3.496,3.531,3.492,3.515,3.457,3.47,,,,,,,,,,,,

3.488,3.452,3.494,3.527,3.51,3.467,,,,,,,,,,,,

3.464,3.541,3.523,3.537,3.486,3.514,,,,,,,,,,,,

3.522,3.489,3.485,3.475,3.487,3.539,,,,,,,,,,,,

3.484,3.464,3.511,3.512,3.48,3.485,,,,,,,,,,,,

3.522,3.49,3.544,3.544,3.48,3.511,,,,,,,,,,,,

3.513,3.483,3.452,3.484,3.453,3.473,,,,,,,,,,,,

3.536,3.459,3.458,3.55,3.459,3.451,,,,,,,,,,,,

3.49,3.534,3.535,3.505,3.524,3.509,,,,,,,,,,,,

3.463,3.462,3.507,3.461,3.526,3.46,,,,,,,,,,,,

3.468,3.546,3.502,3.534,3.464,3.458,,,,,,,,,,,,