I need to set up a simulation that shows the probability that a pair of die
will land on 7 in 1000 trials. I have tried everything that I can and seem
so be stumped!!

Any help will be greatly appreciated. I have Monte Carlo add-in and crystal
ball.

Thanks,

How about the long way?

I put this in a new worksheet:

A1: Die #1
B1: Die #2
C1: Total

A2: =1+INT(RAND()*6)
B2: =1+INT(RAND()*6)
C2: =sum(a2:b2)

Each of those formulas will return a number from 1 to 6.

And then select A2:C2 and drag down to row 1001 (1000 rows)

Then I put 7 in D1.
and this formula in E1:
=COUNTIF(C2:C1001,D1)/COUNT(A2:A1001)

And you can rerun your simulation by hitting the F9 key (to recalc all those
=rand()'s and other formulas).

Janet wrote:

I need to set up a simulation that shows the probability that a pair of die
will land on 7 in 1000 trials. I have tried everything that I can and seem
so be stumped!!

Any help will be greatly appreciated. I have Monte Carlo add-in and crystal
ball.

Thanks,

--

Dave Peterson

Thank you so much! I posted in two areas just to make sure someone would
read it! You have saved the day!!!

Thank you!

"Dave Peterson" wrote:

How about the long way?

I put this in a new worksheet:

A1: Die #1
B1: Die #2
C1: Total

A2: =1+INT(RAND()*6)
B2: =1+INT(RAND()*6)
C2: =sum(a2:b2)

Each of those formulas will return a number from 1 to 6.

And then select A2:C2 and drag down to row 1001 (1000 rows)

Then I put 7 in D1.
and this formula in E1:
=COUNTIF(C2:C1001,D1)/COUNT(A2:A1001)

And you can rerun your simulation by hitting the F9 key (to recalc all those
=rand()'s and other formulas).

Janet wrote:

I need to set up a simulation that shows the probability that a pair of die
will land on 7 in 1000 trials. I have tried everything that I can and seem
so be stumped!!

Any help will be greatly appreciated. I have Monte Carlo add-in and crystal
ball.

Thanks,

--

Dave Peterson