计数型MSA分析表.xls

Prepared by Richard Li Page 1 of 13 ATTRIBUTEATTRIBUTE GAGEGAGE R RR R EFFECTIVENESSEFFECTIVENESS ANALYSIS ANALYSIS 计计数数型型MSAMSA有有效效性性分分析析 Part Number 产品编号 Gage Name 仪器名称 Appraiser A 作业员A NMP0000 螺纹塞规张 Part Name 产品名称 Gage Number 仪器编号 Appraiser B 作业员B 管座800801乔 Characteristic Classification 特性类别 Appraiser C 作业员C 内螺纹 1 Pass 通过 李 Trials 试验次数Parts 零件样品数Appraisers 作业员0 Fail 未通过Date Performed 完成日期 310325 3 2004 Appraiser Trail Appraiser Trail 作作业业员员及及其其试试验验结结果果 PartPart 零零件件A 1A 2A 3B 1B 2B 3C 1C 2C 3Ref Ref 参参考考值值 11111111111 21111111111 30000000000 40000000000 50000000000 461111111111 471111111111 480000000000 491111111111 500000000000 DataData Summary Summary 数数据据总总结结 A BA CB CA RefB RefC Ref 0 0444342454542 1 0389336 0 1675529 1 19792949710093 SelfSelf agreement agreement 自自评评 WithWith reference reference 与与基基准准一一致致 ABCABC 424540424540 A B 交交叉叉表表 B 0 001 00 TotalPo 0 94 A0 00 观观察察值值44650 期期望望计计数数15 734 350Pe 0 56 1 00 观观察察值值 397100 期期望望计计数数31 368 7100 Total观观察察值值47103150 期期望望计计数数47 0103 0150 B C 交交叉叉表表 C 0 001 00 TotalPo 0 91 B0 00 观观察察值值42547 期期望望计计数数16 031 047Pe 0 56 1 00 观观察察值值 994103 期期望望计计数数35 068 0103 Total观观察察值值5199150 期期望望计计数数51 099 0150 Prepared by Richard Li Page 2 of 13 A C 交交叉叉表表 C 0 001 00 TotalPo 0 90 A0 00 观观察察值值43750 期期望望计计数数17 033 050 Pe 0 55 1 00 观观察察值值 892100 期期望望计计数数34 066 0100 Total观观察察值值5199150 期期望望计计数数51 099 0150 A BB CA CReproducibility Kappa0 8630 7880 776 Conclude GoodGoodGood Kappa Po Pe 1 Pe A REF Crosstabulation REF 0 001 00 TotalPo 0 95 A0 00 Count45550 Expected Count16 034 050 0 Pe 0 56 1 00 Count397100 Expected Count32 068 0100 0 TotalCount48102150 Expected Count48 0102 0150 0 B REF Crosstabulation REF 0 001 00 TotalPo 0 97 B0 00 Count45247 Expected Count15 032 047 0 Pe 0 57 1 00 Count3100103 Expected Count33 070 0103 0 TotalCount48102150 Expected Count48 0102 0150 0 C REF Crosstabulation REF 0 001 00Total Po 0 90 C0 00 Count42951 Expected Count16 334 751 0 Pe 0 56 1 00 Count69399 Expected Count31 767 399 0 TotalCount48102150 Expected Count48 0102 0150 0 ABCConcordance Kappa0 880 920 77 ConcludeGoodGoodGood Repeatability AppraiserRepeatability ABC Total Inspected101010 Matched424540 420 450 400 ConcludeGoodGoodGood 漏漏发发Conclusion误误发发Conclusion A6 3 Unacceptable4 9 Acceptable B6 3 Unacceptable2 0 Acceptable C12 5 Unacceptable8 8 Unacceptable Prepared by Richard Li Page 3 of 13 ATTRIBUTEATTRIBUTE GAGEGAGE R RR R EFFECTIVENESSEFFECTIVENESS ANALYSIS ANALYSIS 计计数数型型MSAMSA有有效效性性分分析析 Part Number 产品编号 Gage Name 仪器名称 Appraiser A 作业员A NMP0000 塞规赵 Part Name 产品名称 Gage Number 仪器编号 Appraiser B 作业员B 印刷电路板800801钱 Characteristic Classification 特性类别 Appraiser C 作业员C 孔径 1 Pass 通过 孙 Trials 试验次数Parts 零件样品数Appraisers 作业员0 Fail 未通过Date Performed 完成日期 350325 3 2004 Appraiser Trail Appraiser Trail 作作业业员员及及其其试试验验结结果果 PartPart 零零件件A 1A 2A 3B 1B 2B 3C 1C 2C 3Ref Ref 参参考考值值 11111111111 21111111111 30000000000 40000000000 50000000000 61101101001 71111111011 81111111111 90000000000 101111111111 111111111111 120000000100 131111111111 141101111001 151111111111 161111111111 171111111111 181111111111 191111111111 201111111111 211101010101 220010101100 231111111111 241111111111 250000000000 260100000010 271111111111 281111111111 291111111111 300000010000 311111111111 321111111111 331111111111 340010010110 351111111111 361101111011 Prepared by Richard Li Page 4 of 13 370000000000 381111111111 390000000000 401111111111 411111111111 420000000000 431011111101 441111111111 450000000000 461111111111 471111111111 480000000000 491111111111 500000000000 DataData Summary Summary 数数据据总总结结 A BA CB CA RefB RefC Ref 0 0444342454542 1 0389336 0 1675529 1 19792949710093 SelfSelf agreement agreement 自自评评 WithWith reference reference 与与基基准准一一致致 ABCABC 424540424540 A B Crosstabulation B 0 001 00 TotalPo 0 94 A0 00 Count44650 Expected Count15 734 350Pe 0 56 1 00 Count397100 Expected Count31 368 7100 TotalCount47103150 Expected Count47 0103 0150 B C Crosstabulation C 0 001 00 TotalPo 0 91 B0 00 Count42547 Expected Count16 031 047Pe 0 56 1 00 Count994103 Expected Count35 068 0103 TotalCount5199150 Expected Count51 099 0150 A C Crosstabulation C 0 001 00 TotalPo 0 90 A0 00 Count43750 Expected Count17 033 050 Pe 0 55 1 00 Count892100 Expected Count34 066 0100 TotalCount5199150 Expected Count51 099 0150 A BB CA CReproducibility Kappa0 8630 7880 776 Conclude GoodGoodGood Kappa Po Pe 1 Pe Prepared by Richard Li Page 5 of 13 A REF Crosstabulation REF 0 001 00 TotalPo 0 95 A0 00 Count45550 Expected Count16 034 050 0 Pe 0 56 1 00 Count397100 Expected Count32 068 0100 0 TotalCount48102150 Expected Count48 0102 0150 0 B REF Crosstabulation REF 0 001 00 TotalPo 0 97 B0 00 Count45247 Expected Count15 032 047 0 Pe 0 57 1 00 Count3100103 Expected Count33 070 0103 0 TotalCount48102150 Expected Count48 0102 0150 0 C REF Crosstabulation REF 0 001 00Total Po 0 90 C0 00 Count42951 Expected Count16 334 751 0 Pe 0 56 1 00 Count69399 Expected Count31 767 399 0 TotalCount48102150 Expected Count48 0102 0150 0 ABCConcordance Kappa0 880 920 77 ConcludeGoodGoodGood Repeatability AppraiserRepeatability ABC Total Inspected505050 Matched424540 84 90 80 ConcludePoorGoodPoor 漏漏发发Conclusion误误发发Conclusion A6 3 Unacceptable4 9 Acceptable B6 3 Unacceptable2 0 Acceptable C12 5 Unacceptable8 8 Unacceptable Statistical Report Attribute Gage R R Study Appraiser to Self1 Appraiser Vs Standard2 Source Operator 1 Operator 2 Operator 3 Operator 1 Operator 2 Operator 3 Total Inspected505050505050 Matched424540424540 95 UCL92 8 96 7 90 0 92 8 96 7 90 0 Calculated Score84 0 90 0 80 0 84 0 90 0 80 0 95 LCL70 9 78 2 66 3 70 9 78 2 66 3 False Negative operator biased toward rejection Std Pass000 False Positive operator biased toward acceptance Std Fail000 Mixed Operator accepts and rejects the same part 8510 Screen Effective Score3 Screen Effective Score vs Standard4 Total Inspected5050 in Agreement3939 95 UCL88 5 88 5 Calculated Score78 0 78 0 95 LCL64 0 64 0 Notes 1 Operator agrees with him herself on both trials 2 Operator agrees on both trials with the known standard Apprraiser to Self 123 0 0 10 0 20 0 30 0 40 0 50 0 60 0 70 0 80 0 90 0 100 0 Efficiency 95 UCLCalculated Score95 LCL Appraiser Vs Standard 123 0 0 10 0 20 0 30 0 40 0 50 0 60 0 70 0 80 0 90 0 100 0 Efficiency 95 UCLCalculated Score95 LCL 3 All operators agreed within and between themselves 4 All operators agreed within