Data Analysis with Microsoft Excel: Updated for Office 2007

510 Statistical Methods

We can also create a moving range chart of the moving range values, that

is, the range between consecutive values. In this case, the lower and upper

control limits match the ones used earlier for the range chart.

LCL 5 D 3 R

UCL 5 D 4 R

Let’s apply these formulas to a workbook recording the tensile strength of

25 steel samples. The values are stored in the Strength workbook.

To open the Strength workbook:

1 Open the Strength workbook from the Chapter12 data folder.

2 Save your workbook as Strength Control Chart. See Figure 12-15.

Figure 12-15

The Strength
workbook