|
|
|
|
I haven't used this particular workbook, but I have found its source (the Handbook of Biological Statistics) to be one of the most reliable and useful of all on-line stats resources, and have it in my Firefox bookmarks for quick reference. See also p 31 et seq of http://www.scribd.com/doc/2985277/Statistics-using-Excel-2007 if you want to create your own tool from scratch Cheers Meic
Show Original Message
-------------------------------------------
Original Message:
Sent: 22-01-2013 03:24
From: Brendan Collins
Subject: Wilcoxon signed ranks test in Excel
Hi does anyone have experience of using Wilcoxon signed ranks test in Excel? I know there are some online tools for it and that you can do it in SPSS, Epi Info etc, but I want to create a tool that does it in Excel for practitioners to use to analyse data that has small samples or is not normally distributed, i.e. where a paired sample t test would not be appropriate.
I found a tool here http://udel.edu/~mcdonald/statsignedrank.xls - if anyone has used it or can vouch for its accuracy that would be great.
Thanks & best wishes
Brendan Collins Research Fellow in Health Economics NHS Wirral / University of Liverpool Old Market House Hamilton Street Birkenhead Merseyside, CH41 5AL Mobile: 07866 540781 Email: brendan.collins@nhs.net (NHS) brendan.collins@liverpool.ac.uk (University)
|
|
Be the first person to recommend this.
|