Control Chart Wizard in QI Macros for 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!

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.

Control Chart Wizard to select the right control chart

Just select your data and click on the Control Chart Wizard which will analyze your data and choose what it believes to be the best chart for you! (It's a bit like the the "I Feel Lucky" button on Google's home page.)

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

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

© 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

The QI Macros for Excel $139, is an inexpensive easy to use set of Excel add-ins for statistical process control and Lean Six Sigma. It draws line, pie, bar, pareto, box whisker, histogram (Cp, Cpk), scatter and control charts (with stability analysis).

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