|
Size: 1126
Comment:
|
Size: 1927
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 3: | Line 3: |
| A web calculator for 2x2 tables is [http://www.graphpad.com/quickcalcs/contingency1.cfm here.] | A web calculator for 2x2 tables is [[http://www.graphpad.com/quickcalcs/contingency1.cfm|here.]] |
| Line 5: | 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 may be downloaded from [[http://www.obertfamily.com/software/fisherexact.html | here]] to add-in to EXCEL for Fisher's exact test for a 2x2 table. The function fet()can then be run in a cell to produce the Fisher's p-value. For example fet(A1,B1,C1,D1, True=1-tailed) produces a one-tailed p-value where the four table frequencies are in cells A1, B1, C1 and D1. Another EXCEL macro written by Russell John which was available from free download from the Murdoch edu website is available below with a slight modification needed to be made to work on CBSU machines. This macro computes Fisher exact tests for ''any'' two-way table of frequencies. |
| Line 7: | Line 9: |
| 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. | 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 9: | Line 11: |
| 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). | The table of frequencies in any two-way table are placed in the EXCEL file and the macro run using tools>macro>macros in older versions of EXCEL (pre-2010) or clicking the developer tab>Macros in EXCEL 2010. Choose TwoWayTable Macro and Run. This is also described, with a diagram, on the Russell's website (link above). The developer tab is not in the ribbon by default but can be added by clicking the ''File tab'', clicking ''Options'', and then clicking the ''Customize Ribbon category''. In the ''Main Tabs'' list, select the ''Developer check box'', and then click ''OK''. |
| Line 14: | Line 16: |
| A MS-DOS program (fet.exe) which works on all Windows operating systems is available [http://www.tulane.edu/~dunlap/psylib.html for download or on-line use from here.] | A MS-DOS program (fet.exe) which works on all Windows operating systems is available [[http://www.tulane.edu/~dunlap/psylib.html|for download or on-line use from here.]] |
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 here.
An EXCEL macro may be downloaded from here to add-in to EXCEL for Fisher's exact test for a 2x2 table. The function fet()can then be run in a cell to produce the Fisher's p-value. For example fet(A1,B1,C1,D1, True=1-tailed) produces a one-tailed p-value where the four table frequencies are in cells A1, B1, C1 and D1.
Another EXCEL macro written by Russell John which was available from free download from the Murdoch edu website is available below with a slight modification needed to be made to work on CBSU machines. This macro computes Fisher exact tests for any two-way table of frequencies.
In particular the Round () function is not recognized so an amended 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 in older versions of EXCEL (pre-2010) or clicking the developer tab>Macros in EXCEL 2010. Choose TwoWayTable Macro and Run. This is also described, with a diagram, on the Russell's website (link above). The developer tab is not in the ribbon by default but can be added by clicking the File tab, clicking Options, and then clicking the Customize Ribbon category. In the Main Tabs list, select the Developer check box, and then click OK.
Please note the Monte-Carlo chi-square option in the EXCEL macro does not work on CBSU machines.
A MS-DOS program (fet.exe) which works on all Windows operating systems is available for download or on-line use from here.