Chapter 37: Analyzing Data with the Analysis ToolPak

In This Chapter

Getting an overview of the Analysis ToolPak

Using the Analysis ToolPak

Meeting the Analysis ToolPak tools

Although Excel was designed primarily for business users, people in other disciplines, including education, research, statistics, and engineering, also use the software. One way Excel addresses these nonbusiness users is with its Analysis ToolPak add-in. However, many features in the Analysis ToolPak are valuable for business applications as well.

The Analysis ToolPak: An Overview

The Analysis ToolPak is an add-in that provides analytical capability that normally isn't available in Excel.

These analysis tools offer many features that may be useful to those in the scientific, engineering, and educational communities — not to mention business users whose needs extend beyond the normal spreadsheet fare.

This section provides a quick overview of the types of analyses that you can perform with the Analysis ToolPak. This chapter covers each of the following tools:

• Analysis of variance (three types)

• Correlation

• Covariance

• Descriptive statistics

• Exponential smoothing

• F-Test

• Fourier analysis

• Histogram

• Moving average

• Random number generation

• Rank and percentile

• Regression

• Sampling

• T-Test (three types)

• Z-Test

As you can see, the Analysis ToolPak add-in brings a great deal of functionality to Excel. These procedures have limitations, however. In some cases, you may prefer to create your ...

Get Excel 2013 Bible now with the O’Reilly learning platform.

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