I need to set up a simulation

J

Janet

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,
 
D

Dave Peterson

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).
 
J

Janet

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

Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top