Cross Validated is a question and answer site for people interested in statistics, machine learning, data analysis, data mining, and data visualization. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I was taught to only apply Fisher's Exact Test in contingency tables that were 2x2.


  1. Did Fisher himself ever envision this test to be used in tables larger than 2x2 (I am aware of the tale of him devising the test while trying to guess whether an old woman could tell if milk was added to tea or tea was added to milk)

  2. Stata allows me to use Fisher's exact test to any contingency table. Is this valid?

  3. Is it preferable to use FET when expected cell counts in a contingency table are < 5?

share|improve this question
You might want to consider how good Fisher's exact test really is: (Section 3.3) – Fr. Dec 8 '12 at 13:32
You can compute the Fisher's exact test in R. Their method actually uses a network algorithm to make it fast enough:… See the paper [Mehta and Patel 1986] – Simone Feb 19 '15 at 2:22
up vote 15 down vote accepted

The only problem with applying Fisher's exact test to tables larger than 2x2 is that the calculations become much more difficult to do. The 2x2 version is the only one which is even feasible by hand, and so I doubt that Fisher ever imagined the test in larger tables because the computations would have been beyond anything he would have envisaged.

Nevertheless, the test can be applied to any mxn table and some software including Stata and SPSS provide the facility. Even so, the calculation is often approximated using a Monte Carlo approach.

Yes, if the expected cell counts are small, it is better to use an exact test as the chi-squared test is no longer a good approximation in such cases.

share|improve this answer
Can you point me where I can find documentation on how to do the Fisher test using SPSS? Thanks – biostat_newbie May 20 '11 at 2:48
Look under crosstabs – Rob Hyndman May 20 '11 at 5:57
Given that software can do the calculation so easily nowadays, is there any circumstance where, theoretically or practically, Chi squared test is actually preferable to Fisher's exact test? – pmgjones Jul 9 '11 at 11:36
In many cases the "exact" test is not exact at all and many "approximate" methods have a coverage closer to the nominal level of significance. See e.g. Alan Agresti and Brent A. Coull (1998) "Approximate Is Better than "Exact" for Interval Estimation of Binomial Proportions" The American Statistician, 52(2):119-126. – Maarten Buis Apr 22 '13 at 8:15
What is roughly the maximum contingency table size that can be analyzed with Fisher's exact method in a feasible time frame (say a week on a standard laptop)? – pir Apr 19 at 17:04

This page in MathWorld explains how the calculations work. It points out that the test can be defined in a variety of ways:

To compute the P-value of the test, the tables must be ordered by some criterion that measures dependence, and those tables that represent equal or greater deviation from independence than the observed table are the ones whose probabilities are added together. There are a variety of criteria that can be used to measure dependence.

I have not been able to find other articles or texts that explain how this is done with tables larger than 2x2.

This calculator computes the exact Fisher's test for tables with 2 columns and up to 5 rows. The criterion it uses is the hypergeometric probability of each table. The overall P value is the sum of the hypergeometric probability of all tables with the same marginal totals whose probabilities are less than or equal to the probability computed from the actual data.

share|improve this answer

If you're looking for other ways to compute Fisher's exact test with larger contingency tables, here is a online calculator for Fisher's exact test for 2x3 contingency tables. Also, here's one for 3x3 contingency tables, and one for 2x4 contingency tables.

Yes, if the expected cell counts are small, it is better to use Fisher's exact test instead of the chi-squared test, if possible.

share|improve this answer

In order to obtain Fisher"s Exact Test in SPSS, use the Statistics = Exact option in Crosstabs. Methods for computing the Exact Tedt for larger tables have been around at least since the 1960"s. The speed of modern microprocessors makes the computation time inconsequential these days. Indeed, it is so easy to run the Exact Test that it is important not to use it too widely.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.