The Elsmar Cove Wiki More Free Files The Elsmar Cove Forums Discussion Thread Index Post Attachments Listing Failure Modes Services and Solutions to Problems Elsmar cove Forums Main Page Elsmar Cove Home Page
Go Back   The Elsmar Cove Forum > ISO (International Organization for Standardization) Standards > ISO 17025 - General Metrology, Measurement Device, Calibration and Test Laboratories > Gage R&R (GR&R) and MSA (Measurement Systems Analysis)
Forum Username

Search the Elsmar Cove
Custom Search
Monitor the Elsmar Forum
Follow Marc & Elsmar
Elsmar Cove Forum RSS Feed  Marc Smith's Google+ Page  Marc Smith's Linked In Page   Marc Smith's Elsmar Cove YouTube Page  Marc Smith's Facebook Page  Elsmar Cove Twitter Feed
Elsmar Cove Groups
Elsmar Cove Google+ Group  Elsmar Cove LinkedIn Group  Elsmar Cove Facebook Group
Donate and $ Contributor Forum Access

Courtesy Quick Links

Links that Elsmar Cove visitors will find useful in your quest for knowledge:

Howard's
International Quality Services
Marcelo Antunes'
SQR Consulting
Bob Doering's
Correct SPC - Precision Machining

NIST's Engineering Statistics Handbook
IRCA - International Register of Certified Auditors
SAE - Society of Automotive Engineers
Quality Digest Portal
IEST - Institute of Environmental Sciences and Technology
ASQ - American Society for Quality

Related Topic Tags
anova (analysis of variance), gage r&r (repeatability and reproducibility), microsoft excel .xls .xlsx spreadsheet, minitab (statistical analysis software), formula (mathematics/statistics)
Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  #1  
Old 28th September 2011, 02:10 AM
Ingo1966's Avatar
Ingo1966 Ingo1966 is offline
Involved in Discussions

 
Registration Date: Mar 2008
Location: Germany
 
Posts: 41
Thanks Given to Others: 20
Thanked 37 Times in 20 Posts
Blog Entries: 1
Karma Power: 31
Karma: 175
Ingo1966 is appreciated, and has over 100 Karma points.Ingo1966 is appreciated, and has over 100 Karma points.
Exclamation Minitab ANOVA Gage R&R Error (vs. EXCEL ANOVA GRR Calculation)

MiniTab includes the insignificant interaction Term Operator x Part in the final calculation of %GAGE R&R.

Attached I have an EXCEL ANOVA GRR Calculation for the same data's which I put into Minitab.

If you stay with alpha 0.25 to remove the insignificant interaction term Operator x Part the Results differ from Minitab. (even though MiniTAb Session Window stated to remove the Interaction Term also at alpha 0.25)

If you manipulate alpha to 1 in my Excel Sheet to INCLUDE the insignificant OPxPart Interaction --> everything is fine.

But this is wrong ! Ok it differs not much but unfortunately these Values are used to callibrate the Outcome from other Statistical Software.

And therefore some People who trust MiniTab would say my EXCEL Calculation is somehow wrong.
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
File Type: xls GAGE_R_R_VERIFICATION TEST_ CALLIBRIATION DATA.xls (144.0 KB, 242 views)
File Type: xls GRR DATAS for MINITAB INPUT.xls (23.5 KB, 171 views)

Sponsored Links
  #2  
Old 29th September 2011, 07:45 AM
Stijloor's Avatar
Stijloor Stijloor is offline
Super Moderator

 
Registration Date: May 2003
Location: Charlotte, North Carolina.
 
Posts: 14,579
Thanks Given to Others: 3,197
Thanked 4,538 Times in 3,215 Posts
Karma Power: 1554
Karma: 25303
Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.
Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.
Re: Minitab ANOVA Gage R&R Error (vs. EXCEL ANOVA GRR Calculation)

Quote:
In Reply to Parent Post by Ingo1966 View Post

MiniTab includes the insignificant interaction Term Operator x Part in the final calculation of %GAGE R&R.

Attached I have an EXCEL ANOVA GRR Calculation for the same data's which I put into Minitab.

If you stay with alpha 0.25 to remove the insignificant interaction term Operator x Part the Results differ from Minitab. (even though MiniTAb Session Window stated to remove the Interaction Term also at alpha 0.25)

If you manipulate alpha to 1 in my Excel Sheet to INCLUDE the insignificant OPxPart Interaction --> everything is fine.

But this is wrong ! Ok it differs not much but unfortunately these Values are used to callibrate the Outcome from other Statistical Software.

And therefore some People who trust MiniTab would say my EXCEL Calculation is somehow wrong.
Comments anyone?

Thank you!!

Stijloor.
Thanks to Stijloor for your informative Post and/or Attachment!
Sponsored Links

  #3  
Old 3rd October 2011, 06:08 AM
Allattar Allattar is offline
Appreciated Member

 
Registration Date: Jan 2008
Location: UK
 
