GRR表格MSA第四版完整版

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

測(cè)量系統(tǒng)分析MSAGR&R---數(shù)據(jù)記錄表DataWorksheet,,,,,,,,,,,,,,,,

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

,,,,,,,,,,,報(bào)告編號(hào)ReportNO.,,,,,

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

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

"量具名稱

EquipmentName",,,,,,"產(chǎn)品類型

Description",,,,"測(cè)量人員

OperatorＡ",,,,"測(cè)試日期

TestTate",,

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

"量具編號(hào)

EquipmentNO.",,,,,,"基件編號(hào)

P/N",,,,"測(cè)量人員

OperatorＢ",,,,"平價(jià)人數(shù)

Appraisers",,3

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

"參數(shù)規(guī)格

Dimension",,,,,,"規(guī)格上限

USL",,,,"測(cè)量人員

OperatorＣ",,,,"試驗(yàn)次數(shù)

Trials",,3

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

"單位

Unit",,,,MM,,"規(guī)格下限

LSL",,,"過程變差/過程能力

ProcessVariation(σ/PP)",,,,,"樣品數(shù)

Samples",,10

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

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

分析時(shí)機(jī)AnalyticalOccasion,,,,,,,,,,,,,,,,

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

零件編號(hào)PartsNO.,,,,1,2,3,4,5,6,7,8,9,10,Total,平均值A(chǔ)verage,

1.,A,,1,0.29,-0.56,1.34,0.47,-0.8,0.02,0.59,-0.31,2.26,-1.36,1.94,0.194000,

2.,,,2,0.41,-0.68,1.17,0.5,-0.92,-0.11,0.75,-0.2,1.99,-1.25,1.66,0.166000,

3.,,,3,0.64,-0.58,1.27,0.64,-0.84,-0.21,0.66,-0.17,2.01,-1.31,2.11,0.211000,

4.,,,均值Mean,0.44667,-0.60667,1.26000,0.53667,-0.85333,-0.10000,0.66667,-0.22667,2.08667,-1.30667,,,0.190333

,,,SumA,1.34,-1.82,3.78,1.61,-2.56,-0.3,2,-0.68,6.26,-3.92,5.7100,,

5.,,,極差Range,0.35,0.12,0.17,0.17,0.12,0.23,0.16,0.14,0.27,0.11,,,0.184000

6.,B,,1,0.08,-0.47,1.19,0.01,-0.56,-0.2,0.47,-0.63,1.8,-1.68,0.01,0.001000,

7.,,,2,0.25,-1.22,0.94,1.03,-1.2,0.22,0.55,0.08,2.12,-1.62,11.304,0.115000,

8.,,,3,0.07,-0.68,1.34,0.2,-1.28,0.06,0.83,-0.34,2.19,-1.5,0.89,0.089000,

9.,,,均值Mean,0.13333,-0.79000,1.15667,0.41333,-1.01333,0.02667,0.61667,-0.29667,2.03667,-1.60000,,,0.068333

,,,SumB,0.4,-2.37,3.47,1.24,-3.04,0.08,1.85,-0.89,6.11,-4.8,2.0500,,

10.,,,極差Range,0.18,0.75,0.4,1.02,0.72,0.42,0.36,0.71,0.39,0.18,,,0.513000

11.,C,,1,0.04,-1.38,0.88,0.14,-1.46,-0.29,0.02,-0.46,1.77,-1.49,-2.23,-0.223000,

12.,,,2,-0.11,-1.13,1.09,0.2,-1.07,-0.67,0.01,-0.56,1.45,-1.77,-2.56,-0.256000,

13.,,,3,-0.15,-0.96,0.67,0.11,-1.45,-0.49,0.21,-0.49,1.87,-2.16,-2.84,-0.284000,

14.,,,均值Mean,-0.07333,-1.15667,0.88000,0.15000,-1.32667,-0.48333,0.08000,-0.50333,1.69667,-1.80667,,,-0.254333

,,,SumC,-0.22,-3.47,2.64,0.45,-3.98,-1.45,0.24,-1.51,5.09,-5.42,-7.63,,

15.,,,極差Range,0.1900,0.4200,0.4200,0.0900,0.3900,0.3800,0.2000,0.1000,0.4200,0.6700,,,0.328000

"零件均值

