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