Fisher Exact Test in Excel using QI Macros

QI Macros can do it for you!

Create Fisher's Exact test using QI Macros:

  1. Select your data.
  2. Click on QI Macros menu > Statistical Tools > F & t Tests > Fisher's Exact Test.
  3. QI Macros will do the math and analysis for you.

Go Deeper: Fishers Exact Test of a 2x2 Table

A Fisher Exact Test evaluates small, 2x2 tables better than Chi-Square because it calculates the exact probability. A Fishers Exact Test of a 2x2 table helps identify if there are differences between two or more demographics. Consider the following example.

Note: Excel does not do a Fisher Exact Test; QI Macros adds this functionality.

Men vs Women Dieting - Fisher Exact Test Example

Imagine asking men and women if they are dieting. How will we know if one sex diets more than the other? We can develop a null hypothesis (H0) that men and women diet equally and an alternate hypothesis (Ha) that they are different:

Now, conduct the survey and enter the number of responses into Excel. As you can see, men seem to diet less than the women do, but is it statistically different?

Fishers Exact Test data

Select your data and click on QI Macros Menu, Statistical Tools, f and t Tests and then Fishers Exact Test (2x2):

fisher-exact-test-menu

The Fisher Exact Test macro will calculate:

  • exact test p value (.00276)
  • chi-square p value (.00093)

Fisher Exact Test results /></p>
				<h3>Interpreting  Fishers Exact Test results</h3><ul>
					<li>H0 men = women</li>
					<li>Ha men <> women</li>
				</ul>
<div class=

If
Then
p value < a Reject the null hypothesis
p value > a Cannot Reject the null hypothesis (Accept the null hypothesis)

In the results above, the Fisher's Exact Test p value is 0.00276. We can reject the null hypothesis at the 0.05 and 0.01 levels, but not the 0.001 level of a.

Notice that the Fisher Exact test p value is higher than the chi-square p value of 0.00093. Chi-square would let us reject the null hypothesis at the 0.001 level.

Stop Struggling with Fisher's Exact Tests!
Start creating your Fisher's Exact Tests in just minutes.

Download a free 30-day trial. Get Fisher's Exact Tests now!

Learn More...


Why Choose QI Macros Statistical Software for Excel?

easy to use

Easy to Use

  • Works Right in Excel
  • Interprets p-values for You
  • Accurate No-Worry Results
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • 100,000 Users in 80 Countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus Free

affordable

Affordable

  • Only $349 USD
    Quantity Discounts Available
  • No annual fees
  • Free Technical Support