Math Is Fun Forum

jackthehyper

Guest

Series or random data?

Hello everyone,
I've a matrix of values and I've to undestand if there's a relationship between the first column and the second column or it's just random data.
Can anyone help me with some math's trick?

Data:
19987    8031257
31149    7405862
57242    5130664
64871    7150492
72041    291375
94741    3605417
96179    2813950
118325    1405926
120587    9134867
134836    9264387
57342    5130674
165513    2913684
165515    348952
165517    1263947

Tnx in advance

Frank

John E. Franklin

Member

Registered: 2005-08-29

Posts: 3,588

Re: Series or random data?

The 5130664 is the only
number in the right
column that has a double
digit like 66.

The 1405926 is funny
to me because is reminds
me of pi a little.

---

igloo myrtilles fourmis

NullRoot

Member

Registered: 2007-11-19

Posts: 162

Re: Series or random data?

It's a bit tough to do it in one try. There are SO many different kinds of relationships. Just to name a few, you have Linear, Logarithmic, Polynomial, and Exponential.

One of the easiest ways (in method and accessibility) is to put the two columns into Excel and graph them. Line is normally the best unless you have multiple results for the same numbers. Make sure you sort them with the input values going from lowest to highest first! Just look at the graph and see if there's any visible relationship.

I can tell you that I've done this with the data you provided and it looks pretty random, but try it for yourself and see what you think.

---

Trillian: Five to one against and falling. Four to one against and falling… Three to one, two, one. Probability factor of one to one. We have normality. I repeat, we have normality. Anything you still can’t cope with is therefore your own problem.

MathsIsFun

Administrator

Registered: 2005-01-21

Posts: 7,713

Re: Series or random data?

How about these two:

57242    5130664
57342    5130674

First one up by 100, second one up by 10

But then these last 3:
165513    2913684
165515    348952
165517    1263947

First one changes by 2 each time, second one swings wildly.

My guess: someone typed them in, using copy-paste a lot.

---

"The physicists defer only to mathematicians, and the mathematicians defer only to God ..."  - Leon M. Lederman

jackthehyper

Guest

Re: Series or random data?

How about these two:

57242    5130664
57342    5130674

First one up by 100, second one up by 10

But then these last 3:
165513    2913684
165515    348952
165517    1263947

First one changes by 2 each time, second one swings wildly.

My guess: someone typed them in, using copy-paste a lot.

No this data come out of a program. It's like a folder structure. In different moments (we spoke of months) "folders" have been created using that progressive (I don't own all the data just a part of it) associated with the second one value. Last three results have ben generated recently by me, that's why there's not so muche change in the first column. Maybe it's just random data generated at the moment of the creation of the folder.