6. Principal Components Analysis
In This Chapter
With principal components analysis we move beyond the types of statistical analysis that you can design using Excel’s built-in worksheet functions. When it’s a matter of basic descriptive statistics, or inferential tests including t-tests and the analysis of variance and covariance, regression analysis, and logistic regression, you don’t have to look further in Excel than worksheet functions such as AVERAGE( ), DEVSQ( ), LINEST( ), F.DIST.RT( ), and EXP( ) to assemble a complete analysis.
But when it comes to analysis that involves digging out underlying variables that are observed only indirectly, ...