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

You are not logged in.

## #76 2013-05-04 00:11:07

bobbym

Online

### Re: anyone good with doing math on excel?

Okay, no problem. I will come up with something.

In mathematics, you don't understand things. You just get used to them.
I have the result, but I do not yet know how to get it.
All physicists, and a good many quite respectable mathematicians are contemptuous about proof.

## #77 2013-05-04 00:12:48

anonimnystefy
Real Member

Offline

### Re: anyone good with doing math on excel?

Okay, thanks.

The limit operator is just an excuse for doing something you know you can't.
“It's the subject that nobody knows anything about that we can all talk about!” ― Richard Feynman
“Taking a new step, uttering a new word, is what people fear most.” ― Fyodor Dostoyevsky, Crime and Punishment

## #78 2013-05-04 00:55:02

ElainaVW
Full Member

Offline

### Re: anyone good with doing math on excel?

I would like to see a new problem too

## #79 2013-05-04 02:54:46

bobbym

Online

### Re: anyone good with doing math on excel?

I am posting it now.

In mathematics, you don't understand things. You just get used to them.
I have the result, but I do not yet know how to get it.
All physicists, and a good many quite respectable mathematicians are contemptuous about proof.

## #80 2013-05-04 04:00:07

phrontister
Real Member

Offline

### Re: anyone good with doing math on excel?

Hi Bobby and stefy,

#### bobbym wrote:

Are you attempting to solve this with a simulation?

Yes...as per the question. I hadn't even considered the much sounder and accurate mathematical alternative and the craziness of such a large sim!

Thanks for the fix for my B version, Bobby...took me a while to understand it, but I finally got it.

I tried the codes that both of you posted, but I particularly like this sim one of stefy's as it's brief, fast and I can understand it:

#### anonimnystefy wrote:

Here is my own code with no strings:

#### Code:

`Count[Table[RandomInteger[], {10000}, {10}], {___, 1, 1, 1, 1, ___}]/10000 // N`

I didn't know that pattern trick, so that was nice to learn.

This slightly amended code reduces processing time by about 40%:

#### Code:

`Count[Table[RandomInteger[1, 10], {10000}], {___, 1, 1, 1, 1, ___}]/10000 // N`

That blindingly-fast code in post #58 erred if I'd used 'a' or 'n' elsewhere in the current M run, but "ClearAll["Global`*"];" at the beginning fixed that. Found it on the net.

Last edited by phrontister (2013-05-04 04:03:11)

"The good news about computers is that they do what you tell them to do. The bad news is that they do what you tell them to do." - Ted Nelson

## #81 2013-05-04 04:05:25

bobbym

Online

### Re: anyone good with doing math on excel?

Hi;

The important part is the Tuples command, if you understand that...

In mathematics, you don't understand things. You just get used to them.
I have the result, but I do not yet know how to get it.
All physicists, and a good many quite respectable mathematicians are contemptuous about proof.

## #82 2013-05-04 04:23:15

phrontister
Real Member

Offline

### Re: anyone good with doing math on excel?

Oops! Yes, I was amazed at the speed and short code, but before understanding it properly I started reading all the other posts that followed and clean forgot to get back to it. I did look up Tuples and Cases at the time and think I'm nearly there with it, but I'll have a closer look after I've been to bed...which is where I should have been hours ago!

So many ways to skin a cat!

"The good news about computers is that they do what you tell them to do. The bad news is that they do what you tell them to do." - Ted Nelson

## #83 2013-05-04 04:28:05

bobbym

Online

### Re: anyone good with doing math on excel?

M has that feature. It is nice but it is confusing. See you later.

In mathematics, you don't understand things. You just get used to them.
I have the result, but I do not yet know how to get it.
All physicists, and a good many quite respectable mathematicians are contemptuous about proof.

## #84 2013-05-04 05:02:59

anonimnystefy
Real Member

Offline

### Re: anyone good with doing math on excel?

#### bobbym wrote:

I am posting it now.

Thanks!

The limit operator is just an excuse for doing something you know you can't.
“It's the subject that nobody knows anything about that we can all talk about!” ― Richard Feynman
“Taking a new step, uttering a new word, is what people fear most.” ― Fyodor Dostoyevsky, Crime and Punishment

## #85 2013-05-04 05:07:31

bobbym

Online

### Re: anyone good with doing math on excel?

I posted it a long time ago.

In mathematics, you don't understand things. You just get used to them.
I have the result, but I do not yet know how to get it.
All physicists, and a good many quite respectable mathematicians are contemptuous about proof.

## #86 2013-05-04 05:08:55

anonimnystefy
Real Member

Offline

### Re: anyone good with doing math on excel?

I know. But, I haven't had a chance to post when you posted it.

The limit operator is just an excuse for doing something you know you can't.
“It's the subject that nobody knows anything about that we can all talk about!” ― Richard Feynman
“Taking a new step, uttering a new word, is what people fear most.” ― Fyodor Dostoyevsky, Crime and Punishment

## #87 2013-05-04 05:11:44

bobbym

Online

### Re: anyone good with doing math on excel?

