This module provides a brief overview of predictive modeling problems, illustrating their broad applications. It then focuses on the simplest form of predictive models: simple linear regression. The module follows a graphical approach to illustrate the structure of a simple linear regression model, the intuition for Ordinary Least Squares, and related concepts. Finally, we demonstrate how to use various Excel tools, including trendlines, the Regression tool, and the Trend() function, to fit a simple linear regression model and use it to form predictions.

Building on Week 1, in this week we introduce multiple linear regression and its broad applications. Then, we cover how to fit a multiple linear regression model using Excel’s Regression tool and Trend() function and use the resulting model for predictions. The module further discusses the overfitting/underfitting problems and the basic principles of a good regression model. The module also introduces one approach for selecting a good model: backward elimination that can be implemented in Excel.

In this week, we will learn how to prepare a dataset for predictive modeling and introduce Excel tools that can be leveraged to fulfill this goal. We will discuss different types of variables and how categorical, string, and datetime values may be leveraged in predictive modeling. Furthermore, we will discuss the intuition for including high-order and interaction variables in regression models, the issue of multicollinearity, and how to handle missing values. We will also introduce several handy Excel tools for data handling and exploration, including Pivot Table, IF() function, VLOOKUP function, and relative reference.

This module focuses on a special subset of predictive modeling: time series forecasting. We discuss the nature of time-series data and the structure of time series forecasting problems. We then introduce a host of time series models for stationary data and data with trends and seasonality, with a focus on techniques that are easily implemented within Excel, including moving average, exponential smoothing, double moving average, Holt’s method, and Holt-Winters’ method. The module also covers linear-regression-based forecasting and a composite forecasting technique for boosting accuracy.