Probability Formula?
Results 1 to 4 of 4

Thread: Probability Formula?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2012
    Posts
    34
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Probability Formula?

    There are 3 balls in a bag, one red, two blue.

    Therefore, there is a 33.33% (Cell A1) chance of picking the red ball, and a 66.66% (Cell A2) of picking a blue ball.

    Would there be a formula to calculate the probability in a 'Best of X' race?

    So for instance, what would be the probability of picking 2 red balls, before 2 blue balls? (Best of 3)

    or the probability of picking 7 red balls, before 7 blue balls? (Best of 13)

    This question always assumes there are always 3 balls are always in the bag. So it's always a 33.33/66.66% chance.

    Thanks!

  2. #2
    Board Regular
    Join Date
    May 2017
    Posts
    287
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Probabilty Formula?

    You would be able to achieve this through using .... =Binomdist or a combination of these

    will play with it now

  3. #3
    Board Regular
    Join Date
    May 2017
    Posts
    287
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Probabilty Formula?

    see if this is what you need ...

    Place the headings "best of", "minimum # of success needed", "# combinations", "probability" in cells F24, G24, H24, I24

    in F25 enter ... 3
    in G25 enter ... =ROUNDDOWN(F25/2+1,0)
    in H25 enter ... =COMBIN(F25,G25)
    in I25 enter ... =BINOMDIST(G25,F25,1/3,FALSE)

    in F26 enter ... =F25+1 and drag down as far as needed

    drag down cells G25, H25 and I25 as far as needed

    you should have the correct probabilities in decimal form

    Kind regards

    Chris

  4. #4
    Board Regular
    Join Date
    May 2017
    Posts
    287
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Probabilty Formula?

    Was that what you wanted ?

    Kind regards,

    Chris

Some videos you may like

User Tag List

Tags for this Thread

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
  •