O'Reilly logo

Predictive Analytics: Microsoft® Excel by Conrad Carlberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required