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

1、 测测量量系系统统分分析析（MSA）（MSA）GR&#R-GR&#R-数数据据记记录录表表 DataData WorksheetWorksheet报报告告编编号号Report NO.量具名称Equipment Name产品类型Description测量人员Operator测试日期Test Tate量具编号Equipment NO.基件编号P/N测量人员Operator平价人数Appraisers3参数规格Dimension0规格上限USL2测量人员Operator试验次数Trials3单位UnitMM规格下限LSL-2过程变差/过程能力ProcessVariation（/PP）样 品 数Sam

2、ples50分析时机Analytical OccasionPartA-1A-2A-3B-1B-2B-3C-1C-2C-3ReferenceRef ValueCode111111111110.476901+211111111110.509015+300000000000.576459-400000000000.566152-500000000000.57036-611011010010.544951711111110110.465454811111111110.502295+900000000000.437817-1011111111110.515573+1111111111110.488905

3、+1200000001000.5599181311111111110.542704+1411011110010.4545181511111111110.517377+1611111111110.531939+1711111111110.519694+1811111111110.484167+1911111111110.520496+2011111111110.477236+2111010101010.452312200101011000.5456042311111111110.529065+2411111111110.514192+2500000000000.599581-2601000000

4、100.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+

5、4111111111110.513779+4200000000000.566575-4310111111010.462414411111111110.470832+4500000000000.412453-4611111111110.493441+4711111111110.486379+4800000000000.587893-4911111111110.483803+5000000000000.446697-RegularNew QCPPPAPOtherA*B-CrasstabulationA*REF-CrasstabulationBTotalREFTotal0101A0Count4465

6、0A0Count45550Expected Count15.734.350.0Expected Count16.034.050.01Count3971001Count397100Expected Count31.368.7100.0Expected Count32.068.0100.0TotalCount47103150TotalCount48102150Expected Count47.0103.0150.0Expected Count48.0102.0150.0B*C-CrasstabulationB*REF-CrasstabulationCTotalREFTotal0101B0Count

7、42547B0Count45247Expected Count16.031.047.0Expected Count15.032.047.01Count9941031Count3100103Expected Count35.068.0103.0Expected Count33.070.0103.0TotalCount5199150TotalCount48102150Expected Count51.099.0150.0Expected Count48.0102.0150.0A*C-CrasstabulationC*REF-CrasstabulationCTotalREFTotal0101A0Co

8、unt43750C0Count42951Expected Count17.033.050.0Expected Count16.334.751.01Count8921001Count69399Expected Count34.066.0100.0Expected Count31.767.399.0TotalCount5199150TotalCount48102150Expected Count51.099.0150.0Expected Count48.0102.0150.0KappaABC%Appraiser%Score vs.Attribute2A0.860.78SourceABCABCB0.

9、860.79Total Inspected505050505050C0.780.79#Matched424540424540REF0.880.920.77False Negative（appraiser biased toward rejection）000Fales Positive（appraiser biased toward acceptance）000EffectivenessMiss RatrFalse AlarmRateMixed850A84%6%5%95%UCI93%97%90%93%97%90%B90%6%2%Calclated Score84%90%80%84%90%80%

10、C80%13%9%95%LCI71%78%66%71%78%66%DecisionEffectivenessMiss RatrFalse AlarmRateSystem%EffectiveScore3Syetem%Effective Scorevs.Reference4Measurement systemAcceptable for the appraiser90%2%5%Total inspected5050Marginally acceptable forthe appraiser-may needimprovement80%5%10%#in Agreement393995%UCI88%8

11、8%Unacceptable for theappraiser-needsimprovement80%5%10%Calculated Score78%78%95%LCI64%64%GR&#R判定10%通常被认为是一个可接受的测量体系。#当排列或分类零件，需要加强过程控制时被推荐运用。#样本：#对于产品控制的情况下，当测量结果与决定准则是确定“符合或不符合某特性的规范”（如：#100%检验或抽样），样品（或标准）必须被选择，但不需要包括整个过程范围。#测量系统的评估是以特性公差为基础（如对公差的%GRR）。#在过程研究情况下，当测量结果与决定准则是确定“过程稳定性、方向以及是否符合自然的过程变差

12、”（如：#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-3 A-S AFA1111111111111111111A

13、判NG概率0.3333111111101111111111111111111B判OK概率0.6867111111101010101010101010101B判NG概率0.3133101010101010101010101010101C判OK概率0.6600101010101010101010101010101C判NG概率0.34001010101011111011110111100OK概率0.6800111100011111111111111110NG概率0.3200111111101111111111111111111111111101010101010101010101错误的拒收FA101

14、010101111111111111111111错误的接受FR111111101111111111111111111不相配DI1111111010101010010100100101010101111111111111111111Xbar0.516111111110111101111111100STDEV0.042111110001111111111111111111D30.4590111111101111111111111111111D41.5410111111101111111111111111111A20.15301111111011111111111111111111111111011

15、11111111111111111UCLx0.5225111111101111111111111111111LCLx0.5097111111101110101111100UCLr0.064811110001001011100010LCLr0.019310101001111111111111111111111111101111111111111111111CPU-4.09111111101010101010101010101CPL4.0910101010101101010010100CPk0.0010110001111111111111111111Ppk-4.091111111011111111

16、11111111111111111101111111111111111111111111101010010101101010010101010111111111111111111111111110111111111111111111111111110111111111111111111111111110101011100111001101010100111111111111111111111111110111101111111100111100010101010101010101011010101011111111111111111111111111010101010101010101011010101011111111111111111111111111011111111111111111111111111010101010101010101011010101011011111111101011011001111111111111111111111111101010101010101010101101010101111111111111111111111111101111111111111111111111111