Data Analysis with Microsoft Excel: Updated for Office 2007

514 Statistical Methods

The following range names have been defined for the workbook in

Figure 12-18:

Table 12-8 The Powder Workbook

Range Name Range Description

Time A2:A352 The time of the sample

Head_01 B2:B352 Quantity of powder from head 1

Head_02 C2:C352 Quantity of powder from head 2

( ( (

Head_24 Y2:Y352 Quantity of powder from head 24

Now generate the Pareto chart using StatPlus.

To create the Pareto chart:

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

2 Click the Values in separate columns option button.

Figure 12-18

The Powder

workbook