Home » Gage R&R » Attribute Gage R&R

When to Perform an Attribute Gage R&R Study:

• Perform an Attribute Gage R&R Study when the measurement value has a limited number of possibilities.
• This differs from a variables measurement system when you can have any number of possible results.
• The most common example is a go/no go, pass/fail, gage that only provides two results.

Step by Step Instructions for Using QI Macros Attribute Gage R&R Template

1. Open QI Macros Gage R&R Template by clicking on QI Macros menu, then DOE Gage R&R FMEA and select Gage R&R.




2. Click on the Attribute Gage Worksheet to open the Attribute Gage Study Template.
   
   
   
3. Input the Upper and Lower Spec Limits in cells N3:O3 of QI Macros template.



Code: This section indicates whether your Ref Value is within your Spec Limits (+) or outside of your Spec Limits (-). If you receive an (X), this means your Ref Value falls within the "Gray Zone."

%R&R: This is the calculated value that is provided after you have run a Gage R&R Study
(NOTE: Value is provided upon completion of a Gage R&R MSA 4th, Gage R&R 30 Parts, or Type 3 Gage R&R Study).

Under 10%: Your measurement system is generally considered to be acceptable.
10%-29.9%: Your measurement system MAY be thought of as acceptable.
30% or Greater: Your measurement system is NOT considered acceptable.

Gray Zone: This value is informed by the %R&R value and provides you with the "zone" (above or below your spec limits) of where "Bad Parts" can potentially be mistaken as "Good Parts" and vice versa.
The above example's Gray Zone would be any Ref Value between 0.42625 and 0.450 (LSL - Grazy Zone), along with 0.545 and 0.56875 (USL + Gray Zone).

4. Select 10 parts and measure them accurately using a variable gage to get a reference value for each. Enter the reference values in column L.
5. The template will calculate if the reference value in column L is within the spec limits. If the value is within the spec limits, the corresponding cell in column K will be populated with a 1 (Pass). If the reference value is outside of the spec limits then K will be populated with 0 (Fail).
   
   If you do not have reference values to input in L, then input the reference for each part directly into K (1 for Pass and 0 for Fail).
   
    

   Tip: The 10 parts must have an actual reference value spanning unacceptable low to unacceptable high.

6. Have 3 appraisers use the attribute gage to accept/reject 10+ parts with at least three trials.
7. Enter pass/fail in columns B-J. 1 = pass (the value is between the spec limits) and 0 = Fail (value is outside of the spec limits). If the appraisers result differs from the reference result in column K, then the cell will be highlighted in red.
   
   
   
   

Evaluate the Results Calculated by the Attribute Gage R&R Template

Kappa: The value used to compare two appraisers measuring the same parts:

Kappa (maximum of 1) > 0.75 = Good to Excellent agreement
0.40 < (minimum of -1) = Poor agreement

UCI: Upper Confidence Interval
LCI: Lower Confidence Interval

FREE QI Macros 30-Day Trial

---

Attribute Gage R&R Video Tutorial

---

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