计数型MSA分析表.xls

上传人:asd****56 文档编号:69699125 上传时间:2023-01-07 格式:XLS 页数:13 大小:182.26KB
返回 下载 相关 举报
计数型MSA分析表.xls_第1页
第1页 / 共13页
计数型MSA分析表.xls_第2页
第2页 / 共13页
点击查看更多>>
资源描述

《计数型MSA分析表.xls》由会员分享,可在线阅读,更多相关《计数型MSA分析表.xls(13页珍藏版)》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。

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

展开阅读全文
相关资源
相关搜索

当前位置:首页 > 应用文书 > 财经金融

本站为文档C TO C交易模式,本站只提供存储空间、用户上传的文档直接被用户下载,本站只是中间服务平台,本站所有文档下载所得的收益归上传人(含作者)所有。本站仅对用户上传内容的表现方式做保护处理,对上载内容本身不做任何修改或编辑。若文档所含内容侵犯了您的版权或隐私,请立即通知淘文阁网,我们立即给予删除!客服QQ:136780468 微信:18945177775 电话:18904686070

工信部备案号:黑ICP备15003705号© 2020-2023 www.taowenge.com 淘文阁