QI Macros Trial #5 - Data Transformation Tools | |||||||||||||||||||
We help people think! |
How to Transform, Summarize and Reorganize Data using The QI Macros.The QI Macros contains the following tools to help you transform or reorganize your data:Stack/Restack increases or decreases the number of columns your data is organized into. It can take one column of data and "stack" it into multiple columns or it can take multiple columns of data and restack it into one column. Get Sample selects a sample from a table of data. Select the data, then select Get Sample. The macro will prompt you for the # of samples and whether you want a Random or Periodic sample. A periodic sample of 3 will give you every 3rd item from your data. Paste Link/ Paste Link Transpose: Excel lets you paste link and paste transpose but it doesn't let you do both at the same time. Use these functions to link your data to a QI Macros fill-in-the-blanks template. Update your data sheet and the template and chart are automatically updated. Use these function to build dashboards. Box Cox Transformation multiplies the selected data by a transformation factor. The purpose is to transform non-normal data into data that is closer to normal. Count Words in a Table will count the number of times a word or two word phrase appears in your data. Cross Tab Pivot Table Wizard makes it easier to run Pivot tables on your data. See www.qimacros.com/free-excel-tips/data-transformation.html
for further information on these tools. To Use the Data Transformation ToolsJust 1) select your data and 2) choose a data transformation tool from the pulldown menu (e.g., paste, restack, etc.) Watch Video. Test DataTest data for Cross Tab and Word Count are in the crosstab file loaded on your machine in c:\qimacro\testdata. QI Macros HelpNear the bottom of the QI Macros pulldown menu you'll find the help file. In it you'll find further descriptions of each of the tools and templates. Watch Video. In the following lessons, we'll take a more detailed look at each of the main features of the QI Macros. After you've tested the QI Macros enough to satisfy your curiosity about how well the software can meet your needs, you can purchase online at https://www.qimacros.com/order230.html 24 hours a day. If you have questions, email them plus your sample data to: lifestar@rmi.net In Lesson #6 we will cover Dashboards and Scorecards in the QI Macros. Thank you again for your interest in the QI Macros. View Next Lesson
© 2007 KnowWare International Inc. (888) 468-1537 |
It contains over 70 fill in the blank templates such as the Ishikawa diagram, QFD, DOE, FMEA, PPAP, and Gage R&R for MSA. Performs ANOVA, t-test, F-test, and regression analysis.
|
|||||||||||||||||
