1.4 The Analysis ToolPak
You may need to install the Analysis ToolPak from the original Excel software if your computer does not have it.
1.4.1 Adding the Analysis ToolPak on a PC
With an Excel worksheet open:
- Click on
File
in the main menu. - Click on
Options
. - Click
Add-ins
(left side menu) to see if the ToolPak is listed in the Active Application Add-ins. If it is, the ToolPak is installed. If you do not see a listing for Analysis ToolPak in Active Application Add-ins, it may be under the list of inactive applications. IYou must install it from the original Excel installation source if you do not see it. - To install or activate it, click
Go
. - Check the box next to
Analysis ToolPak
. - Click
OK
.
![A dialog box showing Excel Options on a PC.](images/toolpak-pc1.png)
Figure 1.11: Excel Options on a PC.
![Dialog box showing Add-ins Options on a PC.](images/toolpak-pc2.png)
Figure 1.12: Add-ins Options on a PC.
1.4.2 Adding the Analysis ToolPak on a Mac
With an Excel worksheet open:
- Click on
Tools
in the main menu. - Click on
Add-ins
and see if theAnalysis ToolPak
is listed as an active application. If it is not, check the box next to it. - Click
OK
.
![A dialog box showing Excel Tools on a MAC.](images/toolpak_mac1.png)
Figure 1.13: Excel Tools on a MAC.
![A dialog box showing Add-ins Options on a MAC.](images/toolpak_mac2.png)
Figure 1.14: Add-ins Options on a MAC.