Weighted Moving Average Technique - 3-Period Weighted...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Weighted Moving Average Technique for Stationary Models Situation: Model has been determined to be stationary for 20 periods Required: Forecast for the next 4 periods (21-24) using a
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 3-Period Weighted Moving Average with weights .6, .3, .1 respectively 1. In D5 Enter =.6*B4+.3*B3+.1*B2 2. Drag D5 to D6:D22 4. Drag D23 to D24:D25 3. In D23 Enter =D22...
View Full Document

Ask a homework question - tutors are online