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:

    yeo-johnson-transformation-output

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

yeo-johnson-transformed-data-output

*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!
FREE QI Macros 30-Day Trial

QI Macros can draw these charts too!

Control Charts
control charts
Histograms
histogram
Pareto Charts
pareto chart
Box Plots
box whisker plot
Fishbone Diagram
fishbone diagram
Data Mining and Analysis
Download Free QI Macros Trial
Buy QI Macros for Excel Now