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

Confused About Which Control Chart to Choose?

Still Can't Figure It Out Even After Attending a Day Long Class?

You Are Not Alone!

Based on calls from our tech support line, we can tell you that most folks struggle with which control chart to choose. Even if they have gone to a training class, it doesn't matter, they still spend time they don't have trying to decide on the right chart and then they still aren't sure.

We can help. The QI Macros Control Chart Wizard can analyze your data and choose the right control chart for you. It saves you time and mistake proofs the control chart selection process. Spend your time on more important things like analyzing the control chart after its drawn.

To use the QI Macros Control Chart Wizard to Select the Right Control Chart

1. Just select your data
2. Then select the Control Chart Wizard from the QI Macros menu.

If it s trying to choose between a p chart and a u chart, it will ask this question:

Answer yes for a u chart and no for a p chart. If the you want to use the XmR Trend or XMedianR, then you will have to choose that chart.

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

The QI Macros SPC Software 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 SPC Software for Excel.

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
for only $139!
Unconditional
90-Day
Money-Back
Guarantee