Performing Crossed ANOVA Gage R&R Using Excel 365

The course presents 7 short videos with supporting downloadable Excel files to teach you the statistics, formulas, and concepts needed to understand how to perform and evaluate a Crossed ANOVA Gage R&R study which is required as part of the PPAP or many Quality Management System processes.

• What is Gage R&R?

• When to do Gage R&R

• When to Repeat Gage R&R

• Types of Gage R&R

• Methods (Xbar – R vs. ANOVA)

• Sum Function (Σ)

• Population vs. Sample

• Average/Mean (μ or x̅)

• Standard Deviation (σ or s)

• Variance

• Normal Distribution

• Galton Board Demonstration

• Normal Distribution Probability Density Function (PDF)

• Normal Distribution PDF Area Under the Curve

• Normal Distribution PDF Probability

• 68–95–99.7 rule

• F-Distribution Introduction

• F-Distribution Probability Density Function (PDF)

• F-Test

• One-Way ANOVA

• Null Hypothesis

• Calculate F-Statistic and P-Value

• One Way ANOVA Using Excel

Two-Way ANOVA Gage R&R Study:

1. Collect data with multiple parts, operators, and replicates (retests)

2. Determine Alpha needed to ignore interaction term and Tolerance

3. Calculate Sum of Squares (SS) and Degrees of Freedom (df) for each group

4. Calculate Mean Squares for each group, (MS) = SS/df

5. Calculate F-Statistics, and P-values then Evaluate Significance of interaction

6. Calculate Variance Components, and Gage R&R Values

7. How to use the built in Two-Way ANOVA data analysis tool.

Interpreting Gage R&R Table:

• Variance Components

• % Contribution

• StdDev(SD)

• Study Var (6*SD)

• %Study Var (%SV)

• %Tol (SV/Tol)

• Number of Distinct Categories (ndc)

• Heat Map

• VarComp Bar Chart

• Data by Parts Dot Plot

• Range Chart

• X-Bar Chart

• Boxplot by Operator

• Parts x Oper Line Plot

• How to Improve Results

Rating Distribution

• 1 stars: 0 votes
• 2 stars: 0 votes
• 3 stars: 0 votes
• 4 stars: 0 votes
• 5 stars: 1 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!