Business Analytics: Forecasting with Trended Baseline Smoothing
1h 1mAdvanced2018-10-05
Authors

Conrad Carlberg
Writer and Consultant in Quantitative and Statistical Analysis
Course details
Simple exponential smoothing (SES) incorporates most of the elements used in the smoothing approach to forecasting, such as a level smoothing constant, self-correction, and the gradual weakening of the influence of older observations on new forecasts. But SES works poorly with baselines that display either trends or seasonality. The trended time series is one step up in complexity from the stationary time series analyzed by SES—its baseline trends up or down. The use of exponential smoothing with a trended baseline is often called Holt's method, and this course was designed to equip you with this technique. Here, instructor Conrad Carlberg explains how to use Holt's method to create forecasts in R that deal with trends in a baseline.
Learning objectives
Assembling the forecast equation for a trended baseline
Simple exponential smoothing with a stationary baseline
Using R for simple exponential smoothing
Optimizing the level and trend constants via Solver
Using R to forecast a trended series
Learning objectives
Assembling the forecast equation for a trended baseline
Simple exponential smoothing with a stationary baseline
Using R for simple exponential smoothing
Optimizing the level and trend constants via Solver
Using R to forecast a trended series
Skills covered
RBusiness IntelligenceMicrosoft ExcelData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceMicrosoftDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Why trended baseline smoothing will help your regression
- 02 - Software setup
1. Simple Exponential Smoothing (SES) and Trend
- 03 - A review of SES with a stationary baseline
- 04 - Problems using SES with a trended baseline
- 05 - Forecasting differences
- 06 - Using R for SES
- 07 - Using ARIMA(0,1,1) for SES
2. Understanding the Forecast Equation
- 08 - Distinguish between a level component and a trend component
- 09 - The trend constant compared to the level constant
- 10 - Compare smoothing and error correction forms
- 11 - Initialize the trend forecasts
- 12 - Build the full worksheet and optimize with Solver
3. Running the Trend Forecast Analysis in R
- 13 - Prepare for analysis with R
- 14 - Run and interpret the analysis in R
Conclusion
- 15 - Next steps