Chapter 9 Summary
Chapter 9 focuses on advanced techniques for forecasting
revenues using dummy variables in regression analysis. The chapter builds on
the previous chapter's case study of H&S, a fictional public utility
company.
The chapter begins by outlining learning objectives, which
include understanding the concept of dummy variables, incorporating and
interpreting additive dummy variables and interaction terms in regression
models, and using domain-specific expertise to suggest useful dummy variables.
It then introduces the concept of dummy variables as a way to incorporate
non-numeric information into regression models, using the example of iPhone
release dates to illustrate how such variables can capture seasonal patterns in
sales data.
The document provides step-by-step instructions on using Alteryx software to create dummy variables for winter and summer months, and then incorporates these variables into regression models in various ways. It covers concepts such as the effect of dummy variables on model intercepts and slopes, and the use of interaction terms. The chapter includes several in-chapter practice problems and ends with takeaway points emphasizing the importance of leveraging domain-specific knowledge to create meaningful categorical variables that can improve model predictive accuracy. It also includes an appendix with instructions on using the R Tool in Alteryx to create more advanced visualizations of regression models with multiple trend lines.