Using Data Analysis Tools

Excel provides a collection of statistical functions and macros to analyze data in the Analysis ToolPak . The Analysis Toolpak is an add-in program, which may need to be loaded using the Add-In command on the Tools menu. The tools can be used for a variety of scientific and engineering purposes and for general statistical analysis. You provide the data, and the tools use the appropriate functions to determine the result. To use these tools effectively, you need to be familiar with the area of statistics or engineering that you want to develop an analysis for. You can view a list of all the tools in the Data Analysis dialog box. For additional information about each tool, see the online Help.

Use Data Analysis Tools

Click the Tools menu, and then click Data Analysis.

Click the analysis tool you want to use.

Click OK.

Select or enter the input range (a single row or column). You can use the Collapse Dialog box button to select a range and the Expand Dialog box to return.

Select or enter the output range. You can use the Collapse Dialog box button to select a range and the Expand Dialog box to return.

Specify any additional tool specific options you want.

Click OK.