Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1
532

Bin Range


Enter an optional range of values that defi nes the boundaries of the bins.

Labels


Indicate whether the fi rst row (or column) includes header information.

Pareto (sorted histogram)


Click to create a Pareto chart sorted by descending order of frequency.

Cumulative Percentage


Click to calculate the cumulative percentages.

Chart Output


Click to create a histogram of frequency versus bin values.
See “Output Options” at the beginning of this section for information on
the output storage options.

Moving Average

The Moving Average command creates a column of moving averages over
the preceding observations for an interval specifi ed by the user.
Free download pdf