O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required