ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Probability Question (https://www.excelbanter.com/excel-programming/360184-probability-question.html)

Myles[_65_]

Probability Question
 

I am working on a project which is loaded with probability outcomes. T
parody a segment of my problem, consider throwing 3 dice (each numbere
1 through 6 as usual). The probability of scoring 3 sixes with on
throw (termed a success) = (1/6)^3 or 1/216. If this exercise i
repeated n times, there is a greater chance to score a success bu
there is yet a chance of not scoring (a success) at all, regardless o
the value of n. It would sound intuitive that when n=216, at least on
success should be registered but this is most certainly not the case a
the law of averages fail here.

Now, can someone compute, using bimomial expansion or otherwise, th
statistical probability of at least scoring one set of 3 simultanoeu
sixes throwing all 3 dice at any one time? What value of n (or limi
thereof) attaches to this outcome?

Any help will be appreciate

--
Myle
-----------------------------------------------------------------------
Myles's Profile: http://www.excelforum.com/member.php...fo&userid=2874
View this thread: http://www.excelforum.com/showthread.php?threadid=53766


Jerry W. Lewis

Probability Question
 
Your question is not well posed. If you are asking about throwing n dice
triplets, where each triplet is uniquely identified, then you have already
explained why the number of triple 6's would be Binomial (n,1/216).
Otherwise you need to state more clearly just what you are asking.

Jerry

"Myles" wrote:

I am working on a project which is loaded with probability outcomes. To
parody a segment of my problem, consider throwing 3 dice (each numbered
1 through 6 as usual). The probability of scoring 3 sixes with one
throw (termed a success) = (1/6)^3 or 1/216. If this exercise is
repeated n times, there is a greater chance to score a success but
there is yet a chance of not scoring (a success) at all, regardless of
the value of n. It would sound intuitive that when n=216, at least one
success should be registered but this is most certainly not the case as
the law of averages fail here.

Now, can someone compute, using bimomial expansion or otherwise, the
statistical probability of at least scoring one set of 3 simultanoeus
sixes throwing all 3 dice at any one time? What value of n (or limit
thereof) attaches to this outcome?



All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com