Attribute Gage R&R Study in Excel

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

Perform an Attribute Gage R&R Study when the measurement value has only two possible results: go/no go, pass/fail, etc.

This differs from a variables measurement system when you can have any number of possible results.

To perform an Attribute Gage R&R Study:

1. Determine the Upper and Lower Spec Limits. Enter these in cells N3:O3 of the QI Macros template.
2. Select 10 parts and measure them accurately to get a reference value for each. Enter the reference values in column L.
   Important: The 10 parts must have an actual reference value spanning unacceptable low to unacceptable high.
3. Have 3 appraisers accept/reject 10+ parts with at least three trials.
4. Enter pass/fail in the QI Macros Attribute Gage Study template columns B-J. 1 = pass (the value is between the spec limits) and 0 = Fail (value is outside of the spec limits).
5. Evaluate the results

QI Macros Attribute Gage Study Input Area

QI Macros Attribute Gage R&R Study Results

To learn more watch this Attribute Gage R&R video

Here is a list of all of the worksheets included in the QI Macros Gage R&R template for Excel:

• Instructions Sheet - provides instructions for each template
• Gage R&R Study - includes the Average and Range Method and ANOVA Method
• Range Method - Provides quick approximation of overall measurement variability.
• Bias - calculates the "bias" of your gage, using a "target" or "reference" value that you input.
• Linearity - calculates whether a gage over reads or under reads across a range of different sized parts.
  
• Attribute Gage Worksheet - for Pass/Fail gages
• Analytic Attribute Method - to assess the amount of repeatability and bias of a measurement system

Gage R&R Training Resources:

Gage R&R Video

How to Perform a Gage R&R Study

If My Parts Are So Good, Why Are My Gage R&R Results So Bad?

Order the Gage R&R Template Separately

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

Try QI Macros
FREE
For 30-Days

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