ANOVA Gage R&R Using Excel's Two-Way ANOVA Data Analysis Tool Add-In

If you don't have the Data Analysis Tool Add-in, install it by following these instructions:
• Statistical Analysis A...
Note: these steps are a bit tedious and understanding what's going on requires existing statistical background.
Pause video as needed to study formulas.
Data taken from AIAG MSA 4th Edition and results confirmed to match the AIAG manual and Minitab.
Steps:
1. Input Gage R&R Data in Table
2. Identify # of Operators, Parts, Runs, Alpha, and Tolerance
3. Run Data Analysis Tool for Two-Way ANOVA with Replication
4. Delete F, P-value, and F Crit values
5. Rename Sources of Variation and Add Equipment w/o Interaction
6. Calculate SS, df, MS, F, P Val, and Var Comp w/ and w/o interaction
7. Use P-value of Operator x Part to determine final Var Comp
8. Fill out Gage R&R Table