Excel 2011 - Data Analysis ToolPak

The Data Analysis ToolPak is not available in Office 2011. This was by Microsoft's design.

Microsoft's Solution:

Download StatPlus:mac LE for free from AnalystSoft, and then use StatPlus:mac LE with Excel 2011.

You can use StatPlus:mac LE to perform many of the functions that were previously available in the Analysis ToolPak, such as regressions, histograms, analysis of variance (ANOVA), and t-tests.

Visit the AnalystSoft Web site, and then follow the instructions on the download page.

After you have downloaded and installed StatPlus:mac LE, open the workbook that contains the data that you want to analyze.

Open StatPlus:mac LE. The functions are located on the StatPlus:mac LE menus.

Note: Excel 2011 does not include Help for StatPlus:mac LE. Help for StatPlus:mac LE is provided by AnalystSoft.