This article describes how to access the data analysis tools in Microsoft Excel for Mac.
About data analysis toolsExcel for Mac provides a set of data analysis tools called the Analysis ToolPak. You can use these tools to save steps when you develop complex statistical or engineering analyses. You provide the data and parameters for each analysis. The tools use the appropriate statistical or engineering macro functions, and then display the results in an output table. Some tools generate charts and also output tables. To use these tools, you must be familiar with the specific area of statistics or engineering for which you want to develop analyses.
Access the data analysis tools
To access the data analysis tools, follow these steps:
- On the Tools menu, click Data Analysis.
Note If the Data Analysis command is unavailable on the Tools menu, see the "Install and load the Analysis ToolPak" section.
- In the Analysis Tools box, click the tool you want to use.
- Enter the input range and the output range, and then select the options that you want.
Install and load the Analysis ToolPak
If the Data Analysis command is unavailable on the Tools menu, you must install and load the Analysis ToolPak. To do this, follow these steps:
- On the Tools menu, click Add-Ins.
- Click to select the Analysis ToolPak check box, and then click OK.
276444 What's installed with the Office 2001 Value Pack
Article ID: 914208 - Last Review: Mar 9, 2012 - Revision: 1