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. 

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

  1. Use QI Macros to restack 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::21).
    excel gage r&r template with ford data
  3. Enter the Specification tolerance (2) into cell B45, to get the following:
    validate gage r&r template results

Compare to Ford Expected Results:

gage rr expected results

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

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).

Ford Data Gage R&R Study with QI Macros

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



  • Only $279 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