6. Principal Components Analysis

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, ...

Get R for Microsoft® Excel Users: Making the Transition for Statistical Analysis now with O’Reilly online learning.

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