Dear all,
Is it possible to implement Fishers and Mcnemar's tests within Excel 2003 (or later) in addition to the standard ChiSq?
Cheers,
Alistair
Last edited by VBA Noob; 04-02-2009 at 02:07 PM.
fishers is in there
http://office.microsoft.com/en-us/ex...090911033.aspx
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Looks like there are commercial packages to do this, e.g., http://www.winstat.com/english/funct...e2/mcnemar.htm and http://www.analyse-it.com/userguide/...exact_test.htm.
No doubt it could be done without, it would just take some time wading through the formulas.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks