参考 MSA - KAPPA表 带公式.xls

XXX有有限限公公司司 Attribute Gage Study KAPPA Part NumberGage NameAppraiser A 目测 Part NameGage NumberAppraiser B Total Tol HighLowGage TypeAppraiser C Spec Go NGAttribute Characteristic ClassificationTrialsPartsAppraisersDate Performed 3503 Appraiser Trail Ref Part A 1A 2A 3B 1B 2B 3C 1C 2C 3 11111111111 21111111111 31111111111 40000000000 51111111111 61111111111 71111111111 81111111111 91111111111 101111111111 111111111111 121111111111 131111111111 141111111111 150000000000 161111111111 171111111111 181111111111 191111111111 201111111111 211111111111 221111111111 231111111111 241111111111 251111111111 261111111111 271111111111 281111111111 291111111111 301111111111 311111111111 321111111111 331111111111 341111111111 350000000000 361111111111 371111111111 381111111111 391111111111 401111111111 411111111111 421111111111 431111111111 441111111111 451111111111 460000000000 471111111111 481111111111 491111111111 501110111111 Data Summary A BA CB CA RefB RefC Ref 0 0121212121212 1 0100000 0 1001010 1 1137138137138137138 Reproducibility between Appraisers A BB CA C Kappa95 64 95 64 100 00 ConcludeGoodGoodGood Kappa Po Pe 1 Pe Good Kappa 75 00 Consistency between Appraisers and Ref A RefB RefC Ref Kappa100 00 95 64 100 00 ConcludeGoodGoodGood Kappa Po Pe 1 Pe Good Kappa 75 00 Validity Repeatability ABC Total Inspected Parts505050 Matched504950 Matched Rate 100 0 98 0 100 0 ConcludeGoodGoodGood Good Matched Rate 90 00 Capability of Finding NG Parts ABC NG Parts Inspected Times121212 Unfound000 Unfound Rate 0 0 0 0 0 0 ConcludeAcceptableAcceptableAcceptable Good Unfound Rate 2 00 Capability of Judgment ABC Total Inspected Times150150150 Misjudged010 Misjudged 0 0 0 7 0 0 ConcludeAcceptableAcceptableAcceptable Good Misjudged Rate 5 00 CONCLUSION Gage Approved Use It 0 0 A0 1 C 1 0 B1 1 D A BA BA BA CA CA CB CB CB CSelf ASelf B DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 AAAAAAAAA11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 AAAAAAAAA11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 AAAAAAAAA11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 AAAAAAAAA11 DDDDDDDDD11 DDDDDDDDD11 DDDDDDDDD11 BDDDDDCDD10 500A RefA RefA RefB RefB RefB RefC RefC RefC Ref DDDDDDDDD GoodDDDDDDDDDA B Crosstabulation A与与B交交叉叉表表 PoorDDDDDDDDD UnacceptableAAAAAAAAA AcceptableDDDDDDDDD A DDDDDDDDD 1DDDDDDDDD 1DDDDDDDDD 1DDDDDDDDDTotal DDDDDDDDD DDDDDDDDD DDDDDDDDDB C Crosstabulation B与与C交交叉叉表表 1DDDDDDDDD 1DDDDDDDDD 1AAAAAAAAA B DDDDDDDDD DDDDDDDDD DDDDDDDDD DDDDDDDDDTotal 1DDDDDDDDD 1DDDDDDDDD 1DDDDDDDDDA C Crosstabulation A与与C交交叉叉表表 DDDDDDDDD DDDDDDDDD DDDDDDDDD A DDDDDDDDD DDDDDDDDD 1DDDDDDDDD 1DDDDDDDDDTotal 1DDDDDDDDD DDDDDDDDD DDDDDDDDD DDDDDDDDD DDDDDDDDD AAAAAAAAAA REF Crosstabulation A与与基基准准判判断断交交叉叉表表 1DDDDDDDDD 1DDDDDDDDD 1DDDDDDDDD A DDDDDDDDD DDDDDDDDD DDDDDDDDD 1DDDDDDDDDTotal DDDDDDDDD Gage Approved Use It DDDDDDDDD Gage System Needs Improvement DDDDDDDDDB REF Crosstabulation B与与基基准准判判断断交交叉叉表表 AAAAAAAAA DDDDDDDDD DDDDDDDDD B DDDDDDDDD DDDCDDDDD Total C REF Crosstabulation C与与基基准准判判断断交交叉叉表表 C Total Self C 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 B 0 001 00TotalPo 0 99 0 00Count12012 Expected Count1 011 012Pe 0 85 1 00Count1137138 Expected Count12 0126 0138 Count13137150 Expected Count13 0137 0150 C 0 001 00TotalPo 0 99 0 00Count12113 Expected Count1 012 013Pe 0 85 1 00Count0137137 Expected Count11 0126 0137 Count12138150 Expected Count12 0138 0150 C 0 001 00TotalPo 1 00 0 00Count12012 Expected Count1 011 012Pe 0 85 1 00Count0138138 Expected Count11 0127 0138 Count12138150 Expected Count12 0138 0150 A B Crosstabulation A与与B交交叉叉表表 B C Crosstabulation B与与C交交叉叉表表 A C Crosstabulation A与与C交交叉叉表表 A REF Crosstabulation A与与基基准准判判断断交交叉叉表表 REF 0 001 00TotalPo 1 00 0 00Count12012 Expected Count1 011 012 0Pe 0 85 1 00Count0138138 Expected Count11 0127 0138 0 Count12138150 Expected Count12 0138 0150 0 REF 0 001 00TotalPo 0 99 0 00Count12113 Expected Count1 012 013 0Pe 0 85 1 00Count0137137 Expected Count11 0126 0137 0 Count12138150 Expected Count12 0138 0150 0 REF 0 001 0