GRR计算例子完整

检具重复性和再现性数据收集表,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,

评价人：,3,零件,,,,,,,,,零件数：,10,,X轴,散点图,误差图,残差,评价人

试验次数：,3,1,2,3,4,5,6,7,8,9,10,平均值,,11,0.3,0.028888889,,1

评价人1,试验人1,0.30,0.21,0.35,0.21,0.22,0.11,0.10,0.11,0.06,0.29,0.196,,12,0.3,0.028888889,,1

李树红,试验人2,0.30,0.21,0.34,0.22,0.23,0.12,0.11,0.12,0.07,0.28,0.2,,13,0.3,0.028888889,,1

,试验人3,0.30,0.23,0.35,0.23,0.22,0.12,0.12,0.10,0.06,0.28,0.201,,14,0.31,0.038888889,,2

,平均值,0.3,0.216666667,0.346666667,0.22,0.223333333,0.116666667,0.11,0.11,0.063333333,0.283333333,0.199,,15,0.3,0.028888889,,2

,极差,0,0.02,0.01,0.02,0.01,0.01,0.02,0.02,0.01,0.01,0.013,,16,0.3,0.028888889,,2

评价人2,试验人1,0.31,0.21,0.35,0.23,0.21,0.12,0.19,0.12,0.01,0.32,0.207,,17,0.21,-0.061111111,,3

陈朦朦,试验人2,0.30,0.19,0.36,0.22,0.22,0.14,0.18,0.11,0.00,0.31,0.203,,18,0.22,-0.051111111,,3

,试验人3,0.30,0.18,0.34,0.22,0.23,0.13,0.18,0.10,0.00,0.32,0.2,,19,0.2,-0.071111111,,3

,平均值,0.303333333,0.193333333,0.35,0.223333333,0.22,0.13,0.183333333,0.11,0.003333333,0.316666667,0.203333333,,21,0.21,0.006666667,,1

,极差,0.01,0.03,0.02,0.01,0.02,0.02,0.01,0.02,0.01,0.01,0.016,,22,0.21,0.006666667,,1

评价人3,试验人1,0.21,0.21,0.30,0.30,0.28,0.10,0.10,0.30,-0.01,0.21,0.2,,23,0.23,0.026666667,,1

张磊,试验人2,0.22,0.19,0.29,0.32,0.29,0.10,0.10,0.29,0.01,0.22,0.203,,24,0.21,0.006666667,,2

,试验人3,0.20,0.20,0.26,0.31,0.28,0.11,0.12,0.29,0.00,0.21,0.198,,25,0.19,-0.013333333,,2

,平均值,0.21,0.2,0.283333333,0.31,0.283333333,0.103333333,0.106666667,0.293333333,0,0.213333333,0.200333333,,26,0.18,-0.023333333,,2

,极差,0.02,0.02,0.04,0.02,0.01,0.01,0.02,0.01,0.02,0.01,0.018,,27,0.21,0.006666667,,3

零件,平均值,0.271111111,0.203333333,0.326666667,0.251111111,0.242222222,0.116666667,0.133333333,0.171111111,0.022222222,0.271111111,0.200888889,,28,0.19,-0.013333333,,3

,极差,,,,,,,,,,,0.304444444,,29,0.2,-0.003333333,,3

极差平均值,0.015666667,,,XDiff,0.004333333,,,,,,系数,值,,31,0.35,0.023333333,,1

UCLx,0.216915889,0.216915889,,UCLR,0.040326,0.040326,1,10,,,D4,2.574,,32,0.34,0.013333333,,1

LCLx,0.184861889,0.184861889,,LCLR,0,0,,,,,D3,-,,33,0.35,0.023333333,,1

CLx,0.200888889,,,CLR,0.015666667,0.015666667,,,,,A2,1.023,,34,0.35,0.023333333,,2

注释：2次试验D4=3.27，3次试验D4=2.58。UCLR代表了单个极差的控制限。将那些超出控制限的点圈出，识别原因并纠正。使用与开始时相同的评价人及单位重复这些读数，或除去某些值并从保留的观察值重新获得平均值，重新计算极差平均值。,,,,,,,,,,,,,,35,0.36,0.033333333,,2

,,,,,,,,,,,,,,36,0.34,0.013333333,,2

量具重复性和再现性报告,,,,,,,,,,,,,,37,0.3,-0.026666667,,3

零件名称和检具名称：A2048854065,,,,,量具名称：百分表,,,,,日期：2011.6.15,,,,38,0.29,-0.036666667,,3

特性：Z,,,,,量具号：01,,,,,完成人：柴增慧,,,,39,0.26,-0.066666667,,3

规格：,,,,,量具类型：长度,,,,,,,,,41,0.21,-0.041111111,,1

,极差平均值=,0.015666667,,,XDiff=,0.004333333,,,,Rp=,0.304444444,,,42,0.22,-0.031111111,,1

重复性-设备变差（EV）：,,,,,,,,,,,,,,43,0.23,-0.021111111,,1

EV=,Rangeavg.×K1,,,,,,,,%EV=,100[EV/TV],,,,44,0.23,-0.021111111,,2

