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:
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 Improvement Project Wizard (formerly Data Mining Wizard):
3. The Improvement Project Wizard turn your data into an entire improvement project:
Learn more about the data mining and analysis you can perform using QI Macros.
Why wait? Start creating these charts and diagrams in seconds using
QI Macros add-in for Excel.