Unlike Excel for Windows and Excel 2016 for Mac, the Data Analysis ToolPak is not included in Excel 2011. The workaround is to add the free StatsPlus Lite Edition to Excel 2011. Follow the steps below: Download StatsPlusLE for Mac and save the zip file on the desktop. Double-click on the zip file to unzip the contents to a folder on the desktop. When you load the Analysis Toolpak, the Data Analysis command is added to the Tools menu. Downloading Analysis ToolPak Why I can not download Analysis Toolpak 0 0. Nov 21st, 2017, 03:45 AM #8. View Profile View Forum Posts Private Message.
Does anyone know how to download the data analysis toolpack add-in for Excel 2011 for Mac? I have looked around quite a bit and can't seem to find it anywhere... did Microsoft discontinue this completely?
P.s. I am familiar with the StatPlus software and have used it - that is not what I am looking for. I am looking for the native Data Analysis Toolpak for excel.
samthebrand1 Answer
Yes, it appears to have been discontinued. Sorry.
Refer to the discussion at What happened to the Data Analysis Toolpak or Solver in Excel for Mac 2011? – answers.microsoft.com. Quote:
The Data Analysis Toolpak was removed in Office for Mac 2008.[emphasis mine] However, the following is a free third-party tool [...]
[... goes on to mention the StatPlus software you already mentioned ...]
See also: I can't find the Analysis ToolPak – Microsoft Office Mac Troubleshooting. Quote:
Cause: Excel 2011 does not include the Analysis ToolPak.
Solution: Download StatPlus:mac LE for free from AnalystSoft, and then use StatPlus:mac LE with Excel 2011.
...
That last link used to include loads of comments from disgruntled Office for Mac users, but Microsoft seems to have removed comment functionality from that help center article. Surely you can find disgruntled comments re: the above elsewhere on the net.
samthebrandHow To Use Data Analysis In Excel
You must log in to answer this question.
protected by Community♦Sep 12 '13 at 2:49
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
Excel Analysis Toolpak For Mac
Not the answer you're looking for? Browse other questions tagged ms-office .
Solver was added to Office for Mac 2011 in the Service Pack 1 update. You can download and install Office for Mac 2011’s Service Pack 1 by clicking on the link below:
After you install Service Pack 1, follow these steps to start Solver:
- Start Excel.
- Click Tools, and then select Add-Ins.
- Click to select the check box for Solver.Xlam.
- Click OK.
The Data Analysis Toolpak was removed in Office for Mac 2008. However, the following is a free third-party tool that offers similar functionality:
StatPlus:mac LE: http://www.analystsoft.com/en/products/statplusmacle/
Excel Data Analysis Toolpak Download
The third-party products that this thread discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.