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 only contain positive values.
NOTE: The proper Lambda will be chosen automatically to provide the best normal distribution output.
Box Cox Transformation Example Using QI Macros for Excel:
- Click and drag over your data to select it.
- Click on the QI Macros menu > Statistical Tools > Transformations > Box Cox:
- 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
Normalized Data
