O'Reilly logo

Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables, 4th Edition by Paul McFedries

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

Chapter 11

Working with the Analysis ToolPak

Load the Analysis ToolPak

You can get access to a number of powerful statistical analysis tools by loading the Analysis ToolPak add-in. The Analysis ToolPak consists of 19 statistical tools that calculate statistical measures such as correlation, regression, rank and percentile, covariance, and moving averages. You can also use the analysis tools to generate descriptive statistics (such as median, mode, and standard deviation), random numbers, and histograms.

Many of these tools have equivalent worksheet functions. For example, you can calculate correlation using the CORREL function, rank and percentile using the RANK and PERCENTILE functions, and so on. Each Analysis ToolPak tool also displays a ...

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