Time Series Forecasting with Multiple Regression

In this video, I demonstrate how to do time series forecasting, accounting for seasonality using multiple regression. I use dummy variables to account for seasonal effects. I use MS Excel Data Analysis pack and use the regression command. After completing the regression analysis, I demonstrate how to use the estimated regression function to forecast into the future and account for seasonality. I finally show how to calculate the mean absolute error (MAE).