Introduction to a variety of useful statistical ideas and techniques - Improving the User Experience through Practical Data Analytics - page 42

FIGURE 1.27
Clicking on “Add-Ins.”
As soon as you click on “Add-Ins,” you get a menu as shown in Figure 1.28 . In
the igure, you see that there is a section of Active Application Add-ins and a section
of Inactive Application Add-ins (see dashed arrows in Figure 1.28 ).
The important application is “Analysis ToolPak” (see bent arrow). Initially, that
application will be under the INACTIVE Applications Add-ins, and listed irst on
that list (the applications are listed alphabetically). You need to simply highlight
“Analysis ToolPak” and then click on “Go” (see vertical fat arrow at bottom of Figure
1.28 ). This will give you the inal box—a small one—see Figure 1.29 . In Figure 1.28 ,
“Analysis ToolPak” is already in the ACTIVE Applications Add-ins section, but that
is only because the authors had previously activated it (many years ago!!).
In Figure 1.29 , you need to click on the irst entry, “Analysis ToolPak,” and then
click “OK.” In Figure 1.30 , you will then see “Data Analysis” on your Excel software
(see horizontal arrow), under the main menu item “Data” (see vertical arrow); “Data
Analysis” was not there (under “Data” or anywhere else) when you began this activa-
tion process.
At this point, Data Analysis is always present and ready to use. Any time you want
to use Data Analysis (which will be used frequently throughout several subsequent