Hello,
Life has presented me with an opportunity to teach some math to
children/young adults with challenging backgrounds. Many have come a long way
and want to pursue more challenging material. I want to teach them more about
probability and want to design an Excel simulation. My idea was to get them
to work out how variables altered probability.

Specifically I am looking for help to develop a game where students would
alter variables "probability" (expressed as a ratio or percentage) of picking
a colored ball from a bag. So if they said there were three red balls, 4
blue, six white etc. the simulation would calculate the probability of each
ball. And I'd like to show them the impact of selecting "out" or "in" where
"out" is keeping the ball (and all others selected) out of the bag for
subsequent turns and "in" is putting the ball back in the bag. Then a random
generator would be used to "pick" the next ball and excel would display a
cell of the matching ball color. I then want excel to show some statistics
like comparison of theoretical probability to outcome (to show sample size
variance), the number of times in a row a particular ball was drawn (as in a
streak).

I know the math but am a baby beginner at Excel programming. It looks like
from the help that a Binomial distribution is the function with a rounded
random function for selection. Am I on the right track? Any ideas on "out"
and "in"?

Thanks very much for your help

Rob