Elsmar Cove Forum Header Graphic The Elsmar Cove Wiki Sitemap 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
NQA-USA
NQA-USA
Miner's MSA (Measurement Systems Analysis) Blog 
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

Wooden Line

Minitab ANOVA Gage R&R Error (vs. EXCEL ANOVA GRR Calculation)

Search the Elsmar Cove
Search Elsmar
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
  Post Number #1  
Old 28th September 2011, 03:10 AM
Ingo1966's Avatar
Ingo1966

 
 
Total Posts: 41
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, 253 views)
File Type: xls GRR DATAS for MINITAB INPUT.xls (23.5 KB, 175 views)

Sponsored Links
  Post Number #2  
Old 29th September 2011, 08:45 AM
Stijloor's Avatar
Stijloor

 
 
Total Posts: 14,702
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

  Post Number #3  
Old 3rd October 2011, 07:08 AM
Allattar

 
 
Total Posts: 234
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!
  Post Number #4  
Old 3rd October 2011, 11:20 AM
Ingo1966's Avatar
Ingo1966

 
 
Total Posts: 41
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
  Post Number #5  
Old 4th October 2011, 05:16 AM
Allattar

 
 
Total Posts: 234
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!
  Post Number #6  
Old 4th October 2011, 08:11 AM
Ingo1966's Avatar
Ingo1966

 
 
Total Posts: 41
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, 208 views)

Last edited by Ingo1966; 4th October 2011 at 08: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
p-Value(s) for Anova (Crossed) GRR (Gage R&R) Studies straetfeild Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5 21st October 2014 06:22 PM
GRR (Gage R&R) Nested Anova Method Example Rameshwar25 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 40 4th September 2014 01:02 PM
Minitab ANOVA Error Message - *ERROR* No data in column. apokalypsis Using Minitab Software 3 7th December 2011 08:12 PM
Gage R&R or Anova two way? Using Minitab ed1978 Using Minitab Software 1 14th October 2009 08:23 PM
Variables Gage R&R - Minitab v14 - F statistic Calculation - ANOVA - Methods validity tetnal Using Minitab Software 2 31st January 2005 02:16 PM



The time now is 10:23 AM. 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".