XmR Chart Workbook & Guide

The XmR Chart Workbook & Guide summarizes the process of building an XmR Chart into six easy to follow steps. These steps include:

  1. Gather the data

  2. Calculate the moving ranges

  3. Calculate the average moving range (r-bar)

  4. Calculate the mean (x-bar)

  5. Calculate the process limits

  6. Construct the XmR Chart

While it is widely assumed that understanding variation and constructing process behavior charts can only be achieved with special software and the help of consultants, this could not be further from the truth. Spreadsheet software like Microsoft Excel and Google Sheets is more than capable of helping you understand variation.

This Google Sheets workbook is a step-by-step guide for building the most useful process behavior chart, the XmR Chart.

Characterization flowchart

How to build a helpful histogram workbook & Guide