See you a bit later, couple of chores need to be done.
]]>For red = 1 to...
For white = 1 to ...
For blue = 1 to ...
For green = 1 to ...
Simulate to see if all probabailities are equal
Next green, blue, white, red
constructs for excel?
]]>And the good news is......after fixing the column C code, the simulation now results in a 1-in-4 chance for each of those options.
]]>Just make sure you get an answer of 21 as above.
]]>Anyway, your suggestion has helped to uncover a flaw in my column C code. Thanks! So in the image I dispensed with column C's code and instead just used the contents of column A.
The random selection formula is wrong, which must be the reason for the strange results. My code wasn't selecting only unused digits from column A (which means that in some draws I was choosing one or more already-chosen marbles), but I think I've got an answer for that with a UDF.
My simulation idea is probably on the right track, and I hope it will work fine after I fix the flaw.
Back to the drawing board...
]]>Have you tried with the correct number of each to start?
...and I don't know what you guys are talking about.
Another way to get an answer to any probability question is to run a simulation.
]]>