Home » Control Charts » Run Charts and Control Charts

Run Charts and Control Charts in Excel

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

First there were Line Graphs:

 

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.