Where to find Data Analysis ToolPak and Solver. If the add-ins are available in the Excel for Mac installation that you are using, follow these steps to locate them: Start Excel for Mac. Click Tools, and then click Add-Ins. Click the Data Analysis ToolPak or Solver option to enable it. Then, click OK. This tutorial will demonstrate how to install the Data Analysis Toolpak add-in in Excel for both Mac and PC. Click on the File tab on the top left, then select Options. Click Add-ins. Where it says Manage at the bottom, select Excel Add-ins from the drop-down menu and click Go.
This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.
Microsoft Excel has a built-in suite of tools that perform regressionanalysis and calculate statistical data. These tools are generallyinstalled but are not active. To activate them, follow theappropriate instructions below.
Excel 2010 and 2007 for Windows
From the File tab (2010) or Office Buttonmenu (2007), select Options or Excel Options.
Click Add-ins, and then in the 'Manage' box, selectExcel Add-ins. Click Go.
In the 'Add-Ins available' box, check Analysis ToolPakand Analysis ToolPak - VBA, and then click OK.
If you see a prompt stating that the Analysis Toolpak is notcurrently installed on your computer, click Yes to installit. This will create a 'Data Analysis' section within theData tab.
Excel 2011 for Mac
To activate statistical analysis tools, click Tools,and then Add-ins. In the dialog box that pops up, chooseSolver.Xlam.
To access the tools, click Tools and then Solver.
Excel 2008 for Mac
This functionality was removed in Office 2008. Some third partyadd-ins (such as those linked below) attempt to provide similarfunctionality; however, they may not be free.