Xbar-R charts monitor subgroup means and within-subgroup ranges. Choose rational subgroups that represent comparable short-run conditions. Review the range chart before interpreting changes in the mean. The constants depend on subgroup size. Customer specification limits do not replace statistical control limits, and preliminary limits need more evidence before routine deployment.
You work with original records from fictional operations teams. Start by checking what each column means and which cases belong in the denominator. A precise calculation can still answer the wrong business question if the population or time boundary changes. Use the worksheet to leave an audit trail: preserve the inputs, record the intermediate outputs and check the stated exception. The transfer case uses new data so you must apply the method again.
Calculate subgroup mean and range limits with the stated constants.