PartsMean",,,,0.168889,-0.851111,1.098889,0.366667,-1.064444,-0.185556,0.454444,-0.342222,1.940000,-1.571111,,,0.001444

Total,,,,1.520000,-7.660000,9.890000,3.300000,-9.580000,-1.670000,4.090000,-3.080000,17.460000,-14.140000,0.13,,3.511111

,,,,,,,,0.341667,,,,試驗(yàn)次數(shù)Trials,,,2,3

,,,,,,,,0.444667,,,,,,D4,3.267,2.575

,,,,,,0.350969,,,,,0.879792,,,D3,0,0

,,,,,,-0.348081,,,,,0.000000,,,A2,1.88,1.023

"注:當(dāng)分析結(jié)果超出要求后，利用均值極差圖分析原因Whenanalysisresultisoutofspec,needanalysetherootcausebymeanandrangechart。",,,,,,,,,,,,,,,,

"均值圖

meanchart",,,,,,,,,,,,,,,,

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

,,,,1,2,3,4,5,6,7,8,9,10,,,

,,,UCLx,0.3510,0.3510,0.3510,0.3510,0.3510,0.3510,0.3510,0.3510,0.3510,0.3510,,,

,,,LCLx,-0.3481,-0.3481,-0.3481,-0.3481,-0.3481,-0.3481,-0.3481,-0.3481,-0.3481,-0.3481,,,

,,,UCLR,0.8798,0.8798,0.8798,0.8798,0.8798,0.8798,0.8798,0.8798,0.8798,0.8798,,,

,,,LCLR,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,,,

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

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

,,,,公差：,,,,6σ,,,pp,變差,,,,

,,,,PV,1.104596,,,PV,1.104596,,1.104596,PV,1.104596,,,

,,,,TV,0.000000,,,TV,0.000000,,#DIV/0!,TV,1.146135,,,基于公差baseonpartsspec

,,%EV,,,#DIV/0!,,,,#DIV/0!,,#DIV/0!,,17.61%,,,基于零件變差baseonpartsvariation

,,%AV,,,#DIV/0!,,,,#DIV/0!,,#DIV/0!,,20.04%,,,基于過程變差baseonprocessvariation

,,%RR,,,#DIV/0!,,,,#DIV/0!,,#DIV/0!,,26.68%,,,基于過程能力BaseonprocessPP

,,%PV,,,#DIV/0!,,,,#DIV/0!,,#DIV/0!,,96.38%,,,公式AFormulaA

,,,,ndc,5.093692473,,,,,,,,,,,公式BFormulaB

,,,,X^2/nkr,0.0001878,,sumSQ(sum(men))/nr,,,3.1674500,SUMSQ(sum(1-10part))/kr,,,88.3621222,,

"極差圖

Rangechart",,SUMSQ(sum(men-part))/r,,,,91.8883667,,sumSQ(all),,94.6473000,,,,n=partk=menr=time,,

,,,ANOVATableWithOperator*PartInteraction,,,,,,,ANOVATableWithoutOperator*PartInteraction,,,,,,

,,,Source,,DF,SS,MS,F,P,Source,,DF,SS,MS,F,P

,,,Parts,,9,88.36193,9.81799,492.29142,0.00000,Parts,,9,88.36193,9.81799,245.61391,0.00000

,,,Operators,,2,3.16726,1.58363,79.40605,0.00000,Operators,,2,3.16726,1.58363,39.61725,0.00000

,,,Operators*Part,,18,0.35898,0.01994,0.43372,0.97411,,,,,,,

,,,Repeatability,,60,2.75893,0.04598,,,Repeatability,,78,3.11792,0.03997,,

,,,Total,,89,94.64711,,,,Total,,89,94.64711,,,

,,,GaugeR&RWithOperator*PartInteraction,,,,,,,GaugeR&RWithoutOperator*PartInteraction,,,,,,

,,,Source,,VarComp,Stdev,%Contribution,%TV,%Tolerance,Source,,VarComp,Stdev,%Contribution,%TV,%Tolerance

,,,TotalGaugeR&R,,0.09811,0.31322,8.27%,28.75%,#DIV/0!,TotalGaugeR&R,,0.09143,0.30237,7.76%,27.86%,#DIV/0!

,,,Repeatability,,0.04598,0.21443,3.87%,19.68%,#DIV/0!,Repeatability,,0.03997,0.19993,3.39%,18.42%,#DIV/0!

