Business Analytics: Forecasting with Exponential Smoothing
1h 5mAdvanced2018-02-12
Authors

Conrad Carlberg
Writer and Consultant in Quantitative and Statistical Analysis
Course details
Exponential smoothing is a term for a set of straightforward forecasting procedures that apply self-correction. Each forecast comprises two components. It's a weighted average of the prior forecast, plus an adjustment that would have made the prior forecast more accurate. Smoothing—like most credible approaches to forecasting—requires a baseline of observations, in sequence, to work properly. Weekly revenues and daily hospital admissions are typical examples. Several versions of exponential smoothing exist, each corresponding to a type of baseline. In this course, Conrad Carlberg provides an introduction to simple exponential smoothing, diving into the basic idea behind it, and explaining how to assemble the forecast equation and optimize forecasts.
Learning objectives
Demonstrate how to evaluate a baseline using a correlogram.
Identify the drawbacks of using Microsoft Excel’s exponential smoothing tool.
Explain the different ways you can initialize the first forecast.
Compare the average raw deviation forecast with the mean absolute deviation forecast method.
Break down the reasons to use R instead of Excel for exponential smoothing.
Learning objectives
Demonstrate how to evaluate a baseline using a correlogram.
Identify the drawbacks of using Microsoft Excel’s exponential smoothing tool.
Explain the different ways you can initialize the first forecast.
Compare the average raw deviation forecast with the mean absolute deviation forecast method.
Break down the reasons to use R instead of Excel for exponential smoothing.
Skills covered
Business AnalyticsData ScienceDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Welcome
1. The Idea Behind Exponential Smoothing
- 02 - Self-correcting forecasts
- 03 - From error correction to smoothing
- 04 - Exponentially declining influence of observations
- 05 - Identify the appropriate baseline
2. The Forecasting Equation
- 06 - Dissect the error correction form
- 07 - Dissect the smoothing form
- 08 - Exponential smoothing tool
- 09 - Initialize the forecasts
3. Measuring Forecast Accuracy
- 10 - The absolute deviation approach
- 11 - The least squares approach
4. Optimizing Forecasts
- 12 - Solver
- 13 - Set up the smoothing formula for Solver
- 14 - Solution in R
Conclusion
- 15 - Next steps