Installing the Analysis ToolPak

When you install Excel, the most commonly used functions are installed as well. However, there are additional functions available in the Analysis ToolPak, a set of add-in tools and functions designed for data analysis. This add-in includes a number of excellent worksheet functions that become available through the Insert Function dialog box, and some sophisticated, macro-based, statistical analysis tools.

To see if you have the Analysis ToolPak installed, go to the Tools menu. If the Data Analysis command is there (you might have to double-click the menu name to expand it to its full size), then you're good to go. The Data Analysis dialog box is shown on the right in Figure 13-4. If the Data Analysis command isn't ...

Get Microsoft® Office Excel 2003 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.