Data Analysis with Microsoft Excel: Updated for Office 2007

28 Excel

Loading the Data Analysis ToolPak

Now that you’ve seen how to load the StatPlus add-in, you can load the Data

Analysis ToolPak. Since the Data Analysis ToolPak comes with Excel, you

may need to have your Excel or Offi ce installation disks handy.

To load the Data Analysis ToolPak:

1 Click the Offi ce button and then click Excel Options. Click Add-

Ins from the Excel options dialog box and then click Go next to the

Manage Excel Add-Ins list box.

2 Click the checkbox for the Analysis ToolPak and click OK.

3 At this point, Excel may prompt you for the installation CD; if so,

insert the CD into your CD-ROM drive and follow the installation

instructions.

Add-Ins tab

StatPlus menu

commands

Figure 1-21

The StatPlus

menu