Is there a package similar to Analysis ToolPak that is on Excel for Windows? I have found this is not available in the Mac version of Excel

Question

Is there a package similar to Analysis ToolPak that is on Excel for Windows? I have found this is not available in the Mac version of Excel

My business requires a great amount of statistical number crunching. I was unpleasantly surprised to find that Excel for the Mac does not have the Analysis Tool Pack I have used for many years with the Windows versions. Does Numbers offer such a package either as an internal package or even as an add on module through the App Store. I have tried the StatPlus for Mac that was mentioned on Microsoft's support page, but it does not seem to even want to open on my Mac Book Pro. I am using OS Mountain Lion and have Office 2011. Thank you

MacBook Pro, OS X Mountain Lion (10.8.3), Excel for Mac with Office 2011

Posted on Mar 30, 2013 2:51 PM

Reply

Answer 1

Mar 30, 2013 6:57 PM in response to cliffordfromlas vegas

This forum is dedicated to Numbers which is a part of the Apple productivity suite, iWork. Since Excel is a part of Microsoft Office the Microsoft site is the best place to address this question.

Numbers does have many statistical functions but does not have an "add-on" tool set. You can write your own using Applescript. You can get free, downloadable, documents for Numbers from here:

http://support.apple.com/manuals/#productivitysoftware

There is a Numbers Users' Guide and a function reference.

Post back a specific question and we may be able to offer a solution.

Reply

Answer 2

Mar 31, 2013 8:27 AM in response to Wayne Contello

I was not indicating that I was looking for a package with Excel. I was stating that this does not exist with Excel and I was wondering if anyone had seen something similar to the Analysis Tool Pack for Numbers.

Reply

Answer 3

jaxjason

Level 5

5,063 points

Apr 1, 2013 6:03 AM in response to cliffordfromlas vegas

simple answer is no, there is not add on to numbers that replicates the finctionality of the Windows excel solver toolpack.

Jason

Reply