Home » QI Macros »What Do I Do With My Data?

What Do I Do With My Data?

First: Is Your Data In Horizontal Rows?

Horizontal Excel Data

To get it in position for QI Macros, copy this data.
Switch to another spreadsheet or a blank area in your existing sheet and use Paste Special (Transpose) to get the data transposed

1. Click & drag over the data to select it.

Selected Vertical Excel Data

2. Next click on the QI Macros Menu and select the Chart Wizard (top right).

3. The Chart Wizard will produce every chart it can think of for your data.

1. Click & drag over the data to select it.

f-test-data

2. Click on the QI Macros Menu and run the Stat Wizard.

3. The Stat Wizard will do every test it can think of for your data.

f-test-results

1. Click on two headings:

2. Click on the QI Macros Menu and run the Data Mining Wizard.

QI Macros Data Mining Wizard Menu

3. The Data Mining Wizard turn your data into an entire improvement project.

QI Macros Data Mining Project

KnowWare International, Inc.
2696 S. Colorado Blvd., Ste. 555
Denver, CO 80222 USA
Toll-Free: 1-888-468-1537
Local: (303) 756-9144