Data Transformation and Analysis Tools in the QI Macros

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

• Is your data buried in flat transaction files or text files the ones below?
• Do you struggle to turn this kind of data into actionable improvement stories?
• Do you struggle with Excel's Pivot Table function?

Struggle No More! The QI Macros contains the tools to help you transform and reorganize your data:

Crosstab PivotTable Wizard - Excel Pivot tables can be hard to learn but they are a snap with the QI Macros. Just select up to four columns of data and then click on the QI Macros PivotTable Wizard to create a PivotTable in Excel.

There are million dollar improvement projects lurking in this kind of data. Are you missing out on huge opportunities?

Word Count - counts the number of times a word or two word phrase appears in comment data collected by service reps from customers. Use it to summarize raw text data and then create pareto charts.

Want to know what customers are peeved about? Use Word Count to find out!

Stack and Restack - Converts the number of columns your data is organized into. You can increase the number of columns your data in organized into (e.g. 1 to 2, 1 to 4, 3 to 5, etc.) or you can decrease the number of columns your data is organized into (e.g. 4 to 1, 4 to 2, 3 to 2, etc.) Stack/ Restack replaces the Gen table macro in old versions of the QI Macros.

Get Sample - Selects either a Random or Periodic sample from a table of data.

Paste Link/Paste Link Transpose - Excel allows you to either Paste Link or Paste Transpose but not both at the same time. Use the QI Macros to do both. The QI Macros Paste Link and Paste Link Transpose also use formulas to prevent putting zeros instead of blanks in linked cells.

Use these tools to create the links from existing data to the QI Macros Fill-in-the-blanks chart templates to simplify reporting.

Box Cox Transformation - Box Cox transforms non-normal data into data that is closer to normal.

Set QI Macros Preferences:

• Change Default Language
• Quick Keys On / Off
• Show / Hide Data Sheets

Use the QI Macros Data Transformation Tools to save you time and effort.

View Data Transformation Tools Tutorial - 14 minutes

To access the QI Macros data transformation functions, find the data transformation sub menu.

Excel 2006 and previous versions:

Excel 2007-2010:

The QI Macros SPC Software for Excel has five parts:

1. Over 30 charts including histograms, pareto charts, scatter plots, box whisker plots and all variable and attribute control charts. Just select your data and then click on the QI Macros menu and select the chart you want to run.
2. Over 80 Fill-in-the-blank templates and tools including fishbones, FMEA, DOE, Gage R&R, PPAP forms and more.
3. Statistical tools including Anova, f-test, t-test, regression, data normality test, sample size calculator and more.
4. Data Transformation tools to help organize and analyze your data including stack and restack, and WordCount and PivotTable Wizards.
5. Automated Control Chart Dashboards - just drop your data into these pre-formatted templates.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Try QI Macros
FREE
For 30-Days

Or Buy It Now!

Unconditional
90-Day
Money-Back
Guarantee