10. Varimax Factor Rotation in Excel
In This Chapter:
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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
