Close this search box.

Johnson Transformation Help

This page shows how to perform the Johnson Transformation using SPC for Excel. The data can be downloaded at this link.

Running the Johnson Transformation

Johnson Transformation Output

Two sheets are added to the workbook. Both are named with a number following the name reflecting the number of times the Johnson transformation has been run in the workbook.

JT Plot

This sheet contains the Johnson transformation and includes the best distribution (SB in this example), p value, the z value and the transformation equation. All three transformations are plotted.

JT Output

The top part of this worksheet contains the descriptive statistics for original and transformed data. The coefficients from the Johnson transformation are also shown.

The middle part of the worksheet contains the histograms and P-P plots (if those options were selected).

The bottom part of the worksheet contains the transformed data if that options was selected.

Scroll to Top