QI Macros Control Chart and Capability Formulas

QI Macros control chart formulas, capability analysis formulas and other calculations are taken from widely accepted SPC References including, Montgomery, Breyfogle, Juran and NIST. The exact formulas and other information for each chart can be found by clicking on the links below:

Control Chart Formulas


Other Control Chart Calculation Information

Process Capability Analysis Formulas

Download a free pdf of histogram formulas and sample calculations (PDF, 153 KB)

If you still need more help after reading the following information and our free pdf, consider our Histogram Whitepaper.

Other Resources

Six Sigma and SPC Reference Books

If you want a good Lean Six Sigma reference, consider my Lean Six Sigma DeMystified book:

If you don't have a good statistical reference book, I can recommend:


Juran's Quality
Control Handbook

(4th), McGraw Hill,
NY, 1988.

Douglas Montgomery, Introduction to Statistical Process Control
(4th), John Wiley & Sons,
NY, 2001.

Douglas Montgomery, Design
and Analysis of Experiments

(5th), John Wiley & Sons,
NY, 2001


Montgomery Instructor Companion Site includes Data Sets Referenced in Montgomery's book


Automotive Industry
Action Group Resources

  • Statistical Process Control (2nd), AIAG 2005
  • Measurement Systems Analysis (3rd), AIAG, 2002

NIST -
Engineering Statistics On Line Handbook
Purchase QI Macros SPC Software for Excel through our secure shopping cart or try a free, QI Macros 30-day trial!
Excelerate Your Projects Download Free QI Macros Trial Buy QI Macros for Excel Now