Posts: 234
Thanks Given to Others: 15
Thanked 171 Times in 111 Posts
Karma Power: 57
Karma: 3390
Allattar is appreciated, and has over 1700 Karma points.
Allattar is appreciated, and has over 1700 Karma points.Allattar is appreciated, and has over 1700 Karma points.Allattar is appreciated, and has over 1700 Karma points.Allattar is appreciated, and has over 1700 Karma points.
Re: Minitab ANOVA Gage R&R Error (vs. EXCEL ANOVA GRR Calculation)

It looks like you are using the EV calculation from the full model with the interaction. Even though you remove the interaction.

Note if you remove the interaction, the Sum of squares for the interaction must go to the error term, must go into equipment variation.

You are dividing g22 by h22. G22 is the EV found with the interaction included.

As far as I can see including or removing the interaction in your excewl sheet does not change the SS in the EV.
Thank You to Allattar for your informative Post and/or Attachment!
  #4  
Old 3rd October 2011, 10:20 AM
Ingo1966's Avatar
Ingo1966 Ingo1966 is offline
Involved in Discussions

 
Registration Date: Mar 2008
Location: Germany
 
Posts: 41
Thanks Given to Others: 20
Thanked 37 Times in 20 Posts
Blog Entries: 1
Karma Power: 31
Karma: 175
Ingo1966 is appreciated, and has over 100 Karma points.Ingo1966 is appreciated, and has over 100 Karma points.
Re: Minitab ANOVA Gage R&R Error (vs. EXCEL ANOVA GRR Calculation)

Thankyou for your comments, you are right.

My Excel sheet is not very clearly you will find the modified SS for EV including the ERROR TERM in Cell C22

My Concern is MiniTab's Calculation why it comes up with different results
  #5  
Old 4th October 2011, 04:16 AM
Allattar Allattar is offline
Appreciated Member

 
Registration Date: Jan 2008
Location: UK
 
Posts: 234
Thanks Given to Others: 15
Thanked 171 Times in 111 Posts
Karma Power: 57
Karma: 3390
Allattar is appreciated, and has over 1700 Karma points.
Allattar is appreciated, and has over 1700 Karma points.Allattar is appreciated, and has over 1700 Karma points.Allattar is appreciated, and has over 1700 Karma points.Allattar is appreciated, and has over 1700 Karma points.
Re: Minitab ANOVA Gage R&R Error (vs. EXCEL ANOVA GRR Calculation)

I admit it is difficult following what the excel sheet is doing, but I think I may have traced it back.

The reproducibility estimates in your worksheet are different to Minitab, and hence the different figures.

Your calculation is MS(operator)/ (Parts*Replicates)

Minitab calculation

MS(Operator) - MS(repeatability) / (Parts * Replicates)
Thanks to Allattar for your informative Post and/or Attachment!
  #6  
Old 4th October 2011, 07:11 AM
Ingo1966's Avatar
Ingo1966 Ingo1966 is offline
Involved in Discussions

 
Registration Date: Mar 2008
Location: Germany
 
Posts: 41
Thanks Given to Others: 20
Thanked 37 Times in 20 Posts
Blog Entries: 1
Karma Power: 31
Karma: 175
Ingo1966 is appreciated, and has over 100 Karma points.Ingo1966 is appreciated, and has over 100 Karma points.
Re: Minitab ANOVA Gage R&R Error (vs. EXCEL ANOVA GRR Calculation)

Thankyou Allatar,

that was the point !
I was wrong, I have corrected it and than it fits with MiniTab.

I have to consult AIAG MSA 4th Appendix A again.

Dear Elsmar Forum:
"I am sorry for confusion"
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
File Type: xls GAGE_R_R_VERIFICATION TEST_ CORRECTED VERSION.xls (143.5 KB, 206 views)

Last edited by Ingo1966; 4th October 2011 at 07:24 AM.
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Forum > ISO (International Organization for Standardization) Standards > ISO 17025 - General Metrology, Measurement Device, Calibration and Test Laboratories > Gage R&R (GR&R) and MSA (Measurement Systems Analysis)

Do you find this discussion thread helpful and informational?


Bookmarks


Visitors Currently Viewing this Thread: 1 (0 Registered Visitors (Members) and 1 Unregistered Guest Visitors)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Rate Thread Content:

Forum Posting Settings
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
GRR (Gage R&R) Nested Anova Method Example Rameshwar25 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 40 4th September 2014 12:02 PM
p-Value(s) for Anova (Crossed) GRR (Gage R&R) Studies straetfeild Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3 5th May 2013 01:49 PM
Minitab ANOVA Error Message - *ERROR* No data in column. apokalypsis Using Minitab Software 3 7th December 2011 07:12 PM
Gage R&R or Anova two way? Using Minitab ed1978 Using Minitab Software 1 14th October 2009 07:23 PM
Variables Gage R&R - Minitab v14 - F statistic Calculation - ANOVA - Methods validity tetnal Using Minitab Software 2 31st January 2005 01:16 PM



The time now is 09:52 PM. All times are GMT -4.
Your time zone can be changed in your UserCP --> Options.


   


Marc Timothy Smith - Elsmar.com
8466 LeSourdsville-West Chester Road, Olde West Chester, Ohio 45069-1929
513 341-6272
NOTE: This forum uses "cookies".