Skip to main content
removed tag
Link
gung - Reinstate Monica
  • 147.5k
  • 89
  • 406
  • 716
Source Link

Statistical Analysis: Fisher exact test or chi-square test?

I am trying to do statistical analysis for a user survey. The total number of survey to be analysed is 59. The variables in the survey can be defined as a categorical variable. Some of the contingency tables for the survey looks as follows:

2   1
11  13
0   32

11  9   1
14  23  1

13  7
23  15

I am confused regarding whether to use fisher test or chi square test? As not all the tables are of 2*2 matrix, as well as some of the tables have expected values of less than 5. (The total number of responses vary in each table).

If I have to use fisher test, I use F-Test Two-Sample for Variances in excel. The solution by that method gives the following terms. What does these term mean?

F
P(F<=f) one-tail
F Critical one-tail

At last, when can I reject null hypothesis in excel.