Data Analysis with Microsoft Excel: Updated for Office 2007

Excel Reference 533

Input Range

Enter the range of worksheet data for which you want to calculate the mov-

ing average. The range must be a single row or a single column containing

four or more cells of data.

Labels in First Row

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

Interval

Enter the number of cells you want to include in the moving average. The

default value is three.

Chart Output

Click to create a chart of observed and forecasted values.

Standard Errors

Click to create a column of standard errors to the right of the forecasted

column.

Output options

You can only send output from this command to a cell on the current

worksheet.

Random Number Generation

The Random Number Generation command creates columns of random

numbers following a user-specifi ed distribution.