ARCHIVED: In Microsoft Excel, how do I perform statistical analysis?
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 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
- From the Office Button menu (2007), select or . tab (2010) or
- Click , and then in the "Manage" box, select . Click .
- In the "Add-Ins available" box, check and , and then click .
- If you see a prompt stating that the Analysis Toolpak is not currently installed on your computer, click to install it. This will create a "Data Analysis" section within the tab.
Excel 2011 for Mac
To activate statistical analysis tools, click
, and then . In the dialog box that pops up, choose .To access the tools, click
and then .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.