Gage R&R Study - Ford Validation Data

Validation of the QI Macros Gage R&R Template Using Ford Data

Ford has data for validating Gage R&R, Cp, Cpk, etc. 

We have included this data in the AIAG SPC sample data set that is installed with QI Macros. To access the sample data, click on QI Macros Help on the far right side of QI Macros menu. Next click Open QI Macros Sample Data to access the folder where all of the files are located.

QI Macros sample data

To Test the QI Macros Gage R&R Template for Excel

  1. Use QI Macros to re-stack the data to match the Gage R&R input format.
  2. Input the data into QI Macros Gage R&R template (C3:L5, C11:L13, C19:L21).
  3. excel gage r&r template with ford data

  4. Enter the Specification tolerance (2) into cell B45, to get the following:
  5. validate gage r&r template results

Compare to Ford Expected Results:

#
Gage R&R Calculation
Expected Result
1
Gage R&R as a percent of tolerance using the Average and Range Method
8.27
2
Gage R&R as a percent of study variation using the Average and Range Method
10.28
3
Gage R&R as a percent of tolerance using the ANOVA Method
8.23
4
Gage R&R as a percent of study variation using the ANOVA Method
9.74
5
Number of Distinct Categories (NDC)
15

QI Macros Match! Anova Method 
Using percent of tolerance (cell G70 = 8.23)
Using percent of variation (cell E70 = 9.74):

ANOVA method calculations using ford data

QI Macros Match! Average and Range
Using specification tolerance %R&R (cell C52 = 8.27)
Using part variation (cell B52 = 10.28) and 
NDC (cell F52 = 14).

Average and range method calculations using ford data

Ford Data Gage R&R Study with QI Macros


Why Choose QI Macros Gage R&R Software for Excel?

affordable

Affordable

  • Only $299 USD - less with quantity discounts
  • No annual fees
  • Free Technical Support

easy to use

Easy to Use

  • Works Right in Excel
  • Interprets Results for You
  • Accurate Results Without Worry

proven and trusted

Proven and Trusted

  • Compatible with AIAG 4th Ed.
  • 100,000 Users in 80 Countries
  • Five Star CNET Rating - Virus Free