Some people are saying that the data analysis toolpak excel not showing up, and they are wondering how to install the data analysis toolpak on a mac in Microsoft excel. To enable this add-in, under the Tools menu, click Add-Ins, select Data Analysis ToolPak and then click OK. The Data Analysis ToolPak is now on the ribbon under the Data tab.
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.
samthebrand
1 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.
samthebrandYou must log in to answer this question.
Excel Data Analysis Toolpak Mac
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?