Math Is Fun Forum

Thank you bob I am still plugging away at it when you come back post up something here and I'll let you know if I ended up hitting gold! good luck at the dance show!

Hey Bob here you go a screen cap of the current problem almost solved I think.

albums/cc214/Hayabusakota/ScreenShot2013-04-27at30008PM-1.png

this is part one.

No luck with that formula up there I was trying to build a string but I don't know how to have the string represent the number in each cell while grouped in the cell I am adding the totals in.

i218 .photobucket. com

something else I did was on a separate sheet I did the same problem but took a different approach I made ten separate sells across a =RANDBETWEEN(0,1). I was thinking maybe there would be a way to have all those cell's join in a formula to figure out the average. I'll post a link of what I did in the separate cell. I am terrible at explaining what I was thinking lol! sorry

now would there be a way to run number tally's in the same bracket and after 10k games have it reset ?

in b3 my cell reads =IFERROR(IF(FIND(1111,B2)>0,B3+1,B3),B3)

http://s218.photobucket.com/user/Hayabu … M.png.html

Unfortunately it will not let me post links to the screen cap of it.

thanks a bunch if you think screen shots would help you out let me know I will screen cap the issue I am having.

alright I am currently working on a problem with 10k sims in a game where you have 10 chances to flip a heads or tails coin to win a dollar the rule to win is you must roll heads four times in a row. I made the 10k sim cells then went across over ten columns with the command of =RANDBETWEEN(0,1). now what is left is figuring out how to add the ten cells in the next column to show a winning or losing roll and also have a sum average at the end to see the probability of winning in this game.

hey guys I ended up doing the second problem on that post in a long format with excel going down and doing 10k simulation runs of 4 sided dice then nest to it a column with additional rolls if less than twenty. I then go the average  score which was 41%. just wondering  if my formulas where right here is what I typed up.

For Rolls of 4 Twenty-sided Dice I used the formula. =RANDBETWEEN(1,20)+RANBETWEEN(1,20)+RANBETWEEN(1,20)+RANBETWEEN(1,20)

Then the next column  reads.

=IF(B4<20,+RANDBETWEEN(1,20)+RANDBETWEEN(1,20))

Then to get my average I used.

=AVERAGE(B4:B10003,C4:C10003)

now I don't know how to reduce the additional numbers in excel so I get averages that read like 41.633405 I'd like to just have the average be a whole number w/o decimal point.

I am now currently working on the heads or tail portion. I am formatting the problems this way because my instructor posted a video using these formats. I know there is a short cut way but to avoid any confusion on my part I like to try to keep this as simple as possible. If you can help me with the heads or tails formulation I would be greatful.

Thanks a mil for all your feedback as well.

Sincerely,

Josh