# Gage Bias and Linearity Study Worksheet

> Source: https://netray.co/tools/gage-bias-and-linearity-study-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Record reference values and average readings across the operating range and see bias at each point as a share of tolerance.

## Category

quality

## Industry

Discrete Manufacturing

## Audience

- Quality engineer
- Metrologist
- Calibration technician

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Reference part

**Key:** point

**Type:** text

#### Reference value

**Key:** ref

**Type:** number

**Unit:** mm

#### Average of readings

**Key:** avg

**Type:** number

**Unit:** mm

#### Feature tolerance (total)

**Key:** tol

**Type:** number

**Unit:** mm

#### Bias (avg - ref)

**Key:** bias

**Type:** number

**Expr:** avg - ref

**Format:** decimal

#### Bias % of tolerance

**Key:** bias_pct

**Type:** number

**Expr:** (avg - ref) / tol * 100

**Format:** percent

**Rows:**

**Point:** Master 1

**Ref:** 2

**Avg:** 2.003

**Tol:** 0.2

**Point:** Master 2

**Ref:** 4

**Avg:** 4.002

**Tol:** 0.2

**Point:** Master 3

**Ref:** 6

**Avg:** 6.005

**Tol:** 0.2

**Point:** Master 4

**Ref:** 8

**Avg:** 8.008

**Tol:** 0.2

**Point:** Master 5

**Ref:** 10

**Avg:** 10.011

**Tol:** 0.2

**Totals:**

#### Mean bias

**Key:** bias

**Agg:** avg

**Format:** decimal

**Summary:**

#### Largest positive bias

**Key:** max_abs

**Expr:** max_bias

**Format:** decimal

**Primary:** true

#### Largest negative bias

**Key:** min_b

**Expr:** min_bias

**Format:** decimal

#### Bias spread across range

**Key:** spread

**Expr:** max_bias - min_bias

**Format:** decimal

**Description:** A large spread suggests linearity error.

**Notes:** For each reference part, measure it at least 10 times, average the readings and enter the average. Reference values should come from a traceable calibrated source. Fit a regression line of bias against reference value in Excel for the full AIAG-style linearity assessment.

## Content

**Intro:** A bias and linearity study checks whether a gage reads true across its working range. This worksheet computes bias at each reference point and shows it as a share of tolerance, so you can see at a glance whether error grows with size.

**Sections:**

#### How to run the study

**Body:** Select five or more reference parts or masters that span the operating range of the gage. Have the appraiser measure each one repeatedly, ideally ten or more readings per part in random order. Enter the reference value, the average of the readings and the feature tolerance. The worksheet subtracts the reference from the average to get bias and divides by tolerance to express it in percent.

**Bullets:**

- Use traceable reference values, not production parts measured on the same gage
- Randomize the order of parts to avoid drift effects
- Keep temperature and operator constant during the study

#### Reading bias and linearity

**Body:** Bias is the difference between the observed average and the accepted reference value. Linearity is how that bias changes across the range. If bias is roughly constant, the gage has an offset that can be corrected. If bias grows with size, the gage has a scale or geometry problem. The spread row shows the difference between the largest and smallest bias, a quick screen before you fit a regression line.

#### Common mistakes

**Body:** The most frequent error is using too narrow a range, which hides linearity problems. Another is using parts whose reference value was set by the same gage under test. Finally, teams often judge bias against the gage resolution rather than the tolerance. Judge it against the feature tolerance and your own acceptance criteria, and document the decision in the calibration or MSA record.

**Cta:** If your gage readings already flow into SAP QM, SyteLine or another ERP, Netray can help pull them into this kind of analysis automatically.

**Faq:**

#### How many reference points do I need?

**Answer:** Five points spread across the operating range is the common minimum for a linearity study. More points give a better regression fit. Include points near both ends of the range and at least one near the middle where most production parts fall.

#### What is an acceptable bias?

**Answer:** There is no universal limit. Many organizations compare bias to the feature tolerance and require it to be a small fraction, often under about 10 percent, or test whether it is statistically different from zero. Follow your customer requirements and internal MSA procedure.

#### Is bias the same as a calibration error?

**Answer:** They are related. Calibration compares the gage to a standard at a few points and may adjust it. A bias study evaluates the whole measurement process, including the appraiser and the part, against a reference value in actual use.

#### Can I export the results?

**Answer:** Yes. Use the export buttons to download the table as Excel or CSV, or as a PDF for inclusion in your MSA file.

## Search terms

gage bias and linearity study, bias linearity worksheet excel, msa linearity study template, gauge linearity study example, measurement system bias calculation, gage linearity form, msa bias study

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json