Diff for "FAQ/chiwww" - CBU statistics Wiki
location: Diff for "FAQ/chiwww"
Differences between revisions 2 and 3
⇤ ← Revision 2 as of 2007-07-20 13:19:05 →
Size: 735
Editor: PeterWatson
Comment:
← Revision 3 as of 2007-07-20 13:21:27 → ⇥
Size: 735
Editor: PeterWatson
Comment:
Deletions are marked like this. Additions are marked like this.
Line 6: Line 6:
In particular the Round () function is not recognized so an amended [attachment:fishchi.xls:version] is available. In particular the Round () function is not recognized so an amended [attachment:fishchi.xls version] is available.

How do I obtain Fisher's exact test and chi-square for a two-way table on-line?

An EXCEL macro written by Russell John is available for[http://www.maths.murdoch.edu.au/units/statsnotes/inference/excelprocs2.html free download] but a slight modification needs to be made to work on CBSU machines.

In particular the Round () function is not recognized so an amended [attachment:fishchi.xls version] is available.

The table of frequencies are placed in the EXCEL file and the run using tools>macro>macros. Choose TwoWayTable Macro and Run. This is also described, with a diagram, on the Russell's website (link above).

Please note the Monte-Carlo chi-square option in the EXCEL macro does not work on CBSU machines.

None: FAQ/chiwww (last edited 2014-03-19 14:37:00 by PeterWatson)