• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Using the Analysis ToolPak

Excel includes a set of data analysis tools, called the Analysis ToolPak, that you can use to develop complex statistical or engineering analyses. Although this book is not geared toward statisticians, engineers, mathematicians, or academic researchers, this section will describe some of the functions in the Analysis ToolPak that are very helpful for analyzing business data. Because the Analysis ToolPak is not very widely understood, this section details the components of common Analysis ToolPak dialog boxes and demonstrates how to use these dialog boxes in common data analysis scenarios. To use the Analysis ToolPak, simply click Data Analysis on the Tools menu. (See the following if the command is not on the menu.) Click a tool in the list, and then complete the information in the resulting dialog box to perform the analysis.

Installing the Analysis ToolPak

If the Data Analysis command doesn’t appear on the Tools menu, click Add-Ins on the Tools menu, select the Analysis ToolPak check box, and then click OK. If the Analysis ToolPak check box is not visible, be sure you have your original Microsoft Office or Excel installation media handy, double-click the Add/Remove Programs icon in Control Panel, and do one of the following:

For Microsoft Windows 2000, Windows Millennium Edition, and Windows XP:

  • If you installed Excel as part of Microsoft Office, click Microsoft Office in the Currently Installed Programs box and then click the Change button.

  • If you installed Excel individually, click the Excel program entry in the Currently Installed Programs box and then click the Change button.

For Microsoft Windows 98 and Windows NT 4.0:

  • If you installed Excel as part of Microsoft Office, click Microsoft Office on the Install/Uninstall tab and then click the Add/Remove button.

  • If you installed Excel individually, click the Excel program entry on the Install/Uninstall tab and then click the Add/Remove button.

Follow the instructions on the screen. The Analysis ToolPak can be found by expanding the Microsoft Excel for Windows node and then expanding the Add-Ins node.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint