Thank you sir, i was searching how to get these statistics in large number. it helps me explaining the logic to anyone. it is the easiest and simplest way. Thanks a lot.
This is awesome, very easy to follow. Even though I know the right answer I've always had an intuitive pull to treat the second choice as 50/50. This way helped me beat my brain and check my priors. Thank you!
The “shortcut” you mention, to copy your formulas from the top to row 10,000… 1. Select the formulas to be copied (first row) 2. Copy the formulas, CTRL+C 3. GOTO with CTRL+G (or Function key F5) 4. Key in A10000 (You will automatically be in the correct menu field…) 4. Hold SHIFT and press ENTER 5. Press ENTER again to paste. 6. CTRL HOME to return to the top of the sheet With a little practice you can do this in 10 seconds. Try it!
可笑可笑。 Randomly generate a number among (1, 2, 3) and compare the probability of that random number equals to 1, and probability of not equals to 1. 魔鬼在細節，devil is in the details - carefully look at the formulas in the EXCEL this guy is using. Makes me laugh out loud LOL. In the EXCEL, the formula for that Switch cell in column E is = IF (Cn=1, 0, 1) n can be from row 8 to say row 102000, whatever; The formula for the Stay cell, column G is = IF(Cn=1, 1, 0) but the probability of Cn=1 is 1/3 = 33% and the probability of Cn=1 is false (that is Cn=2 or Cn=3), is 1-1/3 = 2/3 = 67% Why? because it is embedded inside the equation of the RNG cell in Column B: =RANDOMBETWEEN(1,3) that is among 1,2,3 So the probability of Door 1 cell in a row, equals to 1, is the probability of the RNG cell equals to 1, always 1/3. Formula of the Door 1 cell in Column C, at row n =IF(Bn=1,1,0). => and the orginal source cell Bn is randomized, among (1,2,3). Of course probability that Door 1 cell is 1, will be 1/3, and 2/3 that it is not a 1.
Thank you sir, i was searching how to get these statistics in large number. it helps me explaining the logic to anyone. it is the easiest and simplest way.
Thanks a lot.
My pleasure, glad it helped.
This is awesome, very easy to follow. Even though I know the right answer I've always had an intuitive pull to treat the second choice as 50/50. This way helped me beat my brain and check my priors. Thank you!
No doubt. We did this in physics class years ago and I was so sure it was random...
It would have been excellent if you coded it to allow for additional doors to see if/how it affects results :)
Now that is an interesting idea.
Tbh I would always stay. What if you switched and you lost - how upset would you be?
If loosing upsets you, you better switch.
Switching doesn't guaranty winning, but gives you double the odds of winning.
about 1/3rd as angry as if I'd stayed
Thanks!
The “shortcut” you mention, to copy your formulas from the top to row 10,000…
1. Select the formulas to be copied (first row)
2. Copy the formulas, CTRL+C
3. GOTO with CTRL+G (or Function key F5)
4. Key in A10000 (You will automatically be in the correct menu field…)
4. Hold SHIFT and press ENTER
5. Press ENTER again to paste.
6. CTRL HOME to return to the top of the sheet
With a little practice you can do this in 10 seconds. Try it!
Nice, that wins.
可笑可笑。 Randomly generate a number among (1, 2, 3) and compare the probability of that random number equals to 1, and probability of not equals to 1. 魔鬼在細節，devil is in the details - carefully look at the formulas in the EXCEL this guy is using.
Makes me laugh out loud LOL.
In the EXCEL, the formula for that Switch cell in column E is
= IF (Cn=1, 0, 1)
n can be from row 8 to say row 102000, whatever;
The formula for the Stay cell, column G is
= IF(Cn=1, 1, 0)
but the probability of Cn=1 is 1/3 = 33%
and the probability of Cn=1 is false (that is Cn=2 or Cn=3), is 1-1/3 = 2/3 = 67%
Why? because it is embedded inside the equation of the RNG cell in Column B:
=RANDOMBETWEEN(1,3) that is among 1,2,3
So the probability of Door 1 cell in a row, equals to 1, is the probability of the RNG cell equals to 1, always 1/3.
Formula of the Door 1 cell in Column C, at row n
=IF(Bn=1,1,0). => and the orginal source cell Bn is randomized, among (1,2,3). Of course probability that Door 1 cell is 1, will be 1/3, and 2/3 that it is not a 1.