X bar R Chart Six Pack Template for Excel

The purpose of the X bar R chart template is to evaluate the stability of processes using variable data--time, cost, length, weight.

Here is an example of the X bar R chart template in the QI Macros for Excel.

Just type data into the yellow input area and the control charts, histogram and probability plot will be drawn to the right. You can also cut and paste data from another spreadsheet into the template.

The X bar R chart can help you evaluate the cycle time for almost any process: making a widget, answering a customer call, seating a customer, delivering a pizza, or servicing an appliance. This chart is especially useful when you do this many times a day. Collecting the data could be expensive if you measured every time you did it. Using a small sample (typically five), however, you can effectively measure and evaluate the process.

Calculate, plot, and evaluate the range chart first. If it is "out of control," so is the process. If the range chart looks okay, then calculate, plot, and evaluate the X chart.

See how it works! Add or paste data in yellow cells below...



Learn More...

To create a X Bar R Template in Excel using the QI Macros...
Try It Now!

How We Can Help Download Free QI Macros Trial Buy QI Macros for Excel Now