ARCHIVED: In Microsoft Excel, how do I perform statistical analysis?

This content has been archived, and is no longer maintained by Indiana University. Resources linked from this page may no longer be available or reliable.

Microsoft Excel has a built-in suite of tools that perform regression analysis and calculate statistical data. These tools are generally installed but are not active. To activate them, follow the appropriate instructions below.

Excel 2010 and 2007 for Windows

  1. From the File tab (2010) or Office Button menu (2007), select Options or Excel Options.
  2. Click Add-ins, and then in the "Manage" box, select Excel Add-ins. Click Go.
  3. In the "Add-Ins available" box, check Analysis ToolPak and Analysis ToolPak - VBA, and then click OK.
  4. If you see a prompt stating that the Analysis Toolpak is not currently installed on your computer, click Yes to install it. This will create a "Data Analysis" section within the Data tab.

Excel 2011 for Mac

To activate statistical analysis tools, click Tools, and then Add-ins. In the dialog box that pops up, choose Solver.Xlam.

To access the tools, click Tools and then Solver.

Excel 2008 for Mac

This functionality was removed in Office 2008. Some third party add-ins (such as those linked below) attempt to provide similar functionality; however, they may not be free.

This is document agsp in the Knowledge Base.
Last modified on 2018-01-18 12:24:13.

Contact us

For help or to comment, email the UITS Support Center.