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

You are not logged in.

- Topics: Active | Unanswered

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

i218 .photobucket. com/

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.

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

i218 .photobucket. com

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

ok the yes and no one worked.

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

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

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

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

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

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

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

wont let me post up the whole link

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