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 the QI Macros to restack the data to match the Gage R&R input format.
  2. Put the data into the QI Macros Gage R&R template (C3:L5, C11:L13, C19::21).
  3. Enter the Specification tolerance (2) into cell B43, to get the following:

Compare to Ford:

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?

affordable

Affordable

  • 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