Microsoft KB Archive/914208

= How to access the data analysis tools in Excel for Mac =

Article ID: 914208

Article Last Modified on 4/11/2006

-

APPLIES TO


 * Microsoft Excel 2001 for Mac
 * Microsoft Excel X for Mac

-





SUMMARY
This article describes how to access the data analysis tools in Microsoft Excel for Mac.



About data analysis tools
Excel 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:
 * 1) On the Tools menu, click Data Analysis.

Note If the Data Analysis command is unavailable on the Tools menu, see the &quot;Install and load the Analysis ToolPak&quot; section.
 * 1) In the Analysis Tools box, click the tool you want to use.
 * 2) 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:
 * 1) On the Tools menu, click Add-Ins.
 * 2) Click to select the Analysis ToolPak check box, and then click OK.

If the Analysis ToolPak check box is not listed in the Add-Ins dialog box, you must use the Value Pack Installer to install the Analysis ToolPak. For more information about how to install Value Pack components, click the following article number to view the article in the Microsoft Knowledge Base:

276444 What's installed with the Office 2001 Value Pack

For more information about the Analysis ToolPak, visit the following Microsoft Web site:

http://www.microsoft.com/mac/resources/resources.aspx?pid=resourcekits&rk=officex&article=/mac/officex/ork/Configure_Excel.xml#Creating_Addins

Additional query words: XL2001 XLX add-in

Keywords: kbhowto kbexpertisebeginner KB914208

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.