Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 12 Quality Control 505

The range names have been defi ned for the workbook in Table 12-5.

Table 12-5 The Accidents Workbook

Range Name Range Description

Month A2:A45 The month

Accidents B2:B45 The number of accidents that month

To create a C chart for accidents at this fi rm:

1 Click QC Charts from the StatPlus menu and then click C Chart.

2 Select Accidents as the Data Values variable.

3 Direct the output to a new chart sheet named C Chart.

4 Click OK. Excel generates the chart shown in Figure 12-12.

Figure 12-11
The Accidents
workbook