How to conduct the Fisher’s Exact test using SPSS
To conduct a Fisher’s Exact test in SPSS it is very simple, you do exactly the same steps as Chi-square!
All we need to do differently is read different figures in the output! Below is a quick recap of how to perform the test in SPSS.
For this guide we’ll be using a cut down version of the Crime Survey for England and Wales.
Insert link here
Remember: It is always good practice to run Descriptives and clean our data before performing any inferential tests! If you are unsure how to do this, cleaning data and recoding is covered in the univariate analysis RISE intensive, why not give it a go!
For this example, we will be using the following variables:
Step 1 – select Analyze > Descriptive Statistics > Crosstabs

The following window should appear, this is where we drag or click across our variables. When doing Chi-square, it is important to remember that the DV (dependent variable) goes in the row(s) box and the IV (independent variable) goes into the column(s) box!
We then need to select some options to ensure that both the Chi-square and Cramer’s V strength of association tests are produced. Select Cells.
In this box observed should already be selected, select column percentages. If we select column percentages then we do not need expected counts. But it is sometimes useful to compare observed counts to the expected counts. So whether you choose to include this is up to you! Click CONTINUE and select Statistics.

In the following box we need to select the tests we wish to run; therefore, we need to select Chi-square as well as Phi and Cramer’s V. Click continue and ok.
You should receive the test results in your output Screen.
WELL DONE! YOU SUCCESSFULLY PERFORMED A FISHER’S EXACT TEST!