What Do I Do With My Data?

First: Is Your Data In Horizontal Rows?

Horizontal Excel Data

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

Now: Your Data Is In Vertical Columns

If Your Data Has Labels and Numbers

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.


p Chart of Vertical Excel Data
Learn more about the charts you can create using QI Macros..

If Your Data is Similar Numbers for Comparison

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

Learn more about the statistical tests you can perform using QI Macros.

If Your Data has Text and Numbers

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

Learn more about the data mining and analysis you can perform using QI Macros.

Create these charts and diagrams in just seconds using QI Macros for Excel...
Try It Now!