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

You are not logged in.

## #51 2013-05-03 21:50:45

anonimnystefy
Real Member

Offline

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

They take the same time.

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

## #52 2013-05-03 21:53:49

bobbym

Offline

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

Go to 100000, I am getting a marked difference then.

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.

## #53 2013-05-03 21:56:50

anonimnystefy
Real Member

Offline

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

Ah, I see it.

So, Table is slower at getting 10 random numbers than RandomVariate?

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

## #54 2013-05-03 21:58:01

bobbym

Offline

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

Yes, Random Variate is much faster. You try to avoid loops in M coding. Table is like a loop.

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.

## #55 2013-05-03 22:00:03

anonimnystefy
Real Member

Offline

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

Hm, so, this should be faster than both:

#### Code:

`Count[RandomVariate[DiscreteUniformDistribution[{0, 1}], {100000, 10}], {___, 1, 1, 1, 1, ___}]`

right?

Last edited by anonimnystefy (2013-05-03 22:00:15)

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

## #56 2013-05-03 22:07:03

bobbym

Offline

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

Yes, I agree. But no simulation is even faster.

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.

## #57 2013-05-03 22:10:47

anonimnystefy
Real Member

Offline

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

That is true.

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

## #58 2013-05-03 22:13:38

bobbym

Offline

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

First one in post #42 was the man until...

How fast is this?

#### Code:

```1 - (RecurrenceTable[{a[n] ==
a[n - 1] + a[n - 2] + a[n - 3] + a[n - 4], a[1] == 2,
a[2] == 4, a[3] == 8, a[4] == 15}, a, {n, 1, 10}] // Last)/1024```

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.

## #59 2013-05-03 22:26:36

anonimnystefy
Real Member

Offline

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

Could you explain it a bit?

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

## #60 2013-05-03 22:28:52

bobbym

Offline

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

It is time for you to see 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.

## #61 2013-05-03 22:29:30

anonimnystefy
Real Member

Offline

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

Sure. What is it I am to see?

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

## #62 2013-05-03 22:30:13

bobbym

Offline

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

Something wonderful. I got that from 2010 the movie.

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.

## #63 2013-05-03 22:31:16

anonimnystefy
Real Member

Offline

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

I haven't watched it. Or at least I do not remember watching it.

What is 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

## #64 2013-05-03 22:33:55

bobbym

Offline

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

A great movie that modern people have not seen.

Do you know who --------- is?

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.

## #65 2013-05-03 22:35:04

anonimnystefy
Real Member

Offline

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

I do not.

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

## #66 2013-05-03 22:36:29

bobbym

Offline

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

This is my favorite:

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.

## #67 2013-05-03 22:41:01

anonimnystefy
Real Member

Offline

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

I still do not understand how you got that recurrence.

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

## #68 2013-05-03 22:44:42

bobbym

Offline

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

Experimental math of course! Did you read the link I sent you to?

Since you have seen it I am removing the link.

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.

## #69 2013-05-03 23:09:25

anonimnystefy
Real Member

Offline

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

I read it and still do not understand the recurrence. But, if it is true then there is a closed form.

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

## #70 2013-05-03 23:16:11

bobbym

Offline

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

Solving that would be ugly beyond belief. Also, the recurrence and Fellers formula are sufficient for such a small problem.

The recurrence can be derived from the Markov chains but I do not remember how.

I derived them by counting up each a[k] individually and relying on the known fact for two coins in a row. M did the rest. Proof in the experimental sense was established  using the methods of numerical analysis.

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.

## #71 2013-05-03 23:50:11

anonimnystefy
Real Member

Offline

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

Sorry. I thought I saw a pattern that wasn't really there.

When can we get new problems in the Exercises threads? A friend of mine would like to see one which is not yet solved.

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

## #72 2013-05-04 00:01:31

bobbym

Offline

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

One from me? As soon as I solve something of worth and interest.

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.

## #73 2013-05-04 00:03:41

anonimnystefy
Real Member

Offline

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

Ok.

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

## #74 2013-05-04 00:05:17

bobbym

Offline

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

Who is your friend, may I ask?

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.

## #75 2013-05-04 00:07:16

anonimnystefy
Real Member

Offline

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

He is on the forum under the name danilodjokic997.

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