计数型MSA分析表(最新)
- 格式:xls
- 大小:174.00 KB
- 文档页数:3
1、2、3、4、5、线性GRR计数型Kappa分析MSA测量系统分析全套表格模板稳定性偏倚Excel原件可在本文档左侧回形针处取出再现性Kappa=(Po-Pe)/(1-Pe)A*参考 交叉表A01总计Po:0.95Pe:0.51B*参考 交叉表B01总计Po:0.97Pe:0.51C*参考 交叉表C01总计Po:0.96Pe:0.5130期望的数量26.4636.5463数量38487期望的数量数量60363一致性好6666Kappa 一致性好判定误发期望的数量638728 4.76%可接受2.30%可接受 4.76%可接受3.45%可接受可接受5.75%可接受01参考总计62063871501C0.90有效性判定重复性检查总数匹配数漏发A A B 评价人评价人%B 93.33%可接受判 定判定0.9383.33%2530 3.17%36.5450.4687数量638715090.00%可接受0.92A C 一致性好150期望的数量B 期望的数量36.9651.0488数量6387150期望的数量26.0435.9662数量38588期望的数量6387数量60248.7284150数量6387150期望的数量35.28数量28284总计01Kappa 判 定A*B 0.89一致性好C 3027A*C 0.93一致性好参考B*C 参考总计可接受期望的数量27.7238.280.90一致性好数量615Page 11 of 11。
样品A-1A-2A-3B-1B-2B-3C-1C-2C-3标准111111111112111111111131111111111400000000005111111111161111111111711111111118111111111190000000000101111111111111111111111121111111111131111111111141111111111150000000000161111111111171111111111181111111111191111111111201111111111211111111111221111111111231111111111241111111111251111111111260000000000271111111111281111111111291111111111301111111111311111111111321111111111331111111111341111111111351111111111360000000000371111111111381111111111391111111111401111111111411111111111421111111111431111111111441111111011451111111111460000000000471111111111481111111111491111111111501111111111测量次数3样品审核50测量人员3产品料号02Z0010037A0针规操作员 A Appraiser-Trail测量参数参数规格±0.02mm 0.4-0.6mm 操作员 B 操作员CXZG-QA-290.001mm ATTRIBUTE DATA RESULTS仪器精确度仪器编号仪器名称产品名称线路板测量次数3样品审核50测量人员3产品料号02Z0010037A0测量参数参数规格±0.02mm 0.4-0.6mm 操作员 B 操作员CXZG-QA-290.001mm 仪器精确度仪器编号Data Summary/数据总结A*B A*C B*C A*Ref B*Ref C*Ref0*01818181212121*00110000*10000011*1132131131787877Self agreement/自评 A B C505049A*B Crosstabulation0.00 1.00Total Po: 1.000.0018018Expected Count 2.215.818Pe:0.791.000132132Expected Count 15.8116.21321813215018.0132.0150B*C Crosstabulation0.00 1.00Total Po:0.990.00180182.315.718Pe:0.781.001131132Expected Count 16.7115.31321913115019.0131.0150A*C Crosstabulation0.00 1.00Total Po:0.990.00180182.315.718Pe:0.781.00113113216.7115.31321913115019.0131.0150ReproducibilityKappaConclude A*REF CrosstabulationCountExpected Count CountExpected Count CountCountExpected Count CountA TotalTotalCountExpected Count CountExpected CountTotalCountCountBB Expected CountA GoodB*C 0.969GoodA*C 0.969GoodC C A*B1.000测量次数3样品审核50测量人员3产品料号02Z0010037A0测量参数参数规格±0.02mm 0.4-0.6mm 操作员 B 操作员CXZG-QA-290.001mm 仪器精确度仪器编号0.00 1.00Total Po: 1.000.0012012Expected Count 1.610.412.0Pe:0.771.0007878Expected Count 10.467.678.0127890Expected Count12.078.090.0B*REF Crosstabulation0.00 1.00Total Po: 1.000.0012012Expected Count 1.610.412.0Pe:0.771.0007878Expected Count 10.467.678.0127890Expected Count12.078.090.0C*REF Crosstabulation0.00 1.00Total Po:0.990.0012113Expected Count 1.711.313.0Pe:0.761.000777710.366.777.012789012.078.090.0ABCConcordanceKappa 1.00 1.000.95ConcludeGoodGoodGoodRepeatabilityA B C 505050505049100%100%98%Good GoodGoodAB CC TotalCountCountExpected Count CountExpected Count CountCountCountCountB TotalCountCountA TotalConcludeConclusion% Appraiser Total Inspected Matched Repeatability %漏发REF 0%0%0%0%Acceptable 0%1%Acceptable AcceptableConclusionREF REF Acceptable Acceptable 误发Acceptable0:0 ------ A0:1------ C1:0 ------ B1:1 ----- DA*B A*B A*B A*C A*C A*C B*C B*C B*C Self-AD D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 A A A A A A A A A1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 A A A A A A A A A1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 A A A A A A A A A1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 A A A A A A A A A1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 A A A A A A A A A1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D B D D B D1 D D D D D D D D D1 A A A A A A A A A1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1 D D D D D D D D D1A*Ref A*Ref A*Ref B*Ref B*Ref B*Ref C*Ref C*Ref C*Ref D D D D D D D D DD D D D D D D D DD D D D D D D D DA A A A A A A A AD D D D D D D D DD D D D D D D D DD D D D D D D D DD D D D D D D D DA A A A A A A A AD D D D D D D D DD D D D D D D D DD D D D D D D D DD D D D D D D D DD D D D D D D D DA A A A A A A A AD D D D D D D D DD D D D D D D D DD D D D D D D D DD D D D D D D D DD D D D D D D D DD D D D D D D D DD D D D D D D D DD D D D D D D D DD D D D D D D C DD D D D D D D D DA A A A A A A A AD D D D D D D D DD D D D D D D D DD D D D D D D D DD D D D D D D D DSelf-B Self-C1111111111111111111111111111111111111111111111111111111111111111111111111111111111111110111111111111。