|
|
Subject:
Can someone help with a probability question
Category: Science > Math Asked by: gampas-ga List Price: $20.00 |
Posted:
13 Jul 2005 11:51 PDT
Expires: 12 Aug 2005 11:51 PDT Question ID: 543144 |
I select x numbers on a roulette table. What is the probability that they will all have occurred (at least once) after x spins, x+1 spins etc. I can perform this in Excel, but that seems to involve using a table and then a Sumif function. There must be a general formula, but cannot find it in Excel. |
|
There is no answer at this time. |
|
Subject:
Re: Can someone help with a probability question
From: gampas-ga on 16 Jul 2005 02:19 PDT |
The problem is that the number of entries in the Venn diagram increases rapidly. For example, say I select six numbers and want to work out how often I get all of them within 6, 7 ... n spins, then for 8 spins I already have to consider combinations with 3 of each number and 2 of each number. The method I employed in Excel was to calculate the distribution of the last number which is clearly 1/37, 1/37*36/37 .. 1/37*(36/37)^n for the first spin, second spin and nth spin etc. I then calculated the distribution for the last but one number which is clearly 2/37, 2/37*35/37 .. 2/37*(35/37)^n. I arranged these as a chart with the first number as the x axis and the second number as the y axis. I used a 100 x 100 chart, and each cell was the product of the chance of getting the last number in p spins and the penultimate number in q spins. I then added the number of each to produce another 100 x100 chart with the numbers 1-200. I then used SUMIF to find the chances of getting the last two numbers in 2, 3 ... 200 spins. I then repeated the process to get the distribution for the last three numbers etc. But, by the time I was up to five numbers, Excel was creaking and preforming the math very slowly... |
Subject:
Re: Can someone help with a probability question
From: relf-ga on 19 Jul 2005 23:13 PDT |
Let n be the number of spins. Without loss of generality we can assume that selected x numbers are 1, 2, ..., x. Let B be the set of all possible results of n spins. For any fixed i from {1,2,...,x} define A_i as the set of all possible results of n spins where the number i is missing. Then the required probability is simply (|B| - |A_1 U A_2 U ... U A_x|) / |B| The number of elements in B is fairly easy to compute: |B| = 37^n (i.e., 37 to the power n). |A_1 U A_2 U ... U A_x| can be computed using the Inclusion-Exclusion Principle http://mathworld.wolfram.com/Inclusion-ExclusionPrinciple.html so that |B| - |A_1 U A_2 U ... U A_x| = Sum[k=0..x] (-1)^k * binomial(x,k) * (37-k)^n where the sum is taken over k=0,1,...,x and binomial(x,k)=x!/(k!*(x-k)!) is a binomial coefficient http://mathworld.wolfram.com/BinomialCoefficient.html Therefore, the probability that every of x selected numbers appeared at least once after n spins equals Sum[k=0..x] (-1)^k * binomial(x,k) * (37-k)^n / 37^n Some numerical values of this probability for fixed x and n=1,2,...,10: x=1: 0.0270 0.0533 0.0789 0.104 0.128 0.152 0.175 0.197 0.219 0.240 x=2: 0 0.00146 0.00426 0.00830 0.0135 0.0197 0.0268 0.0348 0.0435 0.0530 x=3: 0 0 0.000118 0.000455 0.00109 0.00209 0.00352 0.00540 0.00779 0.0107 x=4: 0 0 0 0.0000128 0.0000606 0.000172 0.000380 0.000719 0.00123 0.00193 x=5: 0 0 0 0 0.00000173 0.00000968 0.0000316 0.0000786 0.000165 0.000308 |
Subject:
Re: Can someone help with a probability question
From: saptak-ga on 05 Aug 2005 07:07 PDT |
the formula is (kCx = k choose x)*x*(x-1)*(x-2)...1/(n to power of x) i.e. kCx*x!/n(pow)x where x is the same as you have mentioned, n is the number of slots in the roulette table and k>=x is the number of spins that you choose. The logic is as follows: the no. of ways in which you can get 1 of ur x selected no.s in a spin is x/n, the no. of ways in which you can "now" get 1 of ur x-1 remaining no.s in another spin is (x-1)/n, similarly (x-2)/n.....1/n. Now you can have any no. coming in the rest of the k-x spins in (n/n = 1) ways. So if u have ur selected x no.s coming in the first x spins, the proby wud be x/n*(x-1)/n*...*1/n*{1*1...*1}(k-x times). As u can see there can be kCx ways in which u can select x spins out of the k total spins in which u get ur selected x no.s. Therefore multiply the 2 terms to get the formula as stated. |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
Search Google Answers for |
Google Home - Answers FAQ - Terms of Service - Privacy Policy |