That is okay. Good luck with the problem and may the M be with you.

In mathematics, you don't understand things. You just get used to them.
I have the result, but I do not yet know how to get it.
All physicists, and a good many quite respectable mathematicians are contemptuous about proof.

## #88 2013-05-04 05:15:44

anonimnystefy
Real Member

Offline

### Re: anyone good with doing math on excel?

Well, I'll leave this one until he sees and reads it.

The limit operator is just an excuse for doing something you know you can't.
“It's the subject that nobody knows anything about that we can all talk about!” ― Richard Feynman
“Taking a new step, uttering a new word, is what people fear most.” ― Fyodor Dostoyevsky, Crime and Punishment

## #89 2013-05-04 05:21:36

bobbym

Online

### Re: anyone good with doing math on excel?

He might start working on it himself.

In mathematics, you don't understand things. You just get used to them.
I have the result, but I do not yet know how to get it.
All physicists, and a good many quite respectable mathematicians are contemptuous about proof.

## #90 2013-05-04 05:25:25

anonimnystefy
Real Member

Offline

### Re: anyone good with doing math on excel?

He probably will. I just do not want him to abandon it because a discussion of it has started.

The limit operator is just an excuse for doing something you know you can't.
“It's the subject that nobody knows anything about that we can all talk about!” ― Richard Feynman
“Taking a new step, uttering a new word, is what people fear most.” ― Fyodor Dostoyevsky, Crime and Punishment

## #91 2013-05-04 05:28:24

bobbym

Online

### Re: anyone good with doing math on excel?

Well, I hope the comments of A and C and especially D do not lead him astray.

In mathematics, you don't understand things. You just get used to them.
I have the result, but I do not yet know how to get it.
All physicists, and a good many quite respectable mathematicians are contemptuous about proof.

## #92 2013-05-04 06:02:36

anonimnystefy
Real Member

Offline

### Re: anyone good with doing math on excel?

Me too.

The limit operator is just an excuse for doing something you know you can't.
“It's the subject that nobody knows anything about that we can all talk about!” ― Richard Feynman
“Taking a new step, uttering a new word, is what people fear most.” ― Fyodor Dostoyevsky, Crime and Punishment

## #93 2013-05-04 06:43:15

bobbym

Online

### Re: anyone good with doing math on excel?

Okay, I have to go shopping so I will see you later.

In mathematics, you don't understand things. You just get used to them.
I have the result, but I do not yet know how to get it.
All physicists, and a good many quite respectable mathematicians are contemptuous about proof.

## #94 2013-05-04 07:17:50

anonimnystefy
Real Member

Offline

### Re: anyone good with doing math on excel?

Okay, see you.

The limit operator is just an excuse for doing something you know you can't.
“It's the subject that nobody knows anything about that we can all talk about!” ― Richard Feynman
“Taking a new step, uttering a new word, is what people fear most.” ― Fyodor Dostoyevsky, Crime and Punishment

## #95 2013-05-04 09:19:45

bobbym

Online

### Re: anyone good with doing math on excel?

Where am I going? Bought some food and I am eating it.

In mathematics, you don't understand things. You just get used to them.
I have the result, but I do not yet know how to get it.
All physicists, and a good many quite respectable mathematicians are contemptuous about proof.

## #96 2013-05-05 00:42:30

phrontister
Real Member

Offline

### Re: anyone good with doing math on excel?

Hi Bobby,

#### bobbym wrote:

...and may the M be with you.

And May the Fourth be with you!

Yes...that Tuples command is interesting, generating all those possibles like that. Length was new to me too, and I didn't know about the use of "//" either. So...thanks for introducing them.

Early to bed for a change. Catch you later.

"The good news about computers is that they do what you tell them to do. The bad news is that they do what you tell them to do." - Ted Nelson

## #97 2013-05-05 01:50:29

bobbym

Online

### Re: anyone good with doing math on excel?

The Fourth?

Have a good night.

In mathematics, you don't understand things. You just get used to them.
I have the result, but I do not yet know how to get it.
All physicists, and a good many quite respectable mathematicians are contemptuous about proof.

## #98 2013-05-05 08:45:14

phrontister
Real Member

Offline

### Re: anyone good with doing math on excel?

#### bobbym wrote:

The Fourth?

Either that's today's date, or I've developed a bad spelling lithp.

"The good news about computers is that they do what you tell them to do. The bad news is that they do what you tell them to do." - Ted Nelson

## #99 2013-05-05 08:47:23

bobbym

Online

### Re: anyone good with doing math on excel?

I thought it was the fifth over there.

In mathematics, you don't understand things. You just get used to them.
I have the result, but I do not yet know how to get it.
All physicists, and a good many quite respectable mathematicians are contemptuous about proof.

## #100 2013-05-05 09:01:30

phrontister
Real Member

Offline

### Re: anyone good with doing math on excel?

It is now, but not when I wrote that last night. I'd waited with that post until it was the fourth both in Oz and the U.S.

"The good news about computers is that they do what you tell them to do. The bad news is that they do what you tell them to do." - Ted Nelson