What Do I Do With My Data?
First: Is Your Data In Horizontal Rows?
- 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
Now: Your Data Is In Vertical Columns
If Your Data Has Labels and Numbers
1. Click & drag over the data to select it.
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.
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.
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.
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.
3. The Data Mining Wizard turn your data into an entire improvement project.
Learn more about the data mining and analysis you can perform using QI Macros.