Generate a Random or Periodic Sample using the QI Macros

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

Copyright © 2011

The QI Macros Data Transformation Tools "Get Sample" function selects a sample of items from a table of data.

1. Just select the data, then select Get Sample from the Data Transformation menu. The following window will open.



2. To select a random sample, input the number of samples you want and click on the Random button



3. To select a Periodic sample, input the number of cells between samples. For example, if you want every third item, input 3.

   

Use the QI Macros data transformation functions to save time and effort.

QI Macros Data Transformation Tools

• Box Cox Transformation
• Stack and Restack
• Get Sample From Table
• Paste Link and Paste Link Transpose
• PivotTable Wizard - Cross Tab
• Count Words in Selection
• Change Default Language
• Quick Keys On and Off
• Show / Hide Data Sheets

Other QI Macros and Control Chart Articles

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!