Control Chart Wizard in QI Macros for Excel

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We help people think!

Copyright © 2008

Choosing Control Charts in Excel

Control charts with stability analysis can be created easily with the QI Macros for Excel SPC software. But we found that it often took a whole afternoon of SPC class for participants to learn the basics of choosing the right control chart for their data.

So, one day, I thought: "Why not mistake-proof the selection of a control chart?" The QI Macros have to analyze your data to make sure it fits with the type of chart you've selected, so why not go the extra mile and figure out what chart best fits your data?

So we added the Control Chart Wizard to the pull-down menu.

Just select your data and click on the Control Chart Wizard which will analyze your data and choose the best chart for you!

Here's how the Control Chart Wizard selects the chart:

The p and u charts are similar enough that the wizard will ask you if there can be more than one defect per unit (scratches per finish, falls per patient, etc.).

If the you want to use the XmR Trend or XMedianR, then you will have to choose that chart.

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

All of the variable and attribute control charts with stability analysis 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

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

Download
FREE
30-Day Trial

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