計數(shù)型量具分析報告(Excel帶計算KAPPA公式)

1、計數(shù)型量具測量結(jié)果數(shù)據(jù)表零件名稱量具名稱填表人規(guī)格量具編號日期零件操作者A()操作者B()操作者C()基準(zhǔn)A-1A-2A-3B-1B-2B-3C-1C-2C-31111111111121111111111300000000004000000000050000000000611011010017111111101181111111111900000000001011111111111111111111111200000001001311111111111411011110011511111111111611111111111711111111111811111111111911111111112

2、011111111112111010101012200101011002311111111112411111111112500000000002601000000102711111111112811111111112911111111113000000100003111111111113211111111113311111111113400100101103511111111113611011110113700000000003811111111113900000000004011111111114111111111114200000000004310111111014411111111114

3、50000000000461111111111471111111111480000000000491111111111500000000000計數(shù)型量具測量結(jié)果數(shù)據(jù)表零件名稱量具名稱填表人規(guī)格量具編號日期計數(shù)型量具交叉分析表A與B交叉表B總計P0PeKappa01A0計算446500.940.5686%期望的計算15.734.350.01計算397100期望的計算31.368.7100.0總計計算47103150期望的計算47.0103.0150.0B與C交叉表C總計P0PeKappa01B0計算425470.910.5679%期望的計算16.031.047.01計算994103r期望的計算3

4、5.068.0103.0總計計算5199150期望的計算51.099.0150.0A與C交叉表C總計P0PeKappa01C0計算437500.900.5578%期望的計算17.033.050.01計算892100r期望的計算34.066.0100.0總計計算5199150期望的計算51.099.0150.0A與基準(zhǔn)交叉表基準(zhǔn)總計P0PeKappa01A0計算455500.950.5688%期望的計算16.034.050.01計算397100:期望的計算:32.068.0100.0總計計算48102150期望的計算48.0102.0150.0B與基準(zhǔn)交叉表基準(zhǔn)總計P0PeKappa01B0計算452470.970.5792%期望的計算15.032.047.01計算3100103r期望的計算:33.070.0103.0總計計算48102150期望的計算48.0102.0150.0B與基準(zhǔn)交叉表基準(zhǔn)總計P0PeKappa01C0計算429510.900.5677%期望的計算16.334.751.01計算69399:期望的計算:31.767.399.0總計計算48102150期望的計算48.0102.0150.0評價人的KappaABC評價> 0.75匚一致性好，可接受V 0.75一致性差,應(yīng)改