Using the Analysis Toolpak Data Analysis Tools

If you performed a complete installation of Excel, the Analysis ToolPak is available each time you start Excel. You can access the tools installed with the Analysis ToolPak by choosing Tools, Data Analysis to display the dialog box shown in Figure 17-6.

The Data Analysis dialog box presents a list of tools.

Figure 17-6. The Data Analysis dialog box presents a list of tools.

Using the Descriptive Statistics Tool

The Descriptive Statistics tool provides a table of statistics for one or more sets of input values. For each variable in the input range, this tool's output range includes a detailed list of statistics, as shown in Figure 17-7.

Figure 17-7. We generated ...

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.