Roulette data

Hi, I have a simple roulette simulator which generates 10,000 spins in excel using random generate between 0 and 36.
I have been trying to quantify some of the results, such as finding out throughout the 10,000 spins, how many times a black number or red number shows up 5 times in a row. And the same again for 6 times, 7 times and so on.

So basically i would like another part of the spreadsheet to read, for example:
No. of spins: 10,000
No. of times there were 5 of same colour in a row: 48
No. of times there were 6 of same colour in a row: 27
No. of times there were 7 of same colour in a row: 13
No. of times there were 8 of same colour in a row: 6
No. of times there were 9 of same colour in a row: 4
No. of times there were 10 of same colour in a row: 3

I was wondering if any of you may be able to help me figure out how to do this.
PS. i've attached the file, and just so you know reds and blacks are not assigned to even and odd numbers they are:
Red (1,3,5,7,9,12,14,16,18,19,21,23,25,27,30,32,34,36)
Black (2,4,6,8,10,11,13,15,17,20,22,24,26,28,29,31,33,35)

I would appreciate any help you could give me.

Stephen

Please Login or Register  to view this content.

confirmed with ctrl+shift+ enter
will give you number of times 5 consecutive reds are found
change range to suit and the last digit is the length of sequence you wish to find
but first change all thos numbers to either red or black using

Please Login or Register  to view this content.

Hi again guys,

Thanks so much for those solutions. Really appreciated!!!!!!!!

I was wondering as well if there was a way that, instead of giving the number of consecutive Reds or Blacks in a row, it could tell me how many spins have passed without either a Red or a Black so that Zero's can be taken into the equation.

For example, a sequence of B,R,R,R,0,R,R,R,0,0,R,B would show that 10 spins have passed without a Black number, but with the last worksheet only two sets of 3 consecutive Reds would have shown up.

If there was anyway this could be achieved i would really appreciate it.

Stephen

Thanks for the help again guys.

do any of u know how to formulate the following scenario:

to count how many times 8 reds occur in a row, followed by a zero, followed by a red
to count how many times 8 reds occur in a row, followed by a zero, followed by a black

to count how many times 9 reds occur in a row, followed by a zero, followed by a red.
to count how many times 9 reds occur in a row, followed by a zero, followed by a black.

etc. etc.

It would be great if somebody could update this attachment as i have a little trouble understanding the longer formulas.

All help much appreciated.

Stephen

Originally Posted by martindwilson

=SUM(--(FREQUENCY(IF(A1:A35<>"B",ROW(A1:A35)),IF(A1:A35="B",ROW(A1:A35)))=10))
would tell you the number of times there were sequences of EXACTLY 10 when no black spun
again array entered
Dont forget you could Change =10 to say =B1 and put in b1 the number of times you want checked instead
or even
in row 1
=SUM(--(FREQUENCY(IF($A$1:$A$35<>"B",ROW($A$1:$A$35)),IF($A$1:$A$35="B",ROW($A$1:$A$35)))=ROW()))
again array entered and dragged down this would increment by 1 for each row dragged down so you could see at a glance by looking at row 10
number of times there were sequences of EXACTLY 10 when no black spun row 3 would show the same for sequences of 3 and so on

Hi Martin

If its not too much bother could i trouble you to enter that formula into my attached workbook. I'm a bit of a newbie with this whole excel thing, and when i copy and paste your formula it comes up with errors and doesn't seem to work. What you have explained is exactly what i want to see but i want to be able to quantify it so that i can have a table showing how many times there were sequences of exactly 10 when no black showed up for example.

Again, i'm grateful for any help.

Cheers
Stephen

stephen as requested but i dont know how to do

to count how many times 8 reds occur in a row, followed by a zero, followed by a black

those! (and i cant open xlsx from work)

Hi Martin

Thanks again for your help. Unfortunately I don't seem to be able to paste that formula into my workbook (not sure why it doesnt work- as i said i'm at a very basic level with excel...)

I've attached another workbook and saved it this time as an .xls file, it shows exactly the set-up i'm trying to achieve but obviously doesn't have the formula to calculate the number of times a sequence without, say, 7 reds occurs.

Without trying to pester you, I would really appreciate it if you could enter that formula so that it works in the table i have set up. Instead of the "R" and "B", i've tried to include the numbers and the column to the right shows which numbers are Red and which are Black.

I would be grateful of any help and sorry again for the hassle.

Regards,
Stephen.

How do you change it to 1000 times in a row instead of 100?

Hi stephenhughes99

I wonder if you can confirm something for me. I'm new to this forum and would like to know the following:

The data in connection to the 10000 spins, is this based on a real 'Auto Spin' / 'Live Dealer' results or is it based on a computer programme?

Also - 0 (start) and 12 (in) shows as only coming in the once out of 10000 spins - is this correct?

Look forward to receiving your reply.

Thanks

Howdy Guys,

Granted, Steve’s idea was to simulate the American Roulette board with using the random selection request associated with Red and Black with the two Greens being 0 & 37 on this request, but suppose I were to ask if this task could be converted to the request of numbers, no colors, from the correct position on this roulette wheel. And again, the duplicate sequence of numbers so-to-speak instead of Steve’s color request.

But I see the Roulette Wheel numbers being stationary and not random. The roulette ball is the random process as to its place to stop on a number from this list.

The numbers starting with the 00 and moving clockwise would be listed correctly as,
27,10,25,29,12,8,19,31,18,6,21,33,16,4,23,35,14,2,0,28,9,26,30,11,7,20,32,17,5,22,34,15,3,24,36,13,1

Also, once the first random request sequence is finished, the next request should begin at the last number of the previous sequence and run in reverse through the wheel list of numbers listed above.

1. So, could the last number of the first random generated list, be considered as where the roulette ball is positioned as its starting point and the first number compiled

2. Then the next random generated list must run in the reverse sequence of the Roulette Wheel numbers from the starting point of the list as the last number compiled. This would be the next sequenced number compiled.

3. Then the next list generated from the forward rotation and so-on.

This would be as close to utilizing the actual play of the ball and the roulette wheel.

Thanks, Gary

how do i change this to be 100,000 spins?

Hi All

Still trying to get my head around excel - the comment below was great but is there a way to change the RED/Black code below to also include "green" for zero please ?

Thanks in advance for any help

Originally Posted by martindwilson

Please Login or Register  to view this content.

confirmed with ctrl+shift+ enter
will give you number of times 5 consecutive reds are found
change range to suit and the last digit is the length of sequence you wish to find
but first change all thos numbers to either red or black using

Please Login or Register  to view this content.

thanks for your sheet!

I am not able to download this .xls to look at it, it appears I am too new to the forum? Any way I can get this from you?

I am not able to download this SEQUENCE2.xls‎ to look at it, it appears I am too new to the forum? Any way I can get this from you?

Originally Posted by FDibbins

Which post did you try from?

Hey FDibbins, I tried downloading again from post #11 and it worked.

Not sure but last night it kept asking me to log in then it would say something to the effect that I couldn't download this because I didn't have sufficient privileges.

how to download excel file?