|
Purpose
The Moving Average procedure projects values in
the forecast period, based on the average value of the variable over a specific
number of preceding periods. A moving average provides trend information that a
simple average of all historical data would mask. Use this tool to forecast
sales, inventory, or other trends.
Preparations
Run
Statistics→Time Series/Forecasting→Moving
Average....
Results
Each forecast value is based on the following formula:
Fj =
 Aj / N
where
- N — is the number of prior
periods to include in the moving average
- Aj — is the actual value at time j
- Fj — is the forecasted value at time j
Standard deviations are showed in
the second column
Also, the diagram with forecasted
and actual values are showed.
|
