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
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.
Will analyze your data and choose the right control chart for you: c, np, p, u, XmR, XbarR or XbarS.
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.
Will analyze your data, create a pivot table of the data, and generate an XmR chart and defect Paretos.
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.