How do I perform Fisher’s Exact Test in SPSS?

Fisher’s Exact Test is a statistical method used to determine the relationship between two categorical variables. It is often used when the sample size is small or when the data does not meet the assumptions of other statistical tests. In order to perform Fisher’s Exact Test in SPSS, follow these steps:

1. Open your SPSS software and load your data set.

2. Click on “Analyze” in the main menu, and then select “Nonparametric Tests.”

3. From the drop-down menu, select “Exact Tests” and then click on “Fisher’s Exact.”

4. In the dialogue box, specify the variables you want to analyze by moving them to the “Test Variables” box.

5. Select the desired level of significance and type of alternative hypothesis.

6. Click “Options” to specify any additional settings, such as the number of Monte Carlo samples.

7. Click “OK” to run the analysis and generate the results.

The output will include the test statistics, p-value, and other relevant information for interpreting the results. It is important to note that Fisher’s Exact Test is a one-tailed test, so the p-value reported is for a one-tailed test. If a two-tailed test is desired, the p-value should be multiplied by 2. Overall, performing Fisher’s Exact Test in SPSS is a straightforward process that can provide valuable insights into the relationship between categorical variables.

Perform Fisher’s Exact Test in SPSS


is used to determine whether or not there is a significant association between two categorical variables.

It is typically used as an alternative to the when one or more of the cell counts in a 2×2 table is less than 5.

This tutorial explains how to perform Fisher’s Exact Test in SPSS.

Example: Fisher’s Exact Test in SPSS

Suppose we want to know whether or not gender is associated with political party preference at a particular college. To explore this, we randomly poll 25 students on campus. The number of students who are Democrats or Republicans, based on gender, is shown in the table below:

  Democrat Republican
Female 8 4
Male 4 9

To determine if there is a statistically significant association between gender and political party preference, we can use the following steps to perform Fisher’s Exact Test in SPSS:

Step 1: Enter the data.

First, enter the data as shown below:

Each row shows an individual’s ID, their political party preference, and their gender.

Step 2: Perform Fisher’s Exact Test.

Click the Analyze tab, then Descriptive Statistics, then Crosstabs:

Drag the variable Gender into the box labelled Rows and the variable Party into the box labelled Columns. Then click the button labelled Statistics and make sure that the box next to Chi-square is checked. Then click Continue.

Next, click the button labelled Exact and make sure the box next to Exact is checked. Then click Continue.

Fisher's exact test in SPSS

Lastly, click OK to perform Fisher’s Exact Test.

Step 3: Interpret the results.

Once you click OK, the results of Fisher’s Exact Test will be displayed:

Output of Fisher's Exact Test in SPSS

The first table displays the number of missing cases in the dataset. We can see that there are 0 missing cases in this example.

The second table displays a crosstab of the total number of individuals by gender and political party preference.

The third table shows the results of Fisher’s Exact Test. We can see the following two p-values for the test:

  • Two-sided p-value: .115
  • One-sided p-value: .081

The null hypothesis for Fisher’s Exact Test is that the two variables are independent. In this case, our null hypothesis is that gender and political party preference are independent, which is a two-sided test so we would use the two-sided p-value of 0.115.

Since this p-value is not less than 0.05, we do not reject the null hypothesis. Thus, we don’t have sufficient evidence to say that there is a significant association between gender and political party preference.

x