Data Analysis with Microsoft Excel: Updated for Office 2007

Excel Reference 567

Pareto Chart

The StatPlus>QC Charts>Pareto Chart command creates a Pareto chart of

quality-control data. Data values can be arranged in separate columns or

within a single column along with a column of category values. The user

specifi es conditions for a defective value. The Pareto chart can be sent to an

embedded chart on a worksheet or to its own chart sheet.

Descriptive Statistics

Frequency Table

The StatPlus>Descriptive Statistics>Frequency Table command creates a

table containing frequency, cumulative frequency, percentage, and cumula-

tive percentage. The frequency table can either be displayed by discrete val-

ues in the data column or by bin values. If bin values are used, the user can

specify how the data are counted relative to the placement of the bins. The

frequency table can also be broken down by the values of a By variable.