Best Statistical Add-On For Excel.

H

Harlan Grove

W. D. Allen Sr. wrote...
Can anyone recommend a good statistical add-on package that corrects for the
erroneous statistical functions of Excel?
Click to expand...

If you want to do serious stats, don't use Excel. If you insist on
using Excel for stats, you won't be doing serious stats, so what does
it matter what you use?!

Sarcasm aside, what are you trying to do? Time series add-ons won't be
much use if you want to do general linear modelling, and vice versa.
Simulation is WAY SLOW in Excel compared to more batch-oriented stats
programs.
 
J

Jerry W. Lewis

Depends on what you want to do.

http://members.aol.com/iandjmsmith/Examples.xls

contains a library of probability functions that are as good as or
better than any double precision package that I have seen, including
dedicated commercial statistical packages.

If you are wanting to do simple statistics, the suggestions at
http://groups-beta.google.com/group/microsoft.public.excel.worksheet.functions/msg/d6a03470e7a1c650
will probably be sufficient with the following correction:
seb = steyx/SQRT...
should read
seb = steyx*SQRT...
(Note that the formula for se1 is correct as is.)

If you are wanting to do more complex analyses, then you are probably
working too hard to do it in Excel, and would go a lot farther to learn
R, which is a full featured open-source statistics package that is
freely available from
http://www.r-project.org/

Jerry
 
Top