Hi everyone,
I wanted to validate my spreadsheet for the correctness of the GR&R analysis using two-way ANOVA. To do this, I entered my data into Minitab. It turned out that there were differences. At first I thought I had messed up something in the ANOVA table, but I put the same data into R and got the same results as in Excel.
After a little investigation, I concluded that there was a bug in the formulas in Minitab. When calculating the F statistic in Minitab, it divides by MS calculated for the interaction (
This does not generally affect the calculation of the GR&R coefficient (the F value for the interaction is calculated correctly, so decision about interaction significance is correct), but it can lead to incorrect conclusions about the significance of differences between parts and between operators.
Below I provide the calculations in R and in Minitab to show the differences. I will also attach the source file with the data so that you can verify that I am correct:
R results
Minitab Results
As you can see, the values in the F column in the Part and Operator rows are different in both results. However, if the value of F is determined by dividing the MS for the part by the MS for the interaction, the result is the same as in Minitab. The same for the operators. This is a bug.
I wanted to validate my spreadsheet for the correctness of the GR&R analysis using two-way ANOVA. To do this, I entered my data into Minitab. It turned out that there were differences. At first I thought I had messed up something in the ANOVA table, but I put the same data into R and got the same results as in Excel.
After a little investigation, I concluded that there was a bug in the formulas in Minitab. When calculating the F statistic in Minitab, it divides by MS calculated for the interaction (
Operator*Part row in Minitab), when it should be dividing by the variance of residuals (Repeatibility row in Minitab).This does not generally affect the calculation of the GR&R coefficient (the F value for the interaction is calculated correctly, so decision about interaction significance is correct), but it can lead to incorrect conclusions about the significance of differences between parts and between operators.
Below I provide the calculations in R and in Minitab to show the differences. I will also attach the source file with the data so that you can verify that I am correct:
R results
Code:
Df Sum Sq Mean Sq F value Pr(>F)
Operator 2 0.011 0.0053 8.856 0.000427 ***
Part 9 6.376 0.7084 1178.819 < 2e-16 ***
Operator*Part 18 0.010 0.0006 0.955 0.520223
Residuals 60 0.036 0.0006
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1
Minitab Results
As you can see, the values in the F column in the Part and Operator rows are different in both results. However, if the value of F is determined by dividing the MS for the part by the MS for the interaction, the result is the same as in Minitab. The same for the operators. This is a bug.