Need to Transform Non-normal Data using Box Cox Transformation?

QI Macros can run a Box Cox Transformation on your data in seconds!

Box Cox Transformation uses a statistical calculation to transform non-normal data to a normal distribution so that additional analysis can be performed. Box Cox transformation requires data to be continuous (measured) and to only contain positive values.

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.

Box Cox Transformation Example Using QI Macros for Excel:

  1. Click and drag over your data to select it.

    box cox non normal data example
  2. Click on the QI Macros menu > Statistical Tools -> Regression and Other Statistics > Box Cox.

    Box Cox menu

  3. QI Macros will prompt you for a transformation factor.

    box cox transformation factor
  4. QI Macros results will include your original data to the left, the transformation factor (lamba) and the transformed normalized data. If you change lambda, the normalized data values will change.

    box cox transformation results

If we ran a histogram on the before and after data sets we can compare the non-normal and normal distributions.

Non-normal Data

non normal data

histogram non-normal data

Normalized Data

normalized data

histogram normalized data

Stop Struggling with Box Cox Transformation!
Start conducting Box Cox Transformation in just minutes.

Download a free 30-day trial. Run Box Cox Transformation now!

QI Macros can draw these charts too!