Math Is Fun Forum

bobbym

bumpkin

From: Bumpkinland

Registered: 2009-04-12

Posts: 109,606

Re: anyone good with doing math on excel?

I never could get used to that day after tomorrow.

---

In mathematics, you don't understand things. You just get used to them.
If it ain't broke, fix it until it is.
Always satisfy the Prime Directive of getting the right answer above all else.

tommoy

Member

Registered: 2013-05-26

Posts: 3

Re: anyone good with doing math on excel?

Im having problems with the coin question, can u explain more please? Here's the question

You are going to play a game where you bet a dollar and get to flip a coin ten times. If you get four heads in a row, you win. If you make the tenth flip without getting four heads in a row, you lose. Run this game ten thousand times. Approximately what is the probability that you will win?

Last edited by tommoy (2013-05-26 11:23:52)

bobbym

bumpkin

From: Bumpkinland

Registered: 2009-04-12

Posts: 109,606

Re: anyone good with doing math on excel?

Hi;

That problem is posted in another thread if you want to see an excel simulation. What type of solution are you looking for?

---

In mathematics, you don't understand things. You just get used to them.
If it ain't broke, fix it until it is.
Always satisfy the Prime Directive of getting the right answer above all else.

tommoy

Member

Registered: 2013-05-26

Posts: 3

Re: anyone good with doing math on excel?

Where is the excel simulation?

bobbym

bumpkin

From: Bumpkinland

Registered: 2009-04-12

Posts: 109,606

Re: anyone good with doing math on excel?

http://www.mathisfunforum.com/viewtopic … 08#p265508

It is mixed in to that thread, you will have to read the posts to find the relevant information and links.

Also there was information in the beginning of this thread from phrontister and bob bundy.

---

In mathematics, you don't understand things. You just get used to them.
If it ain't broke, fix it until it is.
Always satisfy the Prime Directive of getting the right answer above all else.

tommoy

Member

Registered: 2013-05-26

Posts: 3

Re: anyone good with doing math on excel?

thanks for the help

bobbym

bumpkin

From: Bumpkinland

Registered: 2009-04-12

Posts: 109,606

Re: anyone good with doing math on excel?

Hi tommoy;

Welcome to the forum.

Just let me say this:

I sure wish someone would send a memo to the instructor who is using that as an exercise to teach his students the "the joys of programming."

Someone should tell him that is a horrible example or a great example of the misuse of a simulation. I would like to give him a piece of my mind so to speak. Nothing important, maybe just the medulla oblongata. Or maybe my left brain since according to Duke University, neanderthals like me never use it.

According to the ZAA, the left brain when viewed under the microscope is made up of tiny i's with little hearts over them while the right brain smells like old socks and gym shorts.

---

In mathematics, you don't understand things. You just get used to them.
If it ain't broke, fix it until it is.
Always satisfy the Prime Directive of getting the right answer above all else.

Bob

Administrator

Registered: 2010-06-20

Posts: 10,621

Re: anyone good with doing math on excel?

hi Wolfwood7388

Have a look at my post 12.  Is this what you're asking about?  In which case, are you able to say what needs more explanation.

=COUNTIF(L2:L10001,>0) this returns an error

I checked the syntax for this function and found this example:

=COUNTIF(B2:B5,">55")

Counts the number of cells with a value greater than 55 in cells B2 through B5. The result is 2.

So try adding the ""s

Bob

---

Children are not defined by school ...........The Fonz
You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei
Sometimes I deliberately make mistakes, just to test you!  …………….Bob