QI Macros SPC Software for Excel Lesson 5

QI Macros Lesson 5 - Data Transformation Tools
home · products · services · search · view cart · contact

NAVIGATION

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

The QI Macros contains the following tools to help you transform and reorganize your data:

Cross Tab Pivot Table Wizard makes it easier to run Pivot tables on transaction data. Just select up to four columns of data and select our Pivot Table wizard.

pivot table data

Count Words in a Table will count the number of times a word or two word phrase appears in your data. You can then run pareto charts on these counts to identify common themes and problems.

word count 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 functions to build your own 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.

To Use the Data Transformation Tools

Select your data and
Choose a data transformation tool from the pulldown menu (e.g., paste, restack, etc.)

For more information:

Watch Data Transformation Overview Video - 3 minutes
Watch Data Transformation Tutorial - 14 minutes

If you need help analyzing your data and creating an actionable improvement project, we offer:

Is There an Improvement Project Lurking in Your Data - 1 hour training video.
Private and Custom Webinars
Data analysis services via email. Just send us your data and a brief explanation of your process and suspected problem.

In Lesson #6 we will cover Automated Control Chart Dashboards.

View previous lesson ...............View next lesson

To sign up for this series tell your friends to send an email to qimacros@aweber.com

If you love the QI Macros...
Please ask a handful of friends to download the trial version. Here's what to say:
Need easy to learn, easy to use software for Lean Six Sigma and SPC that works right in Microsoft Excel? Test drive the QI Macros!
Find out more at www.qimacros.com/excel-spc-software.html.
Get a 30-day trial at www.qimacros.com/free-spc-software.html.

Going to a meeting of quality professionals?
We can send you as many QI Macros 30-day trial CDs as you need. Just send an email with the address and quantities needed to orders@qimacros.com.

Try QI Macros
FREE
For 30-Days

QI Macros Lesson 5 - Data Transformation Tools

The QI Macros contains the following tools to help you transform and reorganize your data:

To Use the Data Transformation Tools