Struggling to Understand Standard Deviation and Control Charts?

QI Macros Can Select the Right Control Chart and Draw it For You!

Draw any Control Chart using QI Macros

  1. Select your data.
  2. Select control chart wizard on QI Macros menu.
  3. QI Macros will do the math and draw the graph for you.

Go Deeper

Many people ask: "Why aren't my upper and lower control limits (UCL, LCL) calculated as:
µ ∓ 3sigma (where μ is the mean and sigma is the standard deviation)?" If you are using a Levey Jennings chart, then that IS how your control limits are calculated.

However, if you are using another other control chart, you have to understand some key, underlying statistics: variation, standard deviation, sampling and populations.

Variance (stdev²) is the average of the square of the distance between each point in a total population (N) and the mean (μ).

If your data is spread over a wider range, you have a larger variance and standard deviation. If the data is centered around the average, you have a smaller variance and standard deviation.

Standard deviation (stdev or sigma) is the square root of the variance:
And it can be estimated using the average range (Rbar) between samples (Rbar/d2) when the number of subgroups is 2-10, or using standard deviation Sbar/c4 when n>10.
Rbar = Rave = ΣRi/n

Sampling: Early users of SPC found that it cost too much to evaluate every item in the total population.. To reduce the cost of measuring everything, they had to find a way to evaluate a small sample and make inferences from it about the total population.

Understanding Control Chart Limits:

Ask yourself this question: "If a simple formula using the mean and standard deviation would work for any data, why are there so many different control charts?"

The short answer: to save money by measuring small samples, not the entire population.

Long answer: When using small samples or varying populations, the simple formula using the mean and standard deviation just doesn't work, because you don't know the average, µ, or sigma of the total population, only µ or sigma of your sample.

Why are there so many control charts? Because:
You have to estimate µ and sigma using the average and range of your samples.

In variable charts, the XmR uses a sample size of 1, XbarR (2-10) and XbarS (11-25). These small samples may be taken from lots of 1,000 or more.

In attribute charts, the c and np chart use small samples and "fixed" populations; the u and p charts have varying populations. So, you have to adjust the formulas to compensate for the varying samples and populations.

To reduce the cost of inspection at Western Electric in the 1930s, Dr. Walter S. Shewhart developed a set of formulas and constants to compensate for these variations in sample size and population. That's why they are sometimes called Shewhart Control Charts.

Reference: You can find these in any book on statistical process control (e.g., Introduction to Statistical Process Control, Montgomery, Wiley, 2001, pgs. 207-265).

Stop Struggling with Control Charts!
Start creating your Control Charts in just minutes.

Download a free 30-day trial. Get Control Charts now!

Other Resources

Control Charts are just one of the tools included in QI Macros SPC Software for Excel.

Why Choose QI Macros Over Other Control Chart Software?

easy to use

Fast and Easy to Use

  • Works right in Excel
  • Create charts in seconds
  • Easy to customize & share charts
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free



  • Only $369 USD
    Quantity Discounts Available
  • No annual subscription fees
  • Free technical support