# Excel spreadsheet containing Gage R&R with Anova Method wanted

D

#### duane bacon

Re: An Excel spreadsheet containing GR&R with Anova Method wanted

I felt inspired and translated it anyway...

hope it´s useful !
Man, so close, to what I need, and yet I can' figure out how to use it...

#### Stijloor

Super Moderator
Re: An Excel spreadsheet containing GR&R with Anova Method wanted

Man, so close, to what I need, and yet I can't figure out how to use it...

What is your specific question? That would help our MSA experts to address your issue and perhaps guide you through the process.

Stijloor.

D

#### duane bacon

basicly, I am just trying to estimate the variance of the repeatablity and reproduciblity... I am trying to use the basic ANOVA eqns, I and I cannot figure it out how to proceed. the exp is 10 parts, 2 operators, 3 measurements each. and it is painful, my data is

op1op2part num12312315049505048512525251515151353505054525144951504850515484948484948652505052505075151515150508525049534850950515051484910474649464748

#### Stijloor

Super Moderator
basicly, I am just trying to estimate the variance of the repeatablity and reproduciblity... I am trying to use the basic ANOVA eqns, I and I cannot figure it out how to proceed. the exp is 10 parts, 2 operators, 3 measurements each. and it is painful, my data is

op1op2part num12312315049505048512525251515151353505054525144951504850515484948484948652505052505075151515150508525049534850950515051484910474649464748

Do you have a spreadsheet that you can attach?

Stijloor.

D

#### duane bacon

attached shows my attempts...
the examples in my books just don't seem to work..

#### Attachments

• ch 8 data for HW1.xlsx
16.2 KB · Views: 371
I

#### Ingo1966

Hello together,

Please find my attached Excel Spreadsheet which is calculating Gage R&R with ANOVA.
You can run several Experiment Conditions and adjust the Alpha level to remove the interaction Term Operator & Part.

Hope it helps

#### Attachments

• ANOVA GAGE_R_R.xls
137 KB · Views: 535
I

Good Luck Ingo

#### Attachments

• ANOVA GAGE_R_R_V3.xls
225 KB · Views: 428
R

#### runnerpg

Can this spread sheet be used for 2 operators, 5 parts checking 3 times each?

Thanks

I

#### Ingo1966

Hello

You need to download Version 5. (I did some Modification to cover flexible Test Condition)

Attached with Version 5 you can use it for every Situation.
The Excel Sheet will automaticly check the Number of Operator, Parts and Replications.

All Situations are validated with MiniTab.

If you have further Questions do not hesitate and good Luck

Ingo

#### Attachments

• ANOVA GAGE_R_R_V5.xls
225.5 KB · Views: 535
B

#### batar

I am also in need of help in my Gage R& R with Anova Method.
The Excel spreadsheet can someone tell me if it is for inches or millimeters? I need millimeters analysed.Please advise.
Thank you