Forecasting Syllabus

Forecasting

This course covers Forecasting and consists of 11 topics.

Trend and Seasonality – In this video we show how to estimate the trend and seasonal indices for monthly US airline miles.
Ratio to Moving Average Part One – In this video we show how the Ratio to Moving Average Method is used to forecast time series in the presence of Trend and Seasonality.
Ratio to Moving Average Part Two – In this video we conclude our discussion of the Ratio to Moving Average Method.
Winter’s Method of Forecasting Introduction – In this video we show how Winter’s exponential smoothing method can be used to forecast in the presence of Trend and seasonality.
Winter’s Method – Equations – This video is a continuation of the Winter’s Method of forecasting.
Winter’s Method – Initialization – This video is a continuation of the Winter’s Method of forecasting.
Winter’s Method – Implementation – This video is the implementation and conclusion of the Winter’s Method of forecasting.
Credit Union Forecasting Part One – In this video we show how to incorporate seasonality and special factors in a forecast of a bank’s daily customer count.
Credit Union Forecasting Part Two – In this video we finish our discussion of forecasting daily customer count at a bank.
Predicting Software Sales – In this video we show how to use the Excel Solver to determine how seasonality, PC sales, and launch dates affect software sales.
Forecasting Candy Bar Sales – In this video we show how to use the Solver to determine how our price, the competitor’s price, and whether the product is on display influences candy bar sales.
Learn More