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