Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 1 Getting Started with Excel 31

If you want to unload all of the modules, click the Remove All

checkbox. If you want to remove individual modules, click the

checkbox in front of the module name. Once you unload a module,

it’s removed from Excel, but it will be automatically reloaded the

next time you try to use a command supported by the module.

2 Click OK to close the Remove StatPlus Modules dialog box.

Hidden Data

Several StatPlus commands employ hidden worksheets. A hidden work-

sheet is a worksheet in your workbook that is hidden from view. Hidden

worksheets are used in creating histograms, boxplots, and normal probabil-

ity plots (don’t worry, you’ll learn about these topics in later chapters). You

can view these hidden worksheets if you need to troubleshoot a problem

with one of these charts. There are three hidden worksheet commands in

StatPlus (see Table 1-5; they are available in the General Utilities submenu).

Table 1-5 Hidden Worksheet Commands

Command Description

View hidden data Unhides a hidden StatPlus worksheet

Rehide hidden data Rehides a StatPlus worksheet

Remove unlinked hidden data Removes extraneous data, like hidden data for a

deleted chart, from the hidden worksheet

Figure 1-23
Viewing StatPlus

modules

click the checkbox to

unload the module

total size of all loaded

modules