|
© 2007 KnowWare
International, Inc. DBA LifeStar
2253 S. Oneida St., Ste 3D
Denver, CO 80224
Jay Arthur
888-468-1537
303-756-9144
Email Us
We help people think!
|
|
The QI Macros include the following new Data Transformation functions:
Data Transformation Menu
To access the QI Macros data transformation functions, find the data
transformation sub menu.
Excel 2006 and previous versions:
Excel 2007:
Stack / Restack
Stack/Restack will convert the number of columns your data is organized
into. You can increase the number of columns your data in organized into
(e.g. 1 to 2, 1 to 4, 3 to 5, etc.) or you can decrease the number of
columns your data is organized into (e.g. 4 to 1, 4 to 2, 3 to 2, etc.)
Stack/ Restack replaces the Gen table macro in old versions of the QI
Macros.
To use the Stack/Restack functions in the QI Macros:
- Select your data.
- Next select Stack/Restack from the Data Transformation sub menu.
- Input the new number of columns you desire:
- The macros will convert your data to the new number of columns you
requested. Here is an example of how 1 column in converted to 3:
Get Sample
Get Sample selects of sample of items from a table of data.
- Just select the data then select Get Sample from the Data Transformation
menu. The following window will open.
- To select a random sample, input the number of samples you want and
click on the Random button
- To select a Periodic sample input the number of cells between samples.
For example, if you want every third item, input 3.
Paste Link/ Paste Link
Transpose
If you want your control charts to automatically update when you add
data to your original spreadsheet use the Paste Link or Paste Link Transpose
function.
Excel allows you to either Paste Link or Paste Transpose but not both
at the same time. To use Excel's functions:
- Select your data (and future input cells), then select Edit /Copy
from Excel's menu.
- Click in the destination cells and select Paste Special and either
select Link or check the box next to Transpose.
To use the Paste Link and Paste Link Transpose functions in the QI Macros:
- Select your data and any future input cells.
- Next select either Paste Link or Paste Link Transpose on the QI Macros
Data Transformation sub menu.
- The macro will paste your linked data into another spreadsheet.
- Select the linked data and use Edit/Cut then Edit/Paste to move your
data to the QI Macros control chart template or other destination.
- As you update your original datasheet, your linked cells and any associated
charts will update.
Box Cox Transformation
Box Cox Transformation muliplies the selected data by a transformation
factor. The purpose is to transform non-normal data into data that is
closer to normal.
To run box cox just select your data then select Box Cox from the QI
Macros Data Transformation menu. You will be prompted for the factor.
Results look like this:
Use the QI Macros data transformation functions to save time and effort.
In Lesson #
12 we will cover Pareto Charts.
View previous
lesson ...........View
next lesson
QI Macros Excel SPC Software for Histograms and Control Charts $139 Plus S&H
© 2007 KnowWare International Inc. (888) 468-1537
knowwareman@qimacros.com
Home
| Lean Six Sigma
| QI Macros
| KnowWare
| Site Map
|
Hospital Bed Management System
Patient LOS System
Time Tracking Templates
Lean Six Sigma Consulting
Or Buy It Now!
Unconditional
90-Day
Money-Back
Guarantee
The QI Macros for Excel $139,
is an inexpensive easy to use set of Excel add-ins for statistical process control
and Lean Six Sigma. It draws line, pie, bar, pareto, box whisker, histogram (Cp,
Cpk), scatter and control charts (with stability analysis).
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.
Quantity Discounts
Customer Testimonials
Minitab Comparison
QI Macros FAQs
|
