# Gage Stability Study Worksheet (X-bar and R Limits)

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

## Short answer

Log repeated master readings over time and get subgroup means, ranges and X-bar and R control limits for a stability check.

## Category

quality

## Industry

Discrete Manufacturing

## Audience

- Quality engineer
- Metrologist

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Date

**Key:** date

**Type:** date

#### Reading 1

**Key:** r1

**Type:** number

#### Reading 2

**Key:** r2

**Type:** number

#### Reading 3

**Key:** r3

**Type:** number

#### Subgroup mean

**Key:** mean

**Type:** number

**Expr:** (r1 + r2 + r3) / 3

**Format:** decimal

#### Subgroup range

**Key:** range

**Type:** number

**Expr:** max(r1, max(r2, r3)) - min(r1, min(r2, r3))

**Format:** decimal

**Rows:**

**Date:** 2026-09-01

**R1:** 25.002

**R2:** 25.001

**R3:** 25.003

**Date:** 2026-09-08

**R1:** 25.001

**R2:** 25.002

**R3:** 25.002

**Date:** 2026-09-15

**R1:** 25.003

**R2:** 25.003

**R3:** 25.002

**Date:** 2026-09-22

**R1:** 25.002

**R2:** 25.004

**R3:** 25.003

**Date:** 2026-09-29

**R1:** 25.004

**R2:** 25.003

**R3:** 25.005

**Date:** 2026-10-06

**R1:** 25.003

**R2:** 25.002

**R3:** 25.003

**Totals:**

#### Grand mean

**Key:** mean

**Agg:** avg

**Format:** decimal

#### Average range

**Key:** range

**Agg:** avg

**Format:** decimal

**Summary:**

#### X-bar upper control limit

**Key:** ucl_x

**Expr:** avg_mean + 1.023 * avg_range

**Format:** decimal

**Primary:** true

#### X-bar lower control limit

**Key:** lcl_x

**Expr:** avg_mean - 1.023 * avg_range

**Format:** decimal

**Primary:** true

#### R upper control limit

**Key:** ucl_r

**Expr:** 2.574 * avg_range

**Format:** decimal

**Notes:** Limits use the standard constants for subgroups of three (A2 = 1.023, D4 = 2.574, D3 = 0). Collect at least 20 subgroups before treating the limits as stable. Compare each row's mean and range to the limits and look for trends and runs.

## Content

**Intro:** Stability is the change in a measurement system over time when measuring the same master. This worksheet turns repeated readings into subgroup means and ranges and calculates X-bar and R control limits so you can see drift early.

**Sections:**

#### How to set up the study

**Body:** Pick a master part or reference standard near the middle of the gage range. At a fixed interval, such as weekly, have a routine appraiser take three readings and enter them with the date. The worksheet computes the subgroup mean and range for each row and updates the grand mean, average range and control limits as you add data.

**Bullets:**

- Use the same master, appraiser method and environment each time
- Plan for at least 20 subgroups before trusting the limits
- Store the master under controlled conditions between uses

#### The control limit formulas

**Body:** For subgroups of size three, the X-bar limits are the grand mean plus or minus A2 times the average range, with A2 equal to 1.023. The upper range limit is D4 times the average range, with D4 equal to 2.574 and no lower limit for this subgroup size. Points outside the limits, runs on one side of the mean or steady trends indicate the measurement system is not stable.

#### Acting on the result

**Body:** An unstable gage should not be used for decisions until the cause is found. Typical causes are wear, contamination, thermal change, a damaged master or an appraiser technique change. Record the investigation and corrective action in your calibration or CAPA system, and shorten the calibration interval if drift is real. A stable chart supports keeping or extending an interval.

**Cta:** Netray can help connect gage and inspection results from your ERP or MES to recurring stability reviews, with the data staying on your own systems.

**Faq:**

#### Why subgroups of three?

**Answer:** Three readings per session is a practical balance between effort and a useful range estimate. You can use other sizes, but the control chart constants change, so adjust the formulas in the exported Excel file.

#### How often should I run a stability check?

**Answer:** Many shops check critical gages weekly or each shift and others monthly. Choose a frequency based on how fast the gage can drift, how critical the feature is and your history of out-of-tolerance findings.

#### What if a point is out of control?

**Answer:** Stop using the gage for critical decisions, verify the master, repeat the readings, and investigate. If the gage is confirmed out of control, follow your out-of-tolerance procedure and assess previously measured product.

#### Does stability replace calibration?

**Answer:** No. Stability monitoring shows drift between calibrations and supports interval decisions. Calibration against traceable standards is still required.

## Search terms

gage stability study, measurement system stability control chart, msa stability worksheet, xbar r chart gage stability, gauge drift study template, stability study excel

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