Gage R&R - Ford Validation

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

Validation of the QI Macros using Ford Data

Ford has data for validating Gage R&R, Cp, Cpk, etc. Click Here to download.

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

To learn more watch this Gage R&R video using Ford Data

Order the Gage R&R Template Separately

Order the Gage R&R Template as part of the QI Macros SPC Software for Excel

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!

The QI Macros Gage R&R Templates are compatible with:

AIAG MSA 4th Edition

To get formulas and a fuller understanding, order the MSA reference from the AIAG.

Keyboard Wedges & Gage Interfaces

WedgeLink keyboard wedges for transferring gage data directly into Excel