计数型MSA分析表.xls

上传人：asd****56

文档编号：69699125

上传时间：2023-01-07

格式：XLS

页数：13

大小：182.26KB

( 4.5 )

《计数型MSA分析表.xls》由会员分享，可在线阅读，更多相关《计数型MSA分析表.xls（13页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

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/完成日期310325/3/2004Appraiser-Trail/Appraiser-Trail/作作业业员员及及其其试试验验结结果果PartPart#/#/零零件件A-1A-2A-3B-1B-2B-3C-1C-2C-3Ref/Ref/参参考考值值1111111111121111111111300000000004000000000050000000000461111111111471111111111480000000000491111111111500000000000DataData Summary/

3、Summary/数数据据总总结结A*BA*CB*CA*RefB*RefC*Ref0*04443424545421*03893360*16755291*19792949710093SelfSelf agreement/agreement/自自评评 WithWith reference/reference/与与基基准准一一致致ABCABC424540424540A*B 交交叉叉表表B0.001.00 TotalPo:0.94A0.00 观观察察值值44650期期望望计计数数15.734.350Pe:0.561.00 观观察察值值397100 期期望望计计数数31.368.7100Total观观察察

4、值值47103150期期望望计计数数47.0103.0150B*C 交交叉叉表表C0.001.00 TotalPo:0.91B0.00 观观察察值值42547期期望望计计数数16.031.047Pe:0.561.00 观观察察值值994103期期望望计计数数35.068.0103Total观观察察值值5199150期期望望计计数数51.099.0150 Prepared by Richard Li Page 1 of 13A*C 交交叉叉表表C0.001.00 TotalPo:0.90A0.00 观观察察值值43750期期望望计计数数17.033.050 Pe:0.551.00 观观察察值值8

5、92100期期望望计计数数34.066.0100Total观观察察值值5199150期期望望计计数数51.099.0150A*BB*CA*CReproducibilityKappa0.8630.7880.776Conclude GoodGoodGoodKappa=(Po-Pe)/(1-Pe)A*REF CrosstabulationREF0.001.00 TotalPo:0.95A0.00 Count45550Expected Count16.034.050.0 Pe:0.561.00 Count397100Expected Count32.068.0100.0TotalCount481021

6、50Expected Count48.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

7、.0 Pe:0.561.00 Count69399Expected Count31.767.399.0TotalCount48102150Expected Count48.0102.0150.0ABCConcordanceKappa0.880.920.77ConcludeGoodGoodGoodRepeatability%AppraiserRepeatabilityABCTotal Inspected101010Matched424540%420%450%400%ConcludeGoodGoodGood漏漏发发Conclusion误误发发ConclusionA6.3%Unacceptable4

8、.9%AcceptableB6.3%Unacceptable2.0%AcceptableC12.5%Unacceptable8.8%UnacceptablePrepared by Richard Li Page 2 of 13ATTRIBUTEATTRIBUTE GAGEGAGE R&RR&R EFFECTIVENESSEFFECTIVENESS ANALYSIS/ANALYSIS/计计数数型型MSAMSA有有效效性性分分析析Part Number/产品编号:Gage Name/仪器名称:Appraiser A/作业员ANMP0000塞规赵Part Name/产品名称:Gage Number/

9、仪器编号:Appraiser B/作业员B印刷电路板800801钱Characteristic Classification/特性类别:Appraiser C/作业员C孔径1 Pass/通过孙Trials/试验次数Parts/零件样品数Appraisers/作业员0 Fail/未通过Date Performed/完成日期350325/3/2004Appraiser-Trail/Appraiser-Trail/作作业业员员及及其其试试验验结结果果PartPart#/#/零零件件A-1A-2A-3B-1B-2B-3C-1C-2C-3Ref/Ref/参参考考值值1111111111121111111

10、111300000000004000000000050000000000611011010017111111101181111111111900000000001011111111111111111111111200000001001311111111111411011110011511111111111611111111111711111111111811111111111911111111112011111111112111010101012200101011002311111111112411111111112500000000002601000000102711111111112811

