Quote Originally Posted by anil099
hey been working on this forever and can't seem to get it...

Simulate the profit of the race. Assume the number of spectator is affected by the weather. Probability distribution of weather is as follows:
Weather Probability
Clear .5
Cloudy .3
Rain .2
 If weather is clear, the number of spectator would be 1,500.
 If weather is cloudy, the number of spectator would be 1,000.
 If weather is rain, the number of spectator would be 300.
How do I do this in excel?
I already have a profit model/chart everything but I don't know much about simulations and probablity stuff..thanks
If it's connected with the weather you could follow the bureau and just shake some dice.

For your numbers,

take .5 * 1500 and add .3 * 1000 and add .2 * 300

this will give your probable croud.

hth
---