ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Mann Whitney (https://www.excelbanter.com/excel-discussion-misc-queries/174227-mann-whitney.html)

W Chamberlain[_2_]

Mann Whitney
 
Can anyone direct me to a resource on how to do a two tailed Mann Whitney
statistical test in Excel 2007? Since there is no direct Mann Whitney (AKA
Wilcoxon signed rank test) function that I can find, I guess I need some
instructions on how to take two columns of data and walk through the test
step by step to get a P value.

Thanks.

Niek Otten

Mann Whitney
 
Look he

http://www.statistics.com/resources/...w/wmwutest.php

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"W Chamberlain" wrote in message
...
| Can anyone direct me to a resource on how to do a two tailed Mann Whitney
| statistical test in Excel 2007? Since there is no direct Mann Whitney (AKA
| Wilcoxon signed rank test) function that I can find, I guess I need some
| instructions on how to take two columns of data and walk through the test
| step by step to get a P value.
|
| Thanks.



Jerry W. Lewis

Mann Whitney
 
You might also find
http://en.wikipedia.org/wiki/Mann-Whitney
to be helpful.

Jerry

"W Chamberlain" wrote:

Can anyone direct me to a resource on how to do a two tailed Mann Whitney
statistical test in Excel 2007? Since there is no direct Mann Whitney (AKA
Wilcoxon signed rank test) function that I can find, I guess I need some
instructions on how to take two columns of data and walk through the test
step by step to get a P value.

Thanks.



All times are GMT +1. The time now is 02:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com