12 Varimax Factor Rotation in Excel
Chapter 10, “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 10 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 add-in that 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, 2nd Edition 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.
