Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 12 Quality Control 511

The range names are shown in Table 12-7.

Table 12-7 The Strength Workbook

Range Name Range Description

Obs A2:A26 The observation number

Strength B2:B26 The tensile strength of the sample,

measured to the nearest 500 pounds in

1,000-pound units

To create an Individuals chart for the steel samples:

1 Click QC Charts from the StatPlus menu and click Individuals

Chart.

2 Select Strength for the Data Values variable.

3 Send the output to a new chart sheet named I-Chart.

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

Figure 12-16
The individuals
chart for tensile
strength samples

upward trend

may indicate a

process that is

not in control