Results 1 to 2 of 2

Using Binomial Distribution Function (BINOMDIST)

Threaded View

  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

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