Run Charts and Control Charts in Excel

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We help people think!

Copyright © 2009

The Evolution of Time Series Analysis
From Run Charts to Control Charts

Then came Run Charts with an average or median center line:

Then came Control Charts

1. The earliest version of the control chart is the line graph showing defects or delay.
   
2. The next version, a run chart, included a line showing the average or median of all values.
3. The next version, added upper and lower control limits calculated as +/-3 sigma from the average. Since it was difficult to measure every item produced, sampling was used to reduce the cost of measurement. This reduction, however, led to many different formulas to handle the various sample sizes.
4. The latest versions include 1- and 2-sigma lines to facilitate stability analysis, and highlighting to automatically pinpoint potential problems.
   

Watch video of creating control charts in Excel using the QI Macros.

Run charts and control charts are just some of the tools included in the QI Macros for Excel SPC Software.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Try QI Macros
FREE
For 30-Days

Or Buy It Now!

Unconditional
90-Day
Money-Back
Guarantee