Excel 2010 Bible

781

CHAPTER

Analyzing Data with

the Analysis ToolPak

IN THIS CHAPTER

The Analysis ToolPak: An

overview

Using the Analysis ToolPak

Meeting the Analysis ToolPak

tools

A

lthough Excel was designed primarily for business users, people in
other disciplines, including education, research, statistics, and engi-
neering, use it. One way how 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.

Note
Prior to Excel 2007, the Analysis ToolPak add-in included many additional
worksheet functions. These worksheet functions are built into Excel and no
longer require the Analysis ToolPak add-in. n

These analysis tools offer many features that may be useful to those in the
scientific, engineering, and educational communities — not to mention busi-
ness 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:

l Analysis of variance (three types)

l (^) Correlation