Minitab 14 vs. Excel .xls spreadsheet differences? MSA Manual 3rd Edition

J

justncredible

Attached is a excel GR&R and a mintab 14 GR&R. The data is the same, the numbers and NDC are diffrent making the excel sheet FAIL. I am a professed "noob" with MSA, so can maybe the more learned explain why they are not jiving?

Is the math right on the excel sheet, since I pray it is right in MT. I want to include the excel sheet to show the big PASS/FAIL since it most likley will not be viewed expert GR&R people.

Has anyone found a sheet that matches the math in minitab? Or has anyone ever checked the math on the sheets and in minitab?

Attachments

• mrminerwhy.xls
46 KB · Views: 461
• Book1OFGRR.xls
110.5 KB · Views: 473

Miner

Forum Moderator
The main reason for the difference is that the Excel spreadsheet is set up as a "Crossed" study, which is how 95% of MSA studies are designed. Crossed means that all operators test all parts repeatedly.

The Minitab analysis that you selected is a "Nested" design. This typically means that each operator tests a different set of parts. Minitab also has a "Crossed" option that you should use in most situations.

If you want Minitab to achieve identical results to your spreadsheet, use the "Crossed" option and the Xbar/Range method.

Be careful with the results of cells M44 and M45 in your spreadsheet. You will typically use the results of cell K42 (%GRR) OR M42 (P/T Ratio) to make a decision on the suitability of the gage, NOT the minimum of the two. The logic in cells M44 and M45 is flawed. You could add a toggle option to state whether to use %GRR OR P/T Ratio to make the decision and change the logic in cells M44/M45 accordingly. In a less common situation, you may need to use both, but the logic is still flawed for this situation.

Y

Yew Jin

By default, minitab chooses 6 instead of 5.15 as a multiplier factor to represent 99.73% coverage level. Most of the excel spreadsheet for GR&R is using 5.15 which represent convention 99% spread.

Miner

Forum Moderator

By default, minitab chooses 6 instead of 5.15 as a multiplier factor to represent 99.73% coverage level. Most of the excel spreadsheet for GR&R is using 5.15 which represent convention 99% spread.

Thanks Yew. I overlooked that possibility.

I just checked his spreadsheet and it does use the 3rd edition constants (i.e., 6 multiplier), so this is not the cause.

J

Jim Shelor

Attached is a excel GR&R and a mintab 14 GR&R. The data is the same, the numbers and NDC are diffrent making the excel sheet FAIL. I am a professed "noob" with MSA, so can maybe the more learned explain why they are not jiving?

Is the math right on the excel sheet, since I pray it is right in MT. I want to include the excel sheet to show the big PASS/FAIL since it most likley will not be viewed expert GR&R people.

Has anyone found a sheet that matches the math in minitab? Or has anyone ever checked the math on the sheets and in minitab?
You are using variations in your spreadsheet for calculating NDC. NDC is calculated using sigma, not variation.

Jim Shelor
PMP, SSBB

Excel based Gage R&R VS Minitab calculation Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
D Asterix when pasting a column of values from Excel into Minitab (V17) Using Minitab Software 5
V Looking for advice on Pooled Standard Deviation between Minitab and MS Excel Statistical Analysis Tools, Techniques and SPC 1
M 1 and 2-Sample Poisson Rate - Confidence Level - Minitab/Excel Statistical Analysis Tools, Techniques and SPC 5
M PCDMIS-Excel Data to Minitab for Analysis Using Minitab Software 2
F How to Calculate the unbiased Standard Deviation in Excel using Minitab Formula Capability, Accuracy and Stability - Processes, Machines, etc. 6
F Run Minitab Macro from Excel Using Minitab Software 3
C Minitab vs Excel 95% CI's (Confidence Intervals) Statistical Analysis Tools, Techniques and SPC 6
K How to setup DDEs in Minitab to link a project to an Excel workbook Quality Tools, Improvement and Analysis 2
Table of Capability Indices - Copy from Minitab to Excel Using Minitab Software 3
Calculation of c4 unbiasing constant - Capability results from Minitab in MS Excel Statistical Analysis Tools, Techniques and SPC 25
S Pulling Data In Real Time From Excel using Minitab 15 Using Minitab Software 2
I Minitab ANOVA Gage R&R Error (vs. EXCEL ANOVA GRR Calculation) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
V Minitab and Excel Giving Different Cpk Values for the same Data Using Minitab Software 12
R Cpk & Ppk and Differences between Minitab and an Excel Spreadsheet Results Statistical Analysis Tools, Techniques and SPC 4
B Gather and Analyze Production Scrap - MiniTab 16 vs. Excel Data Analysis Quality Assurance and Compliance Software Tools and Solutions 5
K Copy graph from Minitab to Excel! Using Minitab Software 1
M Exporting Minitab Data to Excel Excel .xls Spreadsheet Templates and Tools 5
S SPC monitoring software - Our customer recommended MINITAB (we use Excel) Quality Assurance and Compliance Software Tools and Solutions 3
S MiniTab vs. Excel: Difference in Degrees of Freedom Excel .xls Spreadsheet Templates and Tools 5
Minitab formulas regarding anova gage r&r Using Minitab Software 1
Minitab normality test and stats test for date vs time? Using Minitab Software 10
Minitab Coding Help Using Minitab Software 0
Minitab factorial design regression equation center point term Manufacturing and Related Processes 5
Acceptance sampling by variables - Do Minitab use one sided k only? Why? Statistical Analysis Tools, Techniques and SPC 0
Computer system validation approach for Minitab Statistical software Software Quality Assurance 11
Setting the Control limits on Minitab Using Minitab Software 4
Poisson regression using Minitab Statistical Analysis Tools, Techniques and SPC 3
Select the 1 Supplier based on the Parts Durability from 6 Supplier Samples using Minitab Using Minitab Software 11
One-factor and multiple-response Minitab optimization Using Minitab Software 2
Problem in Minitab - ERROR * Factor Voltage is highly correlated with other terms Using Minitab Software 10
Minitab 19 Anova or X bar # of distinct catagories Using Minitab Software 2
Pooled Standard Error - Minitab Statistical Analysis Tools, Techniques and SPC 0
Asterisk in DOE minitab software Using Minitab Software 23
Does anybody know how to get older versions of Minitab to work in Windows 10? Quality Tools, Improvement and Analysis 9
Minitab Capability of the Population (no sampling) Using Minitab Software 11
Minitab - Updating Graph with specific data points Using Minitab Software 2
Need help with analysing a survey on minitab Using Minitab Software 1
Minitab assistant: 1-Sample % Defective Test Using Minitab Software 1
Interesting Discussion Analysis of half normal distribution in minitab Using Minitab Software 11
Batch printing reports in Minitab Using Minitab Software 3
Minitab Type 1 Gage Study on True Position Question Measurement Uncertainty (MU) 1
Minitab GRR crossed Xbar and r method macro needed Using Minitab Software 9
Number of decimals in equation calculated by MiniTab Using Minitab Software 0
Acceptance p-value for linearity and bias analysis in minitab results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
How to change the display of optimization plot in Minitab 18 Using Minitab Software 2
M Minitab tool to evaluate PM (Preventive Maintenance) process Using Minitab Software 6
E Input to ANOVA 1-WAY - How can I perform this analysis in minitab? Using Minitab Software 2
N Tolerance Interval plots in Minitab Statistical Analysis Tools, Techniques and SPC 0
Including Repeats in DoE using Minitab Using Minitab Software 5