Fischer's Exact Test Formula

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
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 :eek: - so I don't really want to get dragged further into statistical theory than this
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,243
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top