Enter your data for Box-Cox Transformation

Stat > Control Charts > Box-Cox Transformation

Select the option that best describes your data.

All measurements are in one column

Complete the following steps if the measurement data are in one column.

  1. From the drop-down list, select All observations for a chart are in one column.
  2. Enter one or more columns of measurement data.
  3. In Subgroup sizes, do one of the following:
    • If your data are not collected in subgroups, enter 1.
    • If all subgroups are the same size, you can enter the subgroup size (for example, 5).
    • Enter a column of values that identifies which subgroup each measurement is from.
In this worksheet, the Length column contains the length of parts, and the Subgroup column contains the subgroup indicators.
C1 C2
Length Subgroup
0.65 1
0.69 1
0.67 1
0.67 1
0.62 2
0.59 2
0.59 2
0.60 2

Measurements for each subgroup are in a different row

Complete the following steps if each row in the worksheet contains the measurement data for one subgroup.

  1. From the drop-down list, select Observations for a subgroup are in one row of columns.
  2. Enter the columns that contain the measurement data.
In this worksheet, the data for subgroup 1 are in the first row across columns 1−4. The data for subgroup 2 are in the second row across columns 1−4.
C1 C2 C3 C4
Measurement 1 Measurement 2 Measurement 3 Measurement 4
0.65 0.69 0.67 0.67
0.62 0.59 0.59 0.60