Excel 2019 Bible

755

C H A P T E R

33

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

A

lthough Excel was designed primarily for business users, people in other disciplines, includ-

ing 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 fea-

tures 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 nor-

mal 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
Excel® 2019 Bible, First Edition. Michael Alexander, Dick Kusleika and John Walkenbach.
© 2019 John Wiley & Sons, Inc. Published 2019 by John Wiley & Sons, Inc.