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 work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011



 

Confused About Which Control Chart to Choose?

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

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.

Decision Trees are Cumbersome. Rather than having to think your way through the forest of decision trees like the ones in Minitab, wouldn't it be great if the decision tree was already coded into the software? In the QI Macros, it is!

Minitab
Decision Tree

QI Macros
Turns Decision Trees into a One Click
Control Chart Wizard

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. The Chart Wizard will automatically select the XmR (Individuals) 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 - One License Per Computer
- Download Now and Get Backup CD & User Guide (#230) in 1-3 days - $199 + S&H
QI Macros - One License Per Computer
- Download Only - No Shipping or Customs Duties (#W230) $199

 

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.

 

It's easy to choose the right chart with the QI Macros

Download
QI Macros

30-Day Trial Now!


Or Buy It Now!

Unconditional
90-Day
Money-Back
Guarantee


 
home | products | services | search | sitemap | view cart | contact
QI Macros | Excel SPC Software | SPC Software Free Trial
Control Charts | c Chart | np Chart | p Chart | u Chart
ImR Chart | XmR Chart | XMedianR Chart | XbarR Chart | XbarS Chart | EWMA Chart
Anom Chart | Cusum Chart | Levey Jennings Chart | Moving Average Chart
Histograms | Pareto Chart | Scatter Plot | Run Chart
Box Whisker Plot | Dot Plot | Multivari Chart

Lean Six Sigma Training | Lean Six Sigma Training Denver
Lean Six Sigma Consulting | Lean Six Sigma Consulting Denver
Lean Six Sigma Training Systems | Do-It-Yourself Lean Six Sigma Training