How long is it since the last number spun was last spun? Prefered repeaters!!!!!

[gingermolloy]

Hi guys,

I've had this idea and I have tested if it is true or not and I got some interesting results.

Not sure if it is a true phenomenon or a quirk of the way I am testing the hypothesis.

Here goes!

The idea was that numbers repeat right!

So is there a preferred number of spins between repeaters?

For example:

2
23
32
12
2 (repeater, 4 spins ago)
12 (repeater, 2 spins ago)

Once all 37 numbers have appeared, a repeater is guaranteed right?

so is there any advantage to be gained from knowing the amount of spins since it last appeared.

For example, if it is more likely that a number will repeat after 6 spins or 14 spins or 25 spins, then can we bet the numbers that appeared 6, 14 and 25 spins ago.

I thought to myself, there will be no difference  between the amount of times a number appears after 4,7, 12 or any number of spins. They must have the same probability.

So i set about writing an excel spreadsheet to test this.

So I set excel up to produce random numbers between 0-36 using this "=randbetween(0,36)"

I produced 2000 random numbers and for each number I recorded how many spins it had been since it last appeared (up to 25 spins)

I thought that no numbers would be prefered and that when I graphed how many spins ago since it appeard agains number of spins I would get a random distribution around an average.

This however was not the case.

Every time without fail, the same numbers were preferred.

The pattern seen was the same, obviously there were small variations in the numbers from time to time but the numbers that appeared the most were the same every time.

My question is,i is this a real phenomenon? and if so why? What is the probability of a spin being a repeater that appeared a certain number of spins ago? Do these probabilities explain the pattern?

or

is it a quirk of the RNG i am using? is excel any good as a roulette simulator? Is there any other good ways to corroborate my numbers?

I submit my questions to the masses!!

HELP

Ginger

[Rudy]

Hi Ginger,

Why not answer it yourself by continuing the experiment? i've just done a fun little spreadsheet after a suggestion from Poit on another forum. It only needed 1000 spins, but an excel spreadsheet has 65,536 lines so I carried on all the way down the page to see what would happen.

Why not do the same thing and continue your experiment? You don't have to stop there either, you can continue on other columns, so it's fairly straightforward to do a million or more spins.

Let us know your results.

Regards,

Rudy

[winkel]

Hi ginger,

the excel-number-generator is not working it produces not a random situation.
use numbers from random.org and you will find, that the distandes between same numbers follow the normal rules of statistics

br
winkel

[gingermolloy]

Hi ginger,

the excel-number-generator is not working it produces not a random situation.
use numbers from random.org and you will find, that the distandes between same numbers follow the normal rules of statistics

br
winkel

Just did that and you are correct

It becomes random no prefered repeaters.

Excel is shit, I knew it would have been that.

Why is excel so rubbish at random numbers, and not only that, but it is so shit that even me (a relative novice) can show this to be true!

Sort it out Microsoft.

Ginger

[gingermolloy]

-