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

On the Data tab of the Xbar-S 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, Length contains the length of parts, and Subgroup identifies which subgroup each measurement is from.
C1 C2
Length Subgroup
066 1
0.65 1
0.68 1
0.62 2
0.59 2
064 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 Data are in multiple columns, one row for each subgroup.
  2. In Data columns, enter the columns that contain the measurement data.
In this worksheet, the data for subgroup 1 are in the first row across columns 1−9, the data for subgroup 2 are in the second row across columns 1−9, and so on.
C1 C2 C3 C4 C5 C6 C7 C8 C9
Obs 1 Obs 2 Obs 3 Obs 4 Obs 5 Obs 6 Obs 7 Obs 8 Obs 9
0.65 0.69 0.67 0.67 0.68 0.66 0.64 0.65 0.68
0.62 0.59 0.59 0.60 0.58 0.60 0.61 0.60 0.60
0.66 0.63 0.58. 0.62 0.64 0.64 0.63 0.64 0.67
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy