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

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

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