=,0.009255867,,,,K1=,0.5908,,,=,0.096178559,,,,45,0.22,-0.031111111,,2

,,,,,,,,,,,,,,46,0.22,-0.031111111,,2

再现性-评价人变差（AV）：,,,,,,,,,,,,,,47,0.3,0.048888889,,3

AV=,((XDiff×K2)^2-(EV^2/(nr)))^0.5,,,,,,,,%AV=,100[AV/TV],,,,48,0.32,0.068888889,,3

=,0.001510804,,,,,,,,=,0.015698903,,,,49,0.31,0.058888889,,3

n=零件数,r=试验数,,,,K2=,0.5231,,,,,,,,51,0.22,-0.022222222,,1

重复性和再现性（GRR）：,,,,,,,,,,,,,,52,0.23,-0.012222222,,1

GRR=,(EV^2+AV^2)^0.5,,,,,,,,%GRR=,100[GRR/TV],,,,53,0.22,-0.022222222,,1

=,0.009378358,,,,,,,,=,0.097451377,,,,54,0.21,-0.032222222,,2

,,,,,,,,,,,可接受,,,55,0.22,-0.022222222,,2

零件变差（PV）：,,,,,,,,,,,,,,56,0.23,-0.012222222,,2

PV=,Rp×K3,,,,,,,,%PV=,100[PV/TV],,,,57,0.28,0.037777778,,3

=,0.095778222,,,,K3=,0.3146,,,=,0.995240287,,,,58,0.29,0.047777778,,3

,,,,,,,,,,,,,,59,0.28,0.037777778,,3

总变差（TV）：,,,,,,,,,,,,,,61,0.11,-0.006666667,,1

TV=,(GRR^2+PV^2)^0.5,,,,,,,,ndc=,1.41(PV/GRR),,,,62,0.12,0.003333333,,1

=,0.096236279,,,,,,,,=,14.39988695,,,,63,0.12,0.003333333,,1

,,,,,,,,,~,14,可接受,,,64,0.12,0.003333333,,2

表中所用的有关理论和常数的资料参见MSA参考手册第三版,,,,,,,,,,,,,,65,0.14,0.023333333,,2

,,,,,,,,,,,,,,66,0.13,0.013333333,,2

附加处理,,,,,,,,,,,,,,67,0.1,-0.016666667,,3

n,d2,d2*,,估计标准偏差,,,,,,,,,,68,0.1,-0.016666667,,3

2,1.128,1.41,,标准偏差来源,,,估计值,,,,,,,69,0.11,-0.006666667,,3

3,1.693,1.906,,重复性,,,,σeHat=,0.00925379,,,,,71,0.1,-0.033333333,,1

4,20.59,2.237,,评价人影响,,,,σaHat=,0.002273522,,,,,72,0.11,-0.023333333,,1

5,2.236,2.477,,测量误差,,,,σmHat=,0.009528984,,,,,73,0.12,-0.013333333,,1

6,2.534,2.669,,样本之间,,,,σpHat=,0.095797497,,,,,74,0.19,0.056666667,,2

7,2.704,2.827,,,,,,,,,,,,75,0.18,0.046666667,,2

8,2.847,2.961,,信噪比,,,,10.05327508,,,,,,76,0.18,0.046666667,,2

9,2.97,3.076,,ndc,,,,14.17511786,~14,,,,,77,0.1,-0.033333333,,3

10,3.078,3.178,,Acceptability,,,,可接受,,,,,,78,0.1,-0.033333333,,3

,,,,,,,,,,,,,,79,0.12,-0.013333333,,3

,,,,,,,,,,,,,,81,0.11,-0.061111111,,1

,,,,,,,,,,,,,,82,0.12,-0.051111111,,1

,,,,,,,,,,,,,,83,0.1,-0.071111111,,1

,,,,,,,,,,,,,,84,0.12,-0.051111111,,2

,,,,,,,,,,,,,,85,0.11,-0.061111111,,2

,,,,,,,,,,,,,,86,0.1,-0.071111111,,2

,,,,,,,,,,,,,,87,0.3,0.128888889,,3

,,,,,,,,,,,,,,88,0.29,0.118888889,,3

,,,,,,,,,,,,,,89,0.29,0.118888889,,3

,,,,,,,,,,,,,,91,0.06,0.037777778,,1

,,,,,,,,,,,,,,92,0.07,0.047777778,,1

,,,,,,,,,,,,,,93,0.06,0.037777778,,1

,,,,,,,,,,,,,,94,0.01,-0.012222222,,2

,,,,,,,,,,,,,,95,0,-0.022222222,,2

,,,,,,,,,,,,,,96,0,-0.022222222,,2

,,,,,,,,,,,,,,97,-0.01,-0.032222222,,3

,,,,,,,,,,,,,,98,0.01,-0.012222222,,3

,,,,,,,,,,,,,,99,0,-0.022222222,,3

,,,,,,,,,,,,,,101,0.29,0.018888889,,1

,,,,,,,,,,,,,,102,0.28,0.008888889,,1

,,,,,,,,,,,,,,103,0.28,0.00