Add Wilcoxon Signed Rank Test to Statistics package.

Gigi

unread,

Dec 4, 2004, 9:57:02 AM12/4/04

to

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

unread,

Dec 4, 2004, 10:14:31 PM12/4/04

to

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

On Sat, 4 Dec 2004 06:57:02 -0800, "Gigi" <Gi...@discussions.microsoft.com>
wrote:

Harlan Grove

unread,

Dec 5, 2004, 4:03:17 AM12/5/04

to

"Myrna Larson" <anon...@discussions.microsoft.com> wrote...

>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.

>"Gigi" <Gi...@discussions.microsoft.com> wrote:
>>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.

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

unread,

Dec 5, 2004, 10:33:46 AM12/5/04

to

> 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

Harlan Grove wrote:
> "Myrna Larson" <anon...@discussions.microsoft.com> wrote...
>
>>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.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Myrna Larson

unread,

Dec 5, 2004, 4:44:11 PM12/5/04

to

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

unread,

Dec 6, 2004, 8:57:39 AM12/6/04

to

Look at

http://groups-beta.google.com/group/microsoft.public.excel.worksheet.functions/browse_thread/thread/dc5ead44625e61e3/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