Enter your data for Xbar-R Chart (Data tab)

On the Data tab of the Xbar-R Chart dialog box, 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 first drop-down list, select Data are in one column for all subgroups.
  2. In Data column, enter a column of measurement data.
  3. From the second drop-down list, do one of the following:
    • If all subgroups are the same size, choose All subgroups are the same size. In Subgroup size, enter the subgroup size (for example, 5).
    • If you have a column of values that identifies which subgroup each measurement is from, choose Subgroup IDs are in a column. In Subgroup ID column, enter the column of subgroup identifiers.
In this worksheet, Measurements contains the measurement data. Subgroup identifies which subgroup each measurement is from.
C1-T C2
Subgroup Measurements
One 10
One 13
One 10
Two 8
Two 8
Two 9

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 Data are in multiple columns, one row for each subgroup.
  2. In Data columns, enter the columns that contain the measurement data.
In this example, Measurement_1, Measurement_2, and Measurement_3 contain the measurement data. The data for subgroup 1 are in row 1, the data for subgroup 2 are in row 2, and so on.
C2 C3 C4
Measurement_1 Measurement_2 Measurement_3
10 13 10
8 8 9
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy