10. Varimax Factor Rotation in Excel

In This Chapter:

Getting to a Simple Structure

Structure of Principal Components and Factors

Chapter 8, “Principal Components Analysis,” showed how principal components analysis (PCA) can be used to derive, or extract, underlying and unmeasured components that are expressed overtly in measured variables.

The analysis in Chapter 8 used a small data set, with only three variables and just a few records, to demonstrate the techniques and steps involved in PCA. Excel calculated a correlation matrix from that data set; the matrix was then run through a freeware addin which identified three principal components.

With three original variables, you can’t extract more than three components. If you do extract (and ...

Get Predictive Analytics: Microsoft® Excel now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.