+ Reply to Thread
Results 1 to 2 of 2

Using Binomial Distribution Function (BINOMDIST)

  1. #1
    Forum Contributor
    Join Date
    02-20-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    467

    Using Binomial Distribution Function (BINOMDIST)

    I am trying to use the excel function BINOMDIST to calculate what the probabilities would be for each correct score in a best of 14 darts match where the match stops if a player reaches the required 8 legs.

    To work out these probabilities I am using the probabilities for each player to win a single leg when they are throwing first and then multiplying this by the number of possible combinations of this particular score occuring. This part I believe I have worked out correctly. Bear in mind, for Player A to win 8-1 then player B can only win one of the first 8 legs or else Player A would have already won the match 8-0. For any novices to the game of darts each player throws first in alternate legs so we also need to take in to account the player who is throwing first, I intend to identify this by marking either cell A2 or A3 with a 1.

    On the attached example I believe I have correctly formulated for Player A to win 8-0 but am struggling with the remaining scores.

    Could someone have a look at the example and see if they can point me in the right direction on how to formulate these remaining probabilities.

    Thanks,
    Adam.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-20-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    467

    Re: Using Binomial Distribution Function (BINOMDIST)

    Just bumping back up has had no response. If I am not clear about anything, please ask.

    Thanks,
    Adam.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1