Statistical Packages for Mac LX 2004

[edvolchok]

Can anyone recommend a good statistical package (add-in) that runs on
Mac Excel X.3.6?

Ed Volchok

 

[CyberTaz]

Hi Ed -

Not knowing exactly what your needs are, have you yet activated Tools>
Add-Ins - Analysis ToolPak? You may find more there than you thought you had


BTW - You did mean 11.3.6, right?

 

[edvolchok]

Hi Ed -

Not knowing exactly what your needs are, have you yet activated Tools>
Add-Ins - Analysis ToolPak? You may find more there than you thought you had


BTW - You did mean 11.3.6, right?

Bob,

Sorry for the slow reply. Yes, 11.3.6. And, yes, I've installed the
Analysis ToolPak.

I teach Statistics at a community college. The textbooks I review all
have statistical Add-Ins above those that Microsoft supplies.
unfortunately none work on the Mac. These Add-Ins are said to have
greater functionality than the Analysis ToolPak.

BTW, several textbooks warn readers that Excel is less accurate that
SPSS or other stand alone statistical programs. Do you know if this is
correct? Unfortunately for Mac users, the latest version of SPSS does
not work with Intel-based Macs,

EV

 

[John Halloran]

Bob,

Sorry for the slow reply. Yes, 11.3.6. And, yes, I've installed the
Analysis ToolPak.

I teach Statistics at a community college. The textbooks I review all
have statistical Add-Ins above those that Microsoft supplies.
unfortunately none work on the Mac. These Add-Ins are said to have
greater functionality than the Analysis ToolPak.

BTW, several textbooks warn readers that Excel is less accurate that
SPSS or other stand alone statistical programs. Do you know if this is
correct? Unfortunately for Mac users, the latest version of SPSS does
not work with Intel-based Macs,

EV

I use QI Macros which are an Excel add-in at work on a Windows box, and
the product CD contains Mac versions of the macros as well. They do
expand on the capability of Excel's Analysis Toolpak. I've used them
mostly for charting data.

You can read more about them at http://www.qimacros.com

John

 

[Jim Gordon MVP]

Hi,

In certain unlikely situations Microsoft Excel will produce erroneous
results - usually in the tails near the limits of Excel's degree of
calculation precision.

This article has details:
http://support.microsoft.com/default.aspx?kbid=828888&product=xl2003

Excel critics go out of their way to praise gnumeric as if it were the
perfect answer. In my own testing I found it to be better, but not perfect.

I started a workbook that compares the answers to the calculations cited by
critics. If you want me to send a copy to you drop be a line. You should
be able to figure out my email address if you think that hot is warmer than
warm.

-Jim

BTW, several textbooks warn readers that Excel is less accurate that
SPSS or other stand alone statistical programs. Do you know if this is
correct? Unfortunately for Mac users, the latest version of SPSS does
not work with Intel-based Macs,

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info