Re: OT: Home Sick for the Holidays, or Probability and Yahtzee
OK, I did some more searching around and discovered that Excel can, in fact, do this calculation.
There is a handy pre-built function called BINOMDIST(number_s, trials, probability, cumulative).
Now this is easy.
The probability of getting 182 or more 6's in 1000 rolls is:
P = 1 - BINOMDIST(181, 1000, 1/6, TRUE)
P = 0.105008
I needed to subtract from 1 because the cumulative function adds from 0 to 181. To get the portion for 182 and above, we subtract from the whole (1) the part we don't want, the stuff at 181 and below.
OK, so there's about a 10.5% chance of getting 182 or more.
The probability of getting 326 or more 6's in 1000 rolls is:
P = 1 - BINOMDIST(325, 1000, 1/6, TRUE)
P = -0.5.08482E-14
Obviously there's something wrong. The answer can't be negative. I think Excel still can't handle this kind of big / small number.
Does anybody have a better program and/or calculation method that can do this? Or am I doing something wrong?
|