Enter your data for Johnson Transformation

Stat > Quality Tools > Johnson Transformation

In This Topic

Enter your data
Store transformed data in the worksheet

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.

Under Data are arranged as, select Single column.
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.

Under Data are arranged as, select Subgroups across rows of.
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.