Gage R&R Bias and Linearity

QI Macros Gage R&R Template for Excel

Bias and Linearity are two factors that can affect the accuracy of your measurement system: .

Bias: Does your gage tend to over read or under read the same size part? 
(Imagine measuring the length or diameter of a steel rod with known dimensions.)

Linearity: Does your gage over read or under read across a range of different sized parts? 
(Imagine using the gage on tin cans of various diameters, from small, 6 oz. juice cans to 64 oz., family-sized cans.)

Gage R&R Bias Study Using the QI Macros Bias Template

If you want to know the "bias" of your gage, simply input the "target" or "reference" value for the parts being measured into B2 and your measurements into column A. The QI Macros Gage R&R template, will calculate the bias of the gage (plus or minus).

gage r&r bias study

Linearity Study Using the QI Macros Linearity Template

To conduct a linearity study, you will need five parts of DIFFERENT sizes that have been accurately measured.

  1. Have each of the five parts measured 12 times.
  2. Input the data into the QI Macros Gage R&R Linearity template
  3. Input the accurate measurements for each part as reference values in row 16
  4. Analyze the linearity using the line graph on the worksheet.
  5. gage r&r lineraity study in the QI Macros

Ideally, there shouldn't be any change in bias from small to large. If you look at the line graph, it should be a horizontal line. More often, however, a gage may over read the small and under read the large.
If there is too much slope to the line (too much bias), you may want to use the gage in its optimal range and find other gages to measure where this gage's bias is too large.

Conclusion

So, there, in a nutshell Bias and Linearity. Your goal is to minimize the amount of variation and error introduced by measurement, so that you can focus on part variation. This, of course, leads you back into the other root causes of variation: process, machines, and materials.

If you manufacture anything, measurement system analysis can help you improve the quality of your products, get more business from big customers, and baffle your competition. Enjoy.

Linearity Study with QI Macros

 

Gage R&R Training Resources

To create a Gage R And R Bias Linearity using QI Macros...
Try It Now!

Excelerate Your Projects Download Free QI Macros Trial Buy QI Macros for Excel Now