FAQ/chiwww - CBU statistics Wiki

Upload page content

You can upload content for the page named below. If you change the page name, you can also upload content for another page. If the page name is empty, we derive the page name from the file name.

File to load page content from
Page name
Comment
Type the odd letters out: ONlY twO thinGs aRE infiNite

Revision 6 as of 2007-07-20 13:26:12

location: FAQ / chiwww

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.