Add Wilcoxon Signed Rank Test to Statistics package.
 

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.

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

"Myrna Larson" 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" 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

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/co...spx?Sitename=1

Harlan Grove wrote:
"Myrna Larson" 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

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



On Sun, 5 Dec 2004 01:03:17 -0800, "Harlan Grove" wrote:

"Myrna Larson" 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" 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

Look at

http://groups-beta.google.com/group/...f1ceadb78ba375

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

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