Statistical Process Control Charts in Excel

© 2007 KnowWare International, Inc. DBA LifeStar
2253 S. Oneida St., Ste 3D
Denver, CO 80224

Jay Arthur
888-468-1537
303-756-9144
Email Us

We help people think!

Control Charts in Excel

The QI Macros for Excel:

• Draws np, p, c, u, XmR, XbarR, XMedianR, and XbarS control charts
• Calculates and draws lines for: average, +- 1 sigma, +-2 sigma and +-3 sigma (UCL and LCL)
• Performs stability analysis and turns any unstable point or condition RED
• Allows you to add data to existing control charts and create control charts with multiple (stair step) control limits

Here is a sample of a control chart with stair step control limits and stability analysis created by the QI Macros for Excel SPC Software

All of the variable and attribute control charts with stability analysis are included in the QI Macros for Excel SPC Software.

QI Macros Excel SPC Software for Histograms and Control Charts $139 Plus S&H

Many people struggle with choosing the right control chart. Here is some help.

Select the Right Control Chart - Attribute vs Variable Data

Is the data for the control chart variable data?
(e.g., time, height, length, width, weight, money?) Yes No

Is the data for the control chart discrete or attribute data?
(e.g., number of people, complaints, defects, missed commitments, repair reports, etc.)? Yes No

Control Charts for Variable Data

Do you collect 2-10 samples of the data at the same time?
(e.g., length of five concurrent customer calls in a 60 person office? Use the XbarR Chart

Do you collect more than 10 samples of the data at the same time? Use the XbarS Chart

Control Charts for Attribute Data

Do you count the number of defects in a given product or service?
(e.g., defective splices in a cable or the number of mistakes in a typed letter?) Yes No

Number of Defective Units

Does the sample size vary from day to day?
(e.g., number of incorrect payment to vendors per day? Use the "p" Chart

Number of Defects Per Unit

Does the sample size vary from day to day?
(e.g., number defects in all service orders? Use the "u" Chart

For more help, download our Choosing the Right Control Chart quick reference card.

For an explanation of why there are so many different types of control charts see our QI Macros formulas page.

The Evolution of Control Charts

Line Graphs

Run Charts

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 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.

Find out more about control charts at: asq.org

The run chart and all of the variable and attribute control charts are 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

Buy the QI Macros Now! Unconditional, No Questions Asked, 90-day Money-Back Guarantee!

QI Macros Excel SPC Software for Histograms and Control Charts $139 Plus S&H

For more information on control charts see: http://www.itl.nist.gov/div898/handbook/pmc/section3/pmc31.htm

© 2007 KnowWare International Inc. (888) 468-1537
knowwareman@qimacros.com
Home | Lean Six Sigma | QI Macros | KnowWare | Site Map

Or Buy It Now!
Unconditional
90-Day
Money-Back
Guarantee

It contains over 70 fill in the blank templates such as the Ishikawa diagram, QFD, DOE, FMEA, PPAP, and Gage R&R for MSA. Performs ANOVA, t-test, F-test, and regression analysis.

Quantity Discounts

Customer Testimonials

Minitab Comparison

QI Macros FAQs