Enter the cell reference for the range of data you want to analyze. The range must consist of a single column that contains four or more cells of data.
Select if the first row of your input range contains labels. Clear this check box if your input range has no labels; Microsoft Excel generates appropriate data labels for the output table.
Enter the number of values you want to include in the moving average. The default interval is 3.
Enter the reference for the upper-left cell of the output table. If you select the Standard Errors check box, Excel generates a two-column output table with standard error values in the right column. If there are insufficient historical values to project a forecast or calculate a standard error, Excel returns the #N/A error value.
The output range must be on the same worksheet as the data used in the input range. For this reason, the New Worksheet Ply and New Workbook options are unavailable.
Select to generate an embedded histogram chart with the output table.
Select if you want to include a column that contains standard error values in the output table. Clear if you want a single-column output table without standard error values.