Data Analysis with Microsoft Excel: Updated for Office 2007

508 Statistical Methods

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

Table 12-6 The Steel Workbook

Range Name Range Description

Subgroup A2:A21 The subgroup number

N B2:B21 The size of the subgroup

Defects C2:C21 The number of defects in the subgroup

Percentage D2:D21 The fraction of defects in the subgroup

To create a P chart for the percentage of steel rod defects:

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

2 Click the Proportions button and select Percentage from the list of

range names. Click OK.

3 Type 200 in the Sample Size box, because each subgroup has the

same sample size.

4 Send the output to a new chart sheet named P Chart.

5 Click OK.

Excel generates the P chart shown in Figure 12-14.

Figure 12-14

P chart

of the

percentage

of steel

rod defects