Math Is Fun Forum

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

You are not logged in.

#101 2013-05-04 11:23:54

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.

Offline

#102 2013-05-26 11:23:02

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)

Offline

#103 2013-05-26 11:30:47

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.

Offline

#104 2013-05-26 11:32:01

tommoy
Member
Registered: 2013-05-26
Posts: 3

Re: anyone good with doing math on excel?

Where is the excel simulation?

Offline

#105 2013-05-26 11:39:13

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.

Offline

#106 2013-05-26 12:11:57

tommoy
Member
Registered: 2013-05-26
Posts: 3

Re: anyone good with doing math on excel?

thanks for the help

Offline

#107 2013-05-26 12:19:38

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.

Offline

#108 2019-02-20 19:29:01

Bob
Administrator
Registered: 2010-06-20
Posts: 10,052

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 smile

Offline

Board footer

Powered by FluxBB