Probability Formula?

tobermory

New Member
Joined
Jun 4, 2012
Messages
37
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!
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

palaeontology

Active Member
Joined
May 12, 2017
Messages
361
Office Version
2016
Platform
Windows
Re: Probabilty Formula?

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

will play with it now
 

palaeontology

Active Member
Joined
May 12, 2017
Messages
361
Office Version
2016
Platform
Windows
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
 

palaeontology

Active Member
Joined
May 12, 2017
Messages
361
Office Version
2016
Platform
Windows
Re: Probabilty Formula?

Was that what you wanted ?

Kind regards,

Chris
 

Watch MrExcel Video

Forum statistics

Threads
1,102,872
Messages
5,489,433
Members
407,689
Latest member
Doublealpha

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top