,,,Reproducibility,,0.05212,0.22830,4.39%,20.96%,#DIV/0!,Reproducibility,,0.05146,0.22684,4.37%,20.90%,#DIV/0!

,,,Operator,,0.05212,0.22830,4.39%,20.96%,#DIV/0!,Operator,,0.05146,0.22684,4.37%,20.90%,#DIV/0!

,,,Operators*Part,,0.00000,0.00000,0.00%,0.00%,#DIV/0!,,,,,,,

,,,Part-To-Part,,1.08867,1.04339,91.73%,95.78%,#DIV/0!,Part-To-Part,,1.08645,1.04233,92.24%,96.04%,#DIV/0!

,,,TotalVariation,,1.18678,1.08939,100.00%,100.00%,#DIV/0!,TotalVariation,,1.17788,1.08530,100.00%,100.00%,#DIV/0!

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

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

測(cè)量系統(tǒng)分析MSAGR&R---均值極差法Averageandmethod,,,,,,,,,,,,,,,,

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

,,,,,,,,,,,報(bào)告編號(hào)ReportNO.,,,,,

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

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

"量具名稱

Equipment",,,,,,"產(chǎn)品類型

Description",,,,"測(cè)量人員

OperatorＡ",,,,,"測(cè)試日期

TestTate",1899/12/31

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

"量具編號(hào)

EquipmentNO.",,,,,,"基件編號(hào)

PartNO.",,,,"測(cè)量人員

OperatorＢ",,,,,"平價(jià)人數(shù)

Appraisers",3

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

"參數(shù)規(guī)格

Specification",,,,,,"規(guī)格上限

Upperlimit",,,,"測(cè)量人員

OperatorＣ",,,,,"試驗(yàn)次數(shù)

Trials",3

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

"測(cè)量單位

Unit",,,,MM,,"規(guī)格下限

LowerLimit",,,"過程變差/過程能力

ProcessVariation(σ/PP)",,,,,,"樣品數(shù)

Samples",10

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

Datasheet：,,,,,0.341667,,,0.444667,,,3.511111,,,,,

,,,,,,,,,,,分析方式Analysismode,基于零件變差baseonpartsvariation,,,,

,測(cè)量系統(tǒng)分析MSA,,,,,,,,,,%總變差Totalvariation（TV）,,,,,

,重復(fù)性Repeatability－設(shè)備變差EquipmentVariation(EV),,,,,,,,,,,,,,,

,,,,,,,,,,,,=,17.61%,,,

,=,0.201857,,,,,,,"試驗(yàn)次數(shù)

Trials",K1,,,,,,

,,,,,,,,,2,0.8862,,,,,,

,,,,,,,,,3,0.5908,,,,,,

,再現(xiàn)性Reproducibility－評(píng)價(jià)人變差A(yù)ppraiserVariation(AV),,,,,,,,,,,,,,,

,,,,,,,,,,,,=,20.04%,,,

,=,0.229667,#DIV/0!,#DIV/0!,,,,,"評(píng)價(jià)人數(shù)

Appraisers",K2,,,,,,

,,,,,,,,,2,0.7071,,,,,,

,,,,,,,,,3,0.5231,,,,,,

,重復(fù)性和再現(xiàn)性RepeatabilityandReproducibility(R&R),,,,,,,,,,,,,,,

,,,,,,,,,"零件數(shù)量

PartQTY",K3,,=,26.68%,,,

,=,0.305766,,,,,,,3,0.5231,,,,,,

,,,,,,,,,4,0.4467,,,,,,

,,,,,,,,,5,0.4043,,,,,,

,零件變差PartsVariation(PV),,,,,,,,6,0.3742,,,,,,

,,,,,,公式AFormulaA,,,7,0.3534,,=,96.38%,,,

,=,1.104596,,,,,,,8,0.3375,,,,,,

,,,,,,,,,9,0.3249,,,,,,

,,,,,,,,,10,0.3146,,,,,,

,總變差TotalVariation(TV),,,,,,,,,,有效分辨率AvailabilityResolution(NDC)=1.41*（PV/R&R）,,,,,

,,,,,,,基于零件變差Baseonpartsvariation,,,,,=,5,,,

,=,1.146135,,,,,基于過程變差Baseonprocessvariation,,,,,,,,,

,,,,,,,基于零件公差Baseonpartsspec,,,,,,,,,

