Control Chart Wizard in QI Macros for Excel

home · products · services · search ·  view cart · contact  
 
  NAVIGATION        
 

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.

Control Chart Wizard to select the right control chart

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:

Data Columns Data Chart
1 Integers (attribute) c chart
2 Integers (constant sample)

np chart

2 Integers (varying sample)

p or u chart

1 Decimals (variable)

XmR chart

2-5 Decimals or integers XbarR chart
6+ Decimals or integers XbarS 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

QI Macros - Download with backup CD & User Guide (#230) $139 + S&H
QI Macros - Download Only - No Shipping or Customs Duties (#W230) $139
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.

 

Download
FREE
30-Day Trial

QI Macros SPC Software for Excel

Or Buy It Now
for only $139!
Unconditional
90-Day
Money-Back
Guarantee

Add QI Macros Starter Kit - SPC Software plus training CD and tools book (#275) $197 plus S&H
Add SPC Simplified System - SPC Simplified Book and DVD, Plus SPC Software, Training Cd and Tools Example Book (#285) $297 plus S&H




 
home | products | services | search |  view cart | contact