The situation is the same for the Output Range, except that now you should only highlight one cell. Note that the approach described above is not available for the older version of Real Statistics for the Mac. In the releases prior to Rel 5.0, you need to manually enter the ranges into the input and output range fields (e.g.
I am familiar with the StatPlus software and have used it - that is not what I am looking for.ĭid Microsoft discontinue this completely? if you choose an Input Range of say A5:F9 you need to type the characters A5:F9 in the Input Range instead of highlighting the range), although the Fill buttons will work.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. I am looking for the native Data Analysis Toolpak for excel.
Click the Data Analysis.ģ32 2 2 gold badges 4 4 silver badges 11 11 bronze badges 1 Answer Starting with Excel for Mac 2011, Service Pack 1 (version 14.1.0). Yes, it appears to have been discontinued. Refer to the discussion at What happened to the Data Analysis Toolpak or Solver in Excel for Mac 2011? –. However, the following is a free third-party tool The Data Analysis Toolpak was removed in Office for Mac 2008. See also: I can't find the Analysis ToolPak – Microsoft Office Mac Troubleshooting.
Quote:Ĭause: 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.