计数型MSA分析表.xls

1、ATTRIBUTEATTRIBUTE GAGEGAGE R&RR&R EFFECTIVENESSEFFECTIVENESS ANALYSIS/ANALYSIS/计计数数型型MSAMSA有有效效性性分分析析Part Number/产品编号:Gage Name/仪器名称:Appraiser A/作业员ANMP0000塞规赵Part Name/产品名称:Gage Number/仪器编号:Appraiser B/作业员B印刷电路板800801钱Characteristic Classification/特性类别:Appraiser C/作业员C孔径1 Pass/通过孙Trials/试验次数Parts/

2、零件样品数Appraisers/作业员0 Fail/未通过Date Performed/完成日期350325/3/2004Appraiser-Trail/Appraiser-Trail/作作业业员员及及其其试试验验结结果果PartPart#/#/零零件件A-1A-2A-3B-1B-2B-3C-1C-2C-3Ref/Ref/参参考考值值111111111112111111111130000000000400000000005000000000061101101001711111110118111111111190000000000101111111111111111111111120000000

3、100131111111111141101111001151111111111161111111111171111111111181111111111191111111111201111111111211101010101220010101100231111111111241111111111250000000000260100000010271111111111281111111111291111111111300000010000311111111111321111111111331111111111340010010110351111111111361101111011370000000

4、000Prepared by Richard Li Page 1 of 11381111111111390000000000401111111111411111111111420000000000431011111101441111111111450000000000461111111111471111111111480000000000491111111111500000000000DataData Summary/Summary/数数据据总总结结A*BA*CB*CA*RefB*RefC*Ref0*04443424545421*03893360*16755291*19792949710093

5、SelfSelf agreement/agreement/自自评评 WithWith reference/reference/与与基基准准一一致致ABCABC424540424540A*B CrosstabulationB0.001.00 TotalPo:0.94A0.00 Count44650Expected Count15.734.350Pe:0.561.00 Count397100 Expected Count31.368.7100TotalCount47103150Expected Count47.0103.0150B*C CrosstabulationC0.001.00 TotalP

6、o:0.91B0.00 Count42547Expected Count16.031.047Pe:0.561.00 Count994103Expected Count35.068.0103TotalCount5199150Expected Count51.099.0150 A*C CrosstabulationC0.001.00 TotalPo:0.90A0.00 Count43750Expected Count17.033.050 Pe:0.551.00 Count892100Expected Count34.066.0100TotalCount5199150Expected Count51

7、.099.0150A*BB*CA*CReproducibilityKappa0.8630.7880.776Conclude GoodGoodGoodKappa=(Po-Pe)/(1-Pe)A*REF CrosstabulationREFPrepared by Richard Li Page 2 of 110.001.00 TotalPo:0.95A0.00 Count45550Expected Count16.034.050.0 Pe:0.561.00 Count397100Expected Count32.068.0100.0TotalCount48102150Expected Count4

8、8.0102.0150.0B*REF CrosstabulationREF0.001.00 TotalPo:0.97B0.00 Count45247Expected Count15.032.047.0 Pe:0.571.00 Count3100103Expected Count33.070.0103.0TotalCount48102150Expected Count48.0102.0150.0C*REF CrosstabulationREF0.001.00Total Po:0.90C0.00 Count42951Expected Count16.334.751.0 Pe:0.561.00 Co

9、unt69399Expected Count31.767.399.0TotalCount48102150Expected Count48.0102.0150.0ABCConcordanceKappa0.880.920.77ConcludeGoodGoodGoodRepeatability%AppraiserRepeatabilityABCTotal Inspected505050Matched424540%84%90%80%ConcludePoorGoodPoor漏漏发发Conclusion误误发发ConclusionA6.3%Unacceptable4.9%AcceptableB6.3%Un

10、acceptable2.0%AcceptableC12.5%Unacceptable8.8%UnacceptablePrepared by Richard Li Page 3 of 11Statistical Report-Attribute Gage R&R Study%Appraiser to Self1%Appraiser Vs Standard2SourceOperator1#Operator2#Operator3#Operator1#Operator2#Operator3#Total Inspected505050505050#Matched42454042454095%UCL92.

11、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=Pass000False Positive (operator biased toward acceptance)Std=Fail000Mixed(Operator accepts and rejects the same part)8510Screen%EffectiveSc

12、ore3Screen%EffectiveScore vs Standard4Total Inspected5050#in Agreement393995%UCL88.5%88.5%Calculated Score78.0%78.0%95%LCL64.0%64.0%Notes1)Operator agrees with him/herself on both trials 2)Operator agrees on both trials with the known standard%Apprraiser to Self1230.0%10.0%20.0%30.0%40.0%50.0%60.0%7

13、0.0%80.0%90.0%100.0%Efficiency95%UCLCalculated Score95%LCL%Appraiser Vs Standard1230.0%10.0%20.0%30.0%40.0%50.0%60.0%70.0%80.0%90.0%100.0%Efficiency95%UCLCalculated Score95%LCL3)All operators agreed within and between themselves4)All operators agreed within&between themselves AND agreed with the kno

14、wn standardDemoNMP0000塞规印刷电路板800801孔径赵钱孙11111111111100000000000000000011011011111111111100000011111111111100000011111111011111111111111111111111111111111111111111010100101011111111111100000001000011111111111111111100000111111111111111111100100111111111011100000011111100000011111111111100000010111111111100000011111111111100000011111100000025/3/2004Ref11111111000000000000100110111111000011111111010011111001111111111111111111111111010111001111111100000010111111111111000011111111111101101111101100001111000011111111000011011111000011111111000011110000