Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 837
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Probability roystonteo via OfficeKB.com Excel Discussion (Misc queries) 3 February 5th 09 07:18 PM
probability [email protected] Excel Discussion (Misc queries) 4 October 11th 07 09:42 PM
probability grahog Excel Worksheet Functions 1 January 23rd 07 11:20 PM
Probability Question zealot Excel Discussion (Misc queries) 2 November 27th 06 06:02 AM
probability plato Excel Programming 1 April 24th 06 12:22 PM


All times are GMT +1. The time now is 12:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"