Need to Transform Non-normal Data using Yeo-Johnson Transformation?

QI Macros can run a Yeo-Johnson Transformation on your data in seconds!

Yeo-Johnson Transformation uses a statistical calculation to transform non-normal data to a normal distribution so that additional analysis can be performed. While this transformation is designed for numerical data, said data can contain positive AND negative values.

NOTE: The proper Lambda will be chosen automatically to provide the best normal distribution output.

Yeo-Johnson 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 > Transformations > Yeo-Johnson:

    Box Cox menu
  3. QI Macros will automatically transform your data and provide you with a Histogram, BoxPlot, Confidence Intervals, and Tolerance Limits, as well as Probability Plot outputs:


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


*Included in the 07.2024 version of QI Macros*

Stop Struggling with Yeo-Johnson Transformation!
Start conducting Yeo-Johnson Transformation in just minutes.

Download a free 30-day trial. Run Yeo-Johnson Transformation now!

QI Macros can draw these charts too!