I would appreciate any help you could give me.
i've attached the file, and just so you know reds and blacks are not assigned to even and odd numbers they are: I was wondering if any of you may be able to help me figure out how to do this. of times there were 10 of same colour in a row: 3 of times there were 9 of same colour in a row: 4 of times there were 8 of same colour in a row: 6 of times there were 7 of same colour in a row: 13 of times there were 6 of same colour in a row: 27 of times there were 5 of same colour in a row: 48
So basically i would like another part of the spreadsheet to read, for example: And the same again for 6 times, 7 times and so on.
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. Hi, I have a simple roulette simulator which generates 10,000 spins in excel using random generate between 0 and 36.
