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.
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
