From the course: Business Analytics: Forecasting with Trended Baseline Smoothing
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Compare smoothing and error correction forms
From the course: Business Analytics: Forecasting with Trended Baseline Smoothing
Compare smoothing and error correction forms
- [Instructor] Here's the smoothing form of the forecast equation for a baseline's level. L hat sub T plus one equals alpha times L sub T plus one minus alpha times L hat sub T. Using the smoothing form, the forecast level for time T plus one is alpha times the actual observation at time T, symbolized by L sub T, plus one minus alpha plus the forecast level for time T symbolized by L hat sub T. For a trended baseline, we also need to forecast the trend, also termed the slope. The smoothing form of the forecast equation for the baseline's trend has the same pattern, but uses a different smoothing constant. The trend's smoothing constant is often termed gamma. S hat sub T plus one equals gamma S sub T plus one minus gamma S hat sub T. The forecast trend for time T plus one is gamma times the actual slope at time T, symbolized by S sub T, plus one minus gamma times the forecast slope for time T, symbolized by S hat sub T. In each case, using the smoothing form, the forecast is the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
(Locked)
Distinguish between a level component and a trend component3m 28s
-
(Locked)
The trend constant compared to the level constant3m 25s
-
(Locked)
Compare smoothing and error correction forms6m 30s
-
(Locked)
Initialize the trend forecasts5m 2s
-
(Locked)
Build the full worksheet and optimize with Solver6m 50s
-
(Locked)
-
-