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.
Bookmarks