Statistics on Excel

[Alex]

Hello

I want to do some statistical tests on data using Excel.
I have the Analysis ToolPak Add-In already.

Still, you cannot do non-parametric tests such as...

Mann Whitney Test
Sign Test
Wilcoxon Ranked Sign Test

Is there a download for this? Is there a worksheet
fucntion for such tests or do I have to do this manaully?

Any advice is always welcome. Thanks.

 

[Jerry W. Lewis]

I am not aware of a free download, but

http://groups.google.com/[email protected]

shows how to do the Wilcoxon test, and the sign test is just an
application of the binomial distribution.

Commercial add-ins are available, such as those from

www.analyse-it.com/
www.xlstat.com
www.palisade.com/

(I have no personal experiance with any of them)

Outside of Excel, if you don't mind learning the S language, you could
use the freely available open-source package R

www.r-project.org

Jerry