Box Cox Transformation in Excel

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 purpose of Box Cox transformation is to transform non-normal data into a normalized form.

Box Cox transformation shifts the data to a root of the data using lambda:
-1< lambda <1 (e.g., 3.01^0.5) or ln(3.01) if lambda = 0.

To use the box cox transformation in the QI Macros:

1. Click and drag over your data to select it.
2. Click on the QI Macros menu and select Data Transformation Tools, Box Cox Transformation.

   

3. The macro will prompt you for the transformation factor.

   

4. The results will include your original data to the left, the transformation factor (lamba) and the transformed data.
5. In the results spreadsheet you can change lambda to change the transformation.

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!