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