You are going to roll four twenty-sided dice. If the rolls total to 20 or less, roll two more twenty-sided dice and add that to the total. For instance, if the total of my four die rolls is 32, then that is the score of the game. If the total is 17, then I roll two more dice and add that to the total. If these two bonus dice total 20, then the score of that game is 37. Of ten thousand games, what is the average score?

I need help with the second half of this problem, if the score of the game is less than 20.

Question

You are going to roll four twenty-sided dice. If the rolls total to 20 or less, roll two more twenty-sided dice and add that to the total. For instance, if the total of my four die rolls is 32, then that is the score of the game. If the total is 17, then I roll two more dice and add that to the total. If these two bonus dice total 20, then the score of that game is 37. Of ten thousand games, what is the average score?

I need help with the second half of this problem, if the score of the game is less than 20.

anonymous · Answer

Need some help setting this up in excel.

anonymous · Answer

Basically, you want to use excel to run this experiment 10000 times and then see what the average score is. Do you know how to generate random numbers in Excel?

anonymous · Answer

yes i know the randbetween 
its mainly the second part of the problem that has stumped me

anonymous · Answer

so would i have to show all 10k games in the spreadsheet?

anonymous · Answer

yeah.
In your first row, in 4 adjacent cells, i'd enter randbetween(1,20). That'll give you your 4 20 sided die.

anonymous · Answer

got it

anonymous · Answer

In the 5th column enter the formula:
=if(sum(A1:D1)>20,sum(a1:d1),sum(a1:d1) + randbetween(1,20) + randbetween(1,20))

anonymous · Answer

then copy that row down 10000 rows.

anonymous · Answer

then average that 5th column with the average function.

anonymous · Answer

copy all rows down to 10K?

anonymous · Answer

Yeah. I just did it. You can recalc the thing by hitting F9.
I always get an average between 42.4 and 42.7

anonymous · Answer

pretty cool to see an excel problem on here.
I worked a lot in excel for years, but i never see questions on it here!

anonymous · Answer

hold on im starting to get lost

anonymous · Answer

i'm assuming that your 20 sided dice is numbered from 1 to 20.

anonymous · Answer

im pretty good in math im just not very proficient in excel

anonymous · Answer

cool

anonymous · Answer

the sum of the first 4 dice is hardly ever 20 or less...but in 10000 trials, it happens occasionally

anonymous · Answer

1 sec i just screwed the whole thing up

anonymous · Answer

if i want these numbers to stop changing what i got to do

anonymous · Answer

copy paste maybe??

anonymous · Answer

Why do you not want them to change?

anonymous · Answer

nvm i see what its doing
ok so now how do i do the part about if it equals 20 roll 2 more dice

anonymous · Answer

what about rolls for the ones that equal 20 or less.
thats was what  was getting at with the numbers changing