What Do I Do With My Data?
First: Is Your Data In Horizontal Rows?
- To get it in position for QI Macros, copy the data.
- Switch to another spreadsheet or a blank area in your existing sheet and use Paste Special (Transpose) to transpose the data from 3 rows to 3 columns.
Now: Your Data Is In Vertical Columns
If you have time series data (data over time):
1. Click & drag over the data to select it.
2. Next click on QI Macros Menu and select the Chart Wizard (top right).
3. The Chart Wizard will produce every chart that matches your data.
Learn more about the charts you can create using QI Macros..
If you have two sets of data 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 conduct every statistical analysis test available 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.
Join 100,000+ Users
in 80 Countries
KnowWare International, Inc.
2696 S. Colorado Blvd., Ste. 555
Denver, CO 80222 USA
Toll-Free: 1-888-468-1537
Local: (303) 756-9144
