Enter your data for Johnson Transformation

Stat > Quality Tools > Johnson Transformation

Enter your data

Select the option that best describes your data.

Single column

If your data are in a single column of the worksheet, complete the following steps.

  1. Under Data are arranged as, select Single column.
  2. In Single column, enter the column of numeric data that you want to analyze.
In this worksheet, the Diameter column contains the diameters of the piston rings. The Subgroup ID column identifies the subgroup for each measurement.
C1 C2
Diameter Subgroup ID
74.030 1
74.002 1
74.019 1
73.992 1
73.995 2
73.992 2

Subgroups across rows of

If you have subgroups arranged in rows across several columns of the worksheet, and each row represents a single subgroup, complete the following steps.

Note

If you use this option to enter your data, all subgroups must be the same size. If your subgroups are arranged in rows and the sizes differ, you can enter a missing value symbol "*" in worksheet cells as needed to make all the subgroup sizes the same.

  1. Under Data are arranged as, select Subgroups across rows of.
  2. In Subgroups across rows of, enter the columns of numeric data that you want to analyze.
In this worksheet, the first row of the worksheet contains the diameters of the piston rings in subgroup 1. The second row of the worksheet contains the diameters of the piston rings in subgroup 2, and so on.
C1 C2 C3
Observation 1 Observation 2 Observation 3
74.030 73.995 73.988
74.002 73.992 74.024
74.019 74.011 74.021
73.992 74.004 74.005

Store transformed data in the worksheet

Store transformed data in
Single column
Enter a single column of the worksheet to store the transformed values in.
Subgroups across rows of
If you have subgroups arranged in rows across several columns, enter the columns in the worksheet to store the transformed values in.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy