On the Data tab of the Xbar-R Chart dialog box, select the option that best describes your data.

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

- From the first drop-down list, select Data are in one column for all subgroups.
- In Data column, enter a column of measurement data.
- 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 |

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

- From the drop-down list, select Data are in multiple columns, one row for each subgroup.
- 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 |