,,,,,,,基于過程能力BaseonprocessPP,,,,,,,,,

,判定標(biāo)準(zhǔn)DecideCriterion,,,,,,,,,,,,,,,

1)

0%<%R&R<10%：量測(cè)系統(tǒng)狀況良好Excellent；,,,,,,,,,,,判定Decide,,可接收Accepted,,,

10%≤%R&R≤30%：量測(cè)系統(tǒng)狀況可以接收，但需改進(jìn)Acceptedbutneedimprovement；,,,,,,,,,,,,,,,,

30%<%R&R<100%：量測(cè)系統(tǒng)必須改進(jìn)Rejectedandmustbeimproved。,,,,,,,,,,,,,,,,

2)數(shù)據(jù)分級(jí)數(shù)NDC經(jīng)四舍五入取整后，必須大于或等于5TheNDCistruncatedtotheintegerandoughttobegreaterthanorequalto5。,,,,,,,,,,,,,,,,

"分析評(píng)價(jià)措施

Analysisandaction",,,,,,,,,,,,,,,,

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

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

,,分析人Analyst,,,,,日期Date,,,,,,,,,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

,,,Operator,,#REF!,#REF!,#REF!,,#REF!,,,,,,,

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

,,,Part-To-Part,,#REF!,#REF!,#REF!,,#REF!,,,,,,,

,,,TotalVariation,,#REF!,#REF!,#REF!,,#REF!,,,,,,,

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

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

測(cè)量系統(tǒng)分析MSAGR&R---變差數(shù)分析法ANOVAmethod,,,,,,,,,,,,,,,,

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

,,,,,,,,,,,,報(bào)告編號(hào)ReportNO.,,,,

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

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

"量具名稱

Equipment",,,,,,"產(chǎn)品類型

Description",,,,"測(cè)量人員

OperatorＡ",,,,,"測(cè)試日期

TestTate",1899/12/31

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

"量具編號(hào)

EquipmentNO.",,,,,,"基件編號(hào)

PartNO.",,,,"測(cè)量人員

OperatorＢ",,,,,"平價(jià)人數(shù)

Appraisers",3

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

"參數(shù)規(guī)格

Specification",,,,,,"規(guī)格上限

Upperlimit",,,,"測(cè)量人員

OperatorＣ",,,,,"試驗(yàn)次數(shù)

Trials",3

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

"測(cè)量單位

Unit",,,,MM,,"規(guī)格下限

LowerLimit",,,"過程變差

ProcessVariation(6σ)",,,,,,"樣品數(shù)

Samples",10

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

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

,"方差分析表格

ANOVATable",,,不包含without,操作員和零件的相互作用Operator*PartInteraction,,,,,,,,,,,

,"變差來源

Source",,,,"自由DF

Degreeoffreedom",,"平方的總和SS

Sumofsquares",,"平均平方MS

Meansquare",,"F-比率

F-ratio",,有效分辨率AvailabilityResolution(NDC),,,

,零件Parts,,,,9,,88.3619,,9.8180,,245.6139,,,,,

,評(píng)價(jià)者Operators,,,,2,,3.1673,,1.5836,,39.6172,,,,,

,評(píng)價(jià)者和零件Operators*Part,,,,0,,0.0000,,0.0000,,0.0000,,,,,

,設(shè)備Equipment,,,,78,,3.1179,,0.0400,,,,4.86052,≈4,,

,匯總Total,,,,89,,94.6471,,,,,,,,,

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

,"變差來源

Source",,,,"變差估計(jì)值

Estimateofvaiance",,"標(biāo)準(zhǔn)偏差

Stdev",,%貢獻(xiàn)率Contribution,,%總變差TV,,%公差Tolerance,,,

,系統(tǒng)TotalGaugeR&R,,,,0.0914,,0.3024,,7.76%,,27.86%,,#DIV/0!,,,

,重復(fù)性Repeatability,,,,0.0400,,0.1999,,3.39%,,18.42%,,#DIV/0!,,,

,再現(xiàn)性Reproducibility,,,,0.0515,,0.2268,,4.37%,,20.90%,,#DIV/0!,,,

,評(píng)價(jià)者Operator,,,,0.0515,,0.2268,,4.37%,,20.90%,,#DIV/0!,,,

,相互作用InteractionINT=0,,,,0,,0,,0,,0,,0,