Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1

30 Excel


Unloading an Add-In


If at any time, you want to unload the Data Analysis ToolPak or StatPlus,
you can do so by returning to the list of available add-ins dialog box shown
in Figure 1-19, and then deselecting the checkbox for the specifi c add-in.
Unloading an add-in is like closing a workbook; it does not affect the add-in
fi le. If you want to use the add-in again, simply reopen the Add-Ins dialog
box and reselect the checkbox. If you exit Excel with an add-in loaded, Excel
will assume that you want to run the add-in the next time you run Excel, so
it will load it for you automatically.

Features of StatPlus


StatPlus has several special features that you should be aware of. These
include modules and hidden data.

Using StatPlus Modules


StatPlus is made up of a series of add-in fi les, called modules. Each module
handles a specifi c statistical task, such as creating a quality control chart
or selecting a random sample of data. StatPlus will load the modules you
need on demand (this way, you do not have to use up more system memory
than needed). After using StatPlus for a while, you may have a great many
modules loaded. If you want to reduce this number, you can view the list of
currently opened modules and unload those you’re no longer using.

To view a list of StatPlus modules:

1 Click Unload Modules from the StatPlus menu on the Add-Ins tab.
StatPlus displays a list of loaded modules. A sample list is shown in
Figure 1-23. Yours will be different.
Free download pdf