|
Size: 735
Comment:
|
Size: 950
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| = How do I obtain Fisher's exact test and chi-square for a two-way table on-line? = | = How do I obtain Fisher's exact test and chi-square for a two-way table in EXCEL? = |
| Line 3: | Line 3: |
| A web calculator for 2x2 tables is [http://www.graphpad.com/quickcalcs/contingency1.cfm here.] | |
| Line 4: | Line 5: |
| 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. | 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. |
| Line 6: | Line 7: |
| 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. This does not run on the CBSU wiki so save this EXCEL file to your PC and run from there. |
| Line 8: | Line 9: |
| 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). | The table of frequencies in any two-way table are placed in the EXCEL file and the macro run using tools>macro>macros. Choose TwoWayTable Macro and Run. This is also described, with a diagram, on the Russell's website (link above). |
How do I obtain Fisher's exact test and chi-square for a two-way table in EXCEL?
A web calculator for 2x2 tables is [http://www.graphpad.com/quickcalcs/contingency1.cfm here.]
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. This does not run on the CBSU wiki so save this EXCEL file to your PC and run from there.
The table of frequencies in any two-way table are placed in the EXCEL file and the macro 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.