Jan 23, 2014 The add-in for those data analysis tools is usually called 'Analysis ToolPak,' and it's not available for Excel 2011 for Mac. Instead, Microsoft recommends a third-party alternative. In Excel 2011 for Mac, choose Help from the topmost menu bar, type 'Analysis ToolPak' (without the quotes) into the Search box, and select the 'I can't find the.
The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis.
To load the Analysis ToolPak add-in, execute the following steps.
1. On the File tab, click Options.
2. Under Add-ins, select Analysis ToolPak and click on the Go button.
3. Check Analysis ToolPak and click on OK.
4. On the Data tab, in the Analysis group, you can now click on Data Analysis.
The following dialog box below appears.
5. For example, select Histogram and click OK to create a Histogram in Excel.