Chapter 33: Analyzing Data with the Analysis ToolPak
3333
these labels in the tables that it produces. Most tools also provide different output options
that you can select, based on your needs.FIGURE 33.1
Select your tool from the Data Analysis dialog box.The Analysis ToolPak isn’t consistent in the way that it generates its output. In some cases, the procedures use for-
mulas, so you can change your data, and the results update automatically. For other procedures, Excel stores the
results as values, so if you change your data, the results don’t reflect your changes.
Introducing the Analysis ToolPak Tools
This section describes each tool in the Analysis ToolPak and provides an example. We don’t
describe every available option in these procedures. If you need to use the advanced analy-
sis tools, you probably already know how to use most of the options not covered here.Before you use any of these tools, read the appropriate section in Excel’s Help system.This book’s website at http://www.wiley.com/go/excel2019bible contains a workbook that shows
output from all of the tools discussed in this section. The file is named atp examples.xlsx. This
workbook also contains some alternative formula-based solutions that are sometimes better than using
the Analysis ToolPak.Analysis of variance
Analysis of variance (sometimes abbreviated as anova) is a statistical test that determines
whether two or more samples were drawn from the same population. Using tools in the
Analysis ToolPak, you can perform three types of analysis of variance:Single-factor A one-way analysis of variance, with only one sample for each group of data