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
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 just woke up! Thanks a Million bob! I was up till 5 am this morning working on the excel problems. I feel like I am honestly learning it and you all are being very helpful.
I will go ahead and work on what you just posted up and let you know how it works out!
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.
Then to get my average I used.
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.