Discussion about math, puzzles, games and fun.   Useful symbols: ÷ × ½ √ ∞ ≠ ≤ ≥ ≈ ⇒ ± ∈ Δ θ ∴ ∑ ∫  π  -¹ ² ³ °

You are not logged in.

## #1 Re: Introductions » Greetings! » 2013-04-28 13:27:33

No luck in figuring it out I tried to come up with formulas to tie it together and no dice.

## #2 Re: Introductions » Greetings! » 2013-04-28 00:41:13

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!

## #4 Re: Introductions » Greetings! » 2013-04-27 15:23:41

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.

## #5 Re: Introductions » Greetings! » 2013-04-27 07:45:28

alright sounds good to me going to see if I know anyone locally that can help me figure this one out.

## #6 Re: Introductions » Greetings! » 2013-04-27 07:43:15

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.

## #7 Re: Introductions » Greetings! » 2013-04-27 07:11:15

just wondering how do I build the ten digit 0/1 value into one cell?

## #8 Re: Introductions » Greetings! » 2013-04-27 07:02:29

i218 .photobucket. com

## #9 Re: Introductions » Greetings! » 2013-04-27 07:01:14

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

## #10 Re: Introductions » Greetings! » 2013-04-27 06:59:17

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

## #11 Re: Introductions » Greetings! » 2013-04-27 06:56:59

the cell underneath the random coin flips I was trying to get number of wins in there and I can't figure out how to have that work. The yes/no worked but I am still kinda lost on how to get the number of wins to come out.

## #12 Re: Introductions » Greetings! » 2013-04-27 06:49:10

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

## #13 Re: Introductions » Greetings! » 2013-04-27 06:48:02

ok the yes and no one worked.

## #14 Re: Introductions » Greetings! » 2013-04-27 06:42:21

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

## #15 Re: Introductions » Greetings! » 2013-04-27 06:40:48

the B3 cell seams to remain at zero and never changes.

## #17 Re: Introductions » Greetings! » 2013-04-27 06:08:49

/albums/cc214/Hayabusakota/ScreenShot2013-04-27at15702PM.png

## #18 Re: Introductions » Greetings! » 2013-04-27 06:00:17

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

## #19 Re: Introductions » Greetings! » 2013-04-27 05:48:29

I believe I might be able to post. the picture here let me see.

## #20 Re: Introductions » Greetings! » 2013-04-27 05:29:40

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

## #21 Re: Introductions » Greetings! » 2013-04-27 05:21:40

Hey Bob I was trying to run the coin simulation in excel and while I get the first bar correctly working the next 3 bars that give you results seam to not work. I am using excel on a mac.

## #22 Re: Introductions » Greetings! » 2013-04-27 03:33:47

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.

## #23 Re: Introductions » Greetings! » 2013-04-27 02:44:11

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!

Sincerely,

JoshH

## #24 Re: Introductions » Greetings! » 2013-04-26 21:19:31

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)

=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

## #25 Re: Introductions » Greetings! » 2013-04-26 18:40:03

wont let me post up the whole link

http://www.mathisfunforum.com/viewtopic … =17437&p=1 inserted by mod.