Add Wilcoxon Signed Rank Test to Statistics package.

[Gigi]

Can you add the Wilcoxon Signed Rank Test package to MS Office.

I use your program for school and its pretty good with that exception.

 

[Myrna Larson]

Have you asked that question of the people who produce the package? They are
most likely to know...

 

[Harlan Grove]

Have you asked that question of the people who produce the package? They are
most likely to know...

I'd be willing to bet the OP is referring to the Data Analysis Toolpak,
which, if memory serves, is distributed by the same company that develops
and sells Excel and Office and has its name in this very newsgroup's name.
OP is only being naive in assuming anyone from Microsoft reads this
newsgroup.

You could add the functionality yourself. For paired samples X and Y, try
the array formula

=(SUM(IF(X<>Y,SIGN(X-Y)*((MMULT((ABS(X-Y)>=TRANSPOSE(ABS(X-Y)))
-(ABS(X-Y)<=TRANSPOSE(ABS(X-Y))),ROW(X)^0)+COUNT(X,1))/2-SUM(--(X=Y)))))
-SIGN(SUM(IF(X<>Y,SIGN(X-Y)*((MMULT((ABS(X-Y)>=TRANSPOSE(ABS(X-Y)))
-(ABS(X-Y)<=TRANSPOSE(ABS(X-Y))),ROW(X)^0)+COUNT(X,1))))))/2)
/(SUM({2;3;1}*SUM(--(X<>Y))^{3;2;1})/6)^0.5

 

[Debra Dalgleish]

OP is only being naive in assuming anyone from Microsoft reads this

newsgroup.

Microsoft apparently encourages people to post, and vote for, product
suggestions.

http://office.microsoft.com/en-ca/contactus.aspx?Sitename=1

 

[Myrna Larson]

Could be. I've never thought of the libraries and/or libraries that are
included with Excel as "packages".

I assumed that "package" meant she had a separate program and wanted to know
if it could be used with Excel (e.g. as an add-in).

 

[Jerry W. Lewis]

Look at

http://groups-beta.google.com/group...625e61e3/63f1ceadb78ba375?&d#63f1ceadb78ba375

You may have to unwrap the link before it will work. Google appears to
be making some unfortunate changes to their interface and addressing.

In case you missed it, Myrna's point is that your question appears to be
intended for Microsoft, yet you have posted it to fellow users of
Microsoft products.

Jerry