MSA计数型分析报告.xlsVIP

Sheet3

报告

数据表

Print_Area

计数型测量系统研究—KAPPA分析法(数据表)

量具名称

量具类型

编制

测量日期

2023.12.5

量具编号

测量特性

评价人

Part

A-1

A-2

A-3

B-1

B-2

B-3

C-1

C-2

C-3

refer

ref.value

code

+

-

x

0:0------A

0:1------C

1:0------B

1:1-----D

A1*B1

A2*B2

A3*B3

A1*C1

A2*C2

A3*C3

B1*C1

B2*C2

B3*C3

Self-A

Self-B

Self-C

A1*Ref

A2*Ref

A3*Ref

B1*Ref

B2*Ref

B3*Ref

C1*Ref

C2*Ref

C3*Ref

b

DataSummary/数据总结

A*B

A*C

B*C

A*Ref

B*Ref

C*Ref

0*0

1*0

0*1

1*1

计数型测量系统研究—KAPPA分析法(报告)

B

总计

Ref

A

0计算

期望的计算

1计算

计算

C

c

操作者间

与Ref比较

Kappa

0计算

Conclude

1计算

漏发

Conclusion

误发

计算

审核

=0.377/0.437=0.863

.00

1.00

.00

1.00

44.00

5.00

49.00

45.00

5.00

50.00

15.68

33.32

49.00

16.00

34.00

50.00

4.00

97.00

101.00

3.00

97.00

100.00

32.32

68.68

101.00

32.00

68.00

100.00

48.00

102.00

150.00

48.00

102.00

150.00

48.00

102.00

150.00

48.00

102.00

150.00

.00

1.00

.00

1.00

42.00

5.00

47.00

45.00

2.00

47.00

15.98

31.02

47.00

15.04

31.96

47.00

9.00

94.00

103.00

3.00

100.00

103.00

35.02

67.98

103.00

32.96

70.04

103.00

51.00

99.00

150.00

48.00

102.00

150.00

51.00

99.00

150.00

48.00

102.00

150.00

.00

1.00

.00

1.00

43.00

7.00

50.00

42.00

9.00

51.00

17.00

33.00

50.00

16.32

34.68

51.00

.91

42.00

94.00

150.00

8.00

92.00

100.00

6.00

93.00

99.00

34.00

66.00

100.00

31.68

67.32

99.00

51.00

99.00

150.00

48.00

102.00

150.00

51.00

99.00

150.00

48.00

102.00

150.00

.00

1.00

.86

1.00

.79

1.00

.78

1.00

.88

1.00

.92

1.00

.77

1.00

42.00

5.00

47.00

Good

Good

Good

Good

Good

Good

16.00

31.00

47.00

9.00

94.00

103.00

35.00

68.00

103.00

51.00

99.00

150.00

51.00

99.00

150.00

.06

.05

.94

44.00

97.00

150.00

.06

.02

.13

.09

.79

.91

.56

1.00

.56

8.计算期望：

32.3=（101*48）/150,用此方法计算出A*C/B*C

15.7=(48*49)/150

33.3=(102*49)/150

68.7=(102*101)/150

9.计算期望A与基准值：32.0=（100*48）/150,用此方法计算出A/B/C

68.0=(102*100)/150

10.计算Po=（测量0*0一致概率+1*1一致概率）/总和=（44+97）/150=0.94

11.计算Pe=（期望0*0一致概率+期望1*1一致概率）/总和=（15.7+68.7）/150=0.563

12.Kappa=(Po-Pe)/(1-Pe)=(0.94-0.563)/(1-0.563)

10.计算Po=（测量0*0一致概率+1*1一致概率）/总和=（42+94）/150=0.9067

11.计算Pe=（期望0*0一致概率+期望1*1一致概率）/总和=（16+68）/150=0.56

12.Kappa=(Po-Pe)/(1