Fischer's Exact Test Formula

Thanks:  0
Likes:  0

# Thread: Fischer's Exact Test Formula

1. ## Fischer's Exact Test Formula

Does anyone happen to have this?

Many Thanks!

3. ## Re: Fischer's Exact Test Formula

Does this site have an excel formula to run one-tailed and two-tailed tests???

4. ## Re: Fischer's Exact Test Formula

not exactly, no. It contains the mathematical formulas for deducing the probability of certain results, but you will have to write these into Excel yourself, unless you have a statistical package to help you

It covers the theory of one-tail and two-tail tests, but you would need to write the actual test yourself, e.g. at what point would you want to break out if the 2tail test fails..?

Once you have written the formulas, you can use macros to loop through and perform some monte-carlo sampling for you

For basic monte carlo style anaylsis, you would have formulas that include the RAND() function, then use a simple macro something like the following
Code:
```sub simulate()
dim i as integer
for i = 1 to 100
calculate
sheets("results").cells(i,1).value = range("[cell with results in]").value
next i```
This builds a table of results, that you could then perform further analysis on

I'm straying outside of my areas of - lets call it comfort, rather than expertise - so I don't really want to get dragged further into statistical theory than this

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•