11、11111111291111111111300000010000311111111111321111111111331111111111340010010110351111111111361101111011370000000000Prepared by Richard Li Page 3 of 1338111111111139000000000040111111111141111111111142000000000043101111110144111111111145000000000046111111111147111111111148000000000049111111111150000

12、0000000DataData Summary/Summary/数数据据总总结结A*BA*CB*CA*RefB*RefC*Ref0*04443424545421*03893360*16755291*19792949710093SelfSelf agreement/agreement/自自评评 WithWith reference/reference/与与基基准准一一致致ABCABC424540424540A*B CrosstabulationB0.001.00 TotalPo:0.94A0.00 Count44650Expected Count15.734.350Pe:0.561.00 Cou

13、nt397100 Expected Count31.368.7100TotalCount47103150Expected Count47.0103.0150B*C CrosstabulationC0.001.00 TotalPo: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 Cou

14、nt43750Expected Count17.033.050 Pe:0.551.00 Count892100Expected Count34.066.0100TotalCount5199150Expected Count51.099.0150A*BB*CA*CReproducibilityKappa0.8630.7880.776Conclude GoodGoodGoodKappa=(Po-Pe)/(1-Pe)A*REF CrosstabulationREFPrepared by Richard Li Page 4 of 130.001.00 TotalPo:0.95A0.00 Count45

15、550Expected Count16.034.050.0 Pe:0.561.00 Count397100Expected Count32.068.0100.0TotalCount48102150Expected Count48.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.

16、0102.0150.0C*REF CrosstabulationREF0.001.00Total Po:0.90C0.00 Count42951Expected Count16.334.751.0 Pe:0.561.00 Count69399Expected Count31.767.399.0TotalCount48102150Expected Count48.0102.0150.0ABCConcordanceKappa0.880.920.77ConcludeGoodGoodGoodRepeatability%AppraiserRepeatabilityABCTotal Inspected50

17、5050Matched424540%84%90%80%ConcludePoorGoodPoor漏漏发发Conclusion误误发发ConclusionA6.3%Unacceptable4.9%AcceptableB6.3%Unacceptable2.0%AcceptableC12.5%Unacceptable8.8%UnacceptablePrepared by Richard Li Page 5 of 13Statistical Report-Attribute Gage R&R Study%Appraiser to Self1%Appraiser Vs Standard2SourceOpe

18、rator1#Operator2#Operator3#Operator1#Operator2#Operator3#Total Inspected505050505050#Matched42454042454095%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=Pass000False Positive (ope

19、rator biased toward acceptance)Std=Fail000Mixed(Operator accepts and rejects the same part)8510Screen%EffectiveScore3Screen%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

20、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%70.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 opera

21、tors agreed within and between themselves4)All operators agreed within&between themselves AND agreed with the known standardDemoNMP0000塞规25/3/2004印刷电路板800801孔径赵钱孙111111111111110000000000000000000001101101111111111111110000000111111111111110000000111111111011111111111111111111111111111111111111111111

22、11110101000101011111111111111100000000100000111111111111111111111000001011111111111111111111100100101111111110111100000001111111000000011111111111111000000010111111111111000000011111111111111000000011111110000000Ref11111100000000000101111100011111110011100111111111111111111110110011111100001011111111100011111111111011101100011100011125/3/2004111000101111000111111000111000

文档加载中……请稍候！
如果长时间未打开，您也可以点击刷新试试。

下载文档到电脑，查找使用更方便

15 金币

版权申诉 word格式文档无特别注明外均可编辑修改；预览文档经过压缩，下载后原文更清晰！ 立即下载

配套讲稿：: 如PPT文件的首页显示word图标，表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
特殊限制：: 部分文档作品中含有的国旗、国徽等图片，仅作为作品整体效果示例展示，禁止商用。设计者仅对作品中独创性部分享有著作权。
关键词：: 计数 MSA 分析

淘文阁 - 分享文档赚钱的网站所有资源均是用户自行上传分享，仅供网友学习交流，未经上传用户书面授权，请勿作他用。

限制150内

关于本文

本文标题：计数型MSA分析表.xls
链接地址：https://www.taowenge.com/p-69699125.html