Trend-Holt Technique - and Forecast for Period 21. 4. In D4...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Holt's Technique for Trend Models Situation: Model has been determined by regression (low p-value for β 1 ) to have linear trend over 20 periods Required: Forecast for the next 4 periods (21-24) using Holt's technique using α = .2 to forecast the level; γ = .4 to forecast the trend. 1. Input initial Values 1. In D3 Enter =B3 2. In E3 Enter =B3-B2 3. In F4 Enter =D3+E3
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2. Enter Level and Trend Formulas for Period 3 3. Determine Levels, Trends and Forecasts for Periods 4-20
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: and Forecast for Period 21. 4. In D4 Enter =.2*B4 +.8*F4 Value for Period 3 1- Forecast for Period 3 5. In E4 Enter =.4*(D4-D3) +.6*E3 Difference in Levels 3 and 2 1-Trend Estimate for Period 2 6. Highlight D4:F4 Drag all to 7. Highlight F21 Drag to F21 4. Determine Forecasts for Periods 22-24 8. In F23 Enter =F22+ Previous Forecast Last Estimate for the Trend 9. Highlight F23...
View Full Document

Page1 / 3

Trend-Holt Technique - and Forecast for Period 21. 4. In D4...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online