” new toolbars and specific toolbar icons

9.1.A WHAT CAN AN ADD-IN DO?

Almost anything an imaginative software developer could create.

Usually, an Add-In provides functionality that is useful for a particular

type of analysis/industry ” statistics, finance, real estate, etc.

9.1.B WHY USE AN ADD-IN?

The Add-In could have its base code written in software languages like C,

C++, FORTRAN, Pascal, etc. This is important because some algorithms

and operations (like simulations) operate best when written in a specific

language. Therefore, the developer uses the best language/tool to create

the functionality and then packages this inside an Add-In.

ADD“INS INSTALLED WITH EXCEL

9.2

Some Add“Ins are available in the Microsoft Office CD“ROM and are

installed (but not activated10) along with Excel. I show the use of three

Add“ins.

10 Figure 540 and Figure 542 show how to activate the Add-ins

161

Statistical Analysis with Excel

OTHER ADD-INS

9.3

Many commercially sold Add-Ins can be almost like separate software just

needing Excel as the “host.” Two examples:

” Crystal Ball risk analysis software

” UNISTAT software for conducting advanced statistics and

econometrics from inside Excel

Hundreds of software companies construct Add-Ins. The greatest

contribution of this book, if I succeed in doing so, would be the opening of

this massive potential functionality to Excel users.

THE STATISTICS ADD-IN

9.4

The Analysis ToolPak Add-In that ships with Excel can conduct several

procedures including descriptives, regression, ANOVA, F-test, correlation,

T-tests, moving average, and histogram. Let us learn how to use this

“Add-In.”

9.4.A CHOOSING THE ADD-INS

Choose the menu option TOOLS/ADD-INS. You will see several Add-Ins

as shown in Figure 140. (You may not see all the Add“Ins shown in the

next two figures.)

162

Chapter 9: Add-ins: Enhancing Excel

Figure 140: Selecting an Add-In

Figure 141: In Excel XP, the Add-Ins dialog provides access to “Automation.” This topic is

beyond the scope of this book.

You need the “Analysis ToolPak Add-Ins.” Select ” by clicking on it ”

the box to the left of these Add-Ins (shown in Figure 142). Execute the

dialog by clicking on the button OK and wait for some time while the Add-

Ins are “loaded” or “registered” with Excel. An Add-In has to be

loaded/registered before it is available for use. The Add-In remains

loaded across sessions. It is only “unloaded” when you select the option

163

Statistical Analysis with Excel

TOOLS/ADD-INS and deselect the Add-In11.

Figure 142: The Add-In pair for data analysis

You have activated the “Analysis ToolPak.” At the bottom of the menu

TOOLS, you will see the option “DATA ANALYSIS the bottom” this

option was not there before you accessed the Add-In. (This is illustrated

in Figure 143.)

The statistical procedures are accessed through this new option.

Note:

Usually Add-Ins expose their functionality by creating new menu