Data Mining and Analysis Tools for Excel

This tool will analyze an entire table of defect data using PivotTables, control charts and Pareto charts. It will create all of the charts necessary to develop a rock-solid, bullet-proof business case for change.

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?

Counts the number of times a word or two-word phrase appears in comment data collected by employees, such as call center reps. 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!

Changes how your data is organized. You can increase the number of columns (e.g. 1 to 2, 1 to 4, 3 to 5, etc.) or you can decrease the number of columns (e.g. 4 to 1, 4 to 2, 3 to 2, etc.)

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

Use these features to create the links from existing data to the QI Macros Lean Six Sigma chart templates to simplify reporting.

Use these tools to simplify comparing means and variances, doing regression testing and other key data analysis tools and techniques.