More Predictive Analytics: Microsoft Excel

Introduction

In 2011, I wrote Predictive Analytics: Microsoft Excel. The book went into techniques that are heavily used in the field of predictive analytics but that we don’t necessarily think of as “predictive.”

Those techniques included logistic regression, a technique that’s often used in place of least squares regression when the outcome variable is measured with categories; principal components analysis, which groups not records but variables into mutually independent components of related variables; and factor rotation, a technique that helps make the interpretation of principal components more straightforward.

These topics are important ones in predictive analytics, and I personally find them intrinsically interesting and fun to write ...