《MSA计数型GRR-KAPPA(第四版)自带公式》表格文件下载.xls

《MSA计数型GRR-KAPPA(第四版)自带公式》表格文件下载.xls

《《MSA计数型GRR-KAPPA(第四版)自带公式》表格文件下载.xls》由会员分享，可在线阅读，更多相关《《MSA计数型GRR-KAPPA(第四版)自带公式》表格文件下载.xls（7页珍藏版）》请在冰豆网上搜索。

测测量量系系统统分分析析（MSA）（MSA）GR&@#@R-GR&@#@R-数数据据记记录录表表DataDataWorksheetWorksheet报报告告编编号号ReportNO.量具名称EquipmentName产品类型Description测量人员Operator测试日期TestTate量具编号EquipmentNO.基件编号P/N测量人员Operator平价人数Appraisers3参数规格Dimension0规格上限USL2测量人员Operator试验次数Trials3单位UnitMM规格下限LSL-2过程变差/过程能力ProcessVariation（/PP）样品数Samples50分析时机AnalyticalOccasionPartA-1A-2A-3B-1B-2B-3C-1C-2C-3ReferenceRefValueCode111111111110.476901+211111111110.509015+300000000000.576459-400000000000.566152-500000000000.57036-611011010010.544951711111110110.465454811111111110.502295+900000000000.437817-1011111111110.515573+1111111111110.488905+1200000001000.5599181311111111110.542704+1411011110010.4545181511111111110.517377+1611111111110.531939+1711111111110.519694+1811111111110.484167+1911111111110.520496+2011111111110.477236+2111010101010.452312200101011000.5456042311111111110.529065+2411111111110.514192+2500000000000.599581-2601000000100.5472042711111111110.502436+2811111111110.521642+2911111111110.523754+3000000100000.5614573111111111110.503091+3211111111110.50585+3311111111110.487613+3400100101100.4496963511111111110.498698+3611011110110.5430773700000000000.409238-3811111111110.488184+3900000000000.427687-4011111111110.501132+4111111111110.513779+4200000000000.566575-4310111111010.462414411111111110.470832+4500000000000.412453-4611111111110.493441+4711111111110.486379+4800000000000.587893-4911111111110.483803+5000000000000.446697-RegularNewQCPPPAPOtherA*B-CrasstabulationA*REF-CrasstabulationBTotalREFTotal0101A0Count44650A0Count45550ExpectedCount15.734.350.0ExpectedCount16.034.050.01Count3971001Count397100ExpectedCount31.368.7100.0ExpectedCount32.068.0100.0TotalCount47103150TotalCount48102150ExpectedCount47.0103.0150.0ExpectedCount48.0102.0150.0B*C-CrasstabulationB*REF-CrasstabulationCTotalREFTotal0101B0Count42547B0Count45247ExpectedCount16.031.047.0ExpectedCount15.032.047.01Count9941031Count3100103ExpectedCount35.068.0103.0ExpectedCount33.070.0103.0TotalCount5199150TotalCount48102150ExpectedCount51.099.0150.0ExpectedCount48.0102.0150.0A*C-CrasstabulationC*REF-CrasstabulationCTotalREFTotal0101A0Count43750C0Count42951ExpectedCount17.033.050.0ExpectedCount16.334.751.01Count8921001Count69399ExpectedCount34.066.0100.0ExpectedCount31.767.399.0TotalCount5199150TotalCount48102150ExpectedCount51.099.0150.0ExpectedCount48.0102.0150.0KappaABC%Appraiser%Scorevs.Attribute2A0.860.78SourceABCABCB0.860.79TotalInspected505050505050C0.780.79#Matched424540424540REF0.880.920.77FalseNegative（appraiserbiasedtowardrejection）000FalesPositive（appraiserbiasedtowardacceptance）000EffectivenessMissRatrFalseAlarmRateMixed850A84%6%5%95%UCI93%97%90%93%97%90%B90%6%2%CalclatedScore84%90%80%84%90%80%C80%13%9%95%LCI71%78%66%71%78%66%DecisionEffectivenessMissRatrFalseAlarmRateSystem%EffectiveScore3Syetem%EffectiveScorevs.Reference4MeasurementsystemAcceptablefortheappraiser90%2%5%Totalinspected5050Marginallyacceptablefortheappraiser-mayneedimprovement80%5%10%#inAgreement393995%UCI88%88%Unacceptablefortheappraiser-needsimprovement80%5%10%CalculatedScore78%78%95%LCI64%64%GR&@#@R判定10%通常被认为是一个可接受的测量体系。

@#@当排列或分类零件，需要加强过程控制时被推荐运用。

@#@样本：

@#@对于产品控制的情况下，当测量结果与决定准则是确定“符合或不符合某特性的规范”（如：

@#@100%检验或抽样），样品（或标准）必须被选择，但不需要包括整个过程范围。

@#@测量系统的评估是以特性公差为基础（如对公差的%GRR）。

@#@在过程研究情况下，当测量结果与决定准则是确定“过程稳定性、方向以及是否符合自然的过程变差”（如：

@#@SPC、过程控制、能力及过程改进），在整个作业过程范围的样本可获得性变得非常重要。

@#@当评估一测量系统对过程控制的适用性时（如对过程变差的%GRR），推荐采用过程变差的独立估计法（过程能力研究）。

@#@10%30%在某些适用情况下被认为可接受。

@#@30%被认为是不可接受的。

@#@补充：

@#@kappa大于0.75表示有很好的一致如果Ppk大于1，则将测量系统与过程进行比较如果Ppk小于1，则将测量系统与公差进行比较A-B-1A-B-2A-B-3B-C-1B-C-2B-C-3A-C-1A-C-2A-C-3A判OK概率0.6667A-1A-2A-3A-SAFA1111111111111111111A判NG概率0.3333111111101111111111111111111B判OK概率0.6867111111101010101010101010101B判NG概率0.3133101010101010101010101010101C判OK概率0.6600101010101010101010101010101C判NG概率0.34001010101011111011110111100OK概率0.6800111100011111111111111110NG概率0.3200111111101111111111111111111111111101010101010101010101错误的拒收FA101010101111111111111111111错误的接受FR111111101111111111111111111不相配DI1111111010101010010100100101010101111111111111111111Xbar0.516111111110111101111111100STDEV0.042111110001111111111111111111D30.4590111111101111111111111111111D41.5410111111101111111111111111111A20.1530111111101111111111111111111111111101111111111111111111UCLx0.5225111111101111111111111111111LCLx0.5097111111101110101111100UCLr0.064811110001001011100010LCLr0.019310101001111111111111111111111111101111111111111111111CPU-4.09111111101010101010101010101CPL4.0910101010101101010010100CPk0.0010110001111111111111111111Ppk-4.09111111101111111111111111111111111101111111111111111111111111101010010101101010010101010111111111111111111111111110111111111111111111111111110111111111111111111111111110101011100111001101010100111111111111111111111111110111101111111100111100010101010101010101011010101011111111111111111111111111010101010101010101011010101011111111111111111111111111011111111111111111111111111010101010101010101011010101011011111111101011011001111111111111111111111111101010101010101010101101010101111111111111111111111111101111111111111111111111111