Results 1 to 4 of 4

Fischer's Exact Test Formula

This is a discussion on Fischer's Exact Test Formula within the Excel Questions forums, part of the Question Forums category; Does anyone happen to have this? Many Thanks!...

  1. #1
    Board Regular
    Join Date
    Nov 2007
    Posts
    113

    Default Fischer's Exact Test Formula

    Does anyone happen to have this?

    Many Thanks!

  2. #2
    Board Regular baitmaster's Avatar
    Join Date
    Mar 2009
    Location
    bristol, england
    Posts
    1,429

    Default Re: Fischer's Exact Test Formula

    Baitmaster G

    Excel 2013 on Win 7 (work), 2010 on Win 8 (home), 2007 on Win 7 (in the spare room)

    Always save your work before running code from me, I probably haven't tested it and I'm not responsible when you lose all your work :p
    I aim to improve understanding so you can develop your own solutions, not do all your work for you. Write a clear requirement and you're more likely to get help

  3. #3
    Board Regular
    Join Date
    Nov 2007
    Posts
    113

    Default Re: Fischer's Exact Test Formula

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

  4. #4
    Board Regular baitmaster's Avatar
    Join Date
    Mar 2009
    Location
    bristol, england
    Posts
    1,429

    Default 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
    Baitmaster G

    Excel 2013 on Win 7 (work), 2010 on Win 8 (home), 2007 on Win 7 (in the spare room)

    Always save your work before running code from me, I probably haven't tested it and I'm not responsible when you lose all your work :p
    I aim to improve understanding so you can develop your own solutions, not do all your work for you. Write a clear requirement and you're more likely to get help

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com