Control Chart and Capability Formulas

Tired of Trying to Make Do with Homegrown Excel Templates? Give Me Five Minutes and I'll Have You Drawing Accurate Control Charts and Histograms

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 Used in QI Macros

Other QI Macros Control Chart Calculation Information

Process Capability Analysis Formulas Used in QI Macros

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:

Lean Six Sigma Demystified

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




Automotive Industry
Action Group Resources

  • Statistical Process Control (2nd), AIAG 2005
  • Measurement Systems Analysis (4th), AIAG, 2010

Why Choose QI Macros Over Other Control Chart Software?

affordable

Affordable

  • Only $249 USD - less with quantity discounts
  • No annual fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • 100,000 users in 80 countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus free