QI Macros Chart and Statistical Wizards

Built-in Rules So You Don't Have to Memorize Them

  • Confused About Which Chart or Statistic to Choose and Use?

  • Not Sure How to Organize or Summarize Thousands of Rows of Data.

  • You Are Not Alone!

Most Six Sigma Training is designed to turn people into mathematicians or statisticians!

Unfortunately, most people are terrified of math and statistics. To reach a much wider audience, I've found that the QI Macros have to help people over the hurdle of charting and statistical analysis. I've also found that people learn what charts to choose a lot more quickly when the QI Macros helps them draw some charts. The same is true of statistics.

That's Why We Created QI Macros Wizards

They are easy to spot on the QI Macros Menu:

QI Macros wizards with built in selection rules


QI Macros Wizards

    Chart Wizard 

    Will analyze your data and choose the right charts for you. It saves you time and mistake proofs the chart selection process. Spend your time on more important things like analyzing the charts after they are drawn.

    Control Chart Wizard 

    Will analyze your data and choose the right control chart for you: c, np, p, u, XmR, XbarR or XbarS.

    PivotTable Wizard 

    Will take up to four columns of tabular data and summarize them using Excel's PivotTable function. I have found that almost everyone is baffled by how to use PivotTables, but all of my multimillion dollar improvement projects have sprung from PivotTable Analysis.

    Data Mining Wizard 

    Will analyze your data, create a pivot table of the data, and generate an XmR chart and defect Paretos.

    Statistics Wizard 

    Will analyze your data and choose the right hypothesis tests for you. Hypothesis testing can seem pretty complex and challenging, but it basically wants to know if the means and variances of two or more samples are the same or different. The Stat Wizard will figure it out and tell you in no uncertain terms. No more p values to evaluate.

If you already know what chart or statistic you need, you can select it from the QI Macros menu. The Wizards are designed to help beginners learn the tools and "old hands" remember what tool to use if they forgotten which one to use.

Purchase QI Macros SPC Software for Excel through our secure shopping cart or try a free, QI Macros 30-day trial!