8. Principal Components Analysis

In This Chapter:

The Notion of a Principal Component

Using the Principal Components Add-In

Principal Components Distinguished from Factor Analysis

Too many variables, and too many people or things, cause thorny problems in data analysis, and the issue is not simply the availability of sufficient computing power to handle all that data. It’s extremely difficult to reach sensible conclusions—let alone communicate them—when you’re awash in hundreds of distinct variables and tens of thousands of individual observations.

So, statisticians and theorists, beginning around 1900, started searching for methods of reducing all those variables to a smaller, more manageable set. Their aim was to reduce the information to ...

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.