Skip to Main Content
Microsoft Excel 365 Bible
book

Microsoft Excel 365 Bible

by Michael Alexander, Dick Kusleika
March 2022
Beginner to intermediate content levelBeginner to intermediate
1072 pages
28h 16m
English
Wiley
Content preview from Microsoft Excel 365 Bible

CHAPTER 30Analyzing Data with the Analysis ToolPak

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.

The following list is of the types of analyses that you can perform with the Analysis ToolPak. We cover each of these tools in this chapter.

  • 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 additional functionality to Excel. These procedures have limitations, however. In some cases, you may prefer to create your own formulas to do some calculations. ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel 2019 Bible

Excel 2019 Bible

Michael Alexander, Richard Kusleika, John Walkenbach

Publisher Resources

ISBN: 9781119835103Purchase Link