#1 Roulette Forum & Message Board | www.RouletteForum.cc

need some help calculating game statistics in excel

are there formulas i could use to calculate the following
looking at a column of data

1)formula to determine the largest gap between a certain result, ie to indicate longest sleep period
2) formula to calculate the average gap between a specific result
3) formula to calculate the most common (mode) gap for a specific result

any help with these formulas would be much appreciated thanks

here is an example

1   
2   <-
3   
4   
5   
6   
5   
2   <-
3   
2   <-
4   
1   
5   
6   
2   <-
4   
3   
1   
2   <-
5   
2   <-

for this example - will be interested in number 2


1)largest gap would be 5 between repeat   
2) average would be 5+1+4+3+1=14/5   
3)mode gap would be 1

any help with this would be much appreciated

thanks

get your results from distances and plug them into rx software so you can see better picture :thumbsup:

Here's a spreadsheet that calculates all requested stats except mode.  I don't know what you mean by mode. 

This one is a little better.

Also, a mistake in cell A2 was corrected from:
         =COUNTIF(A14:OFFSET(A14,A$10,0),A$3)
to:
         =COUNTIF(A14:OFFSET(A14,A$10,0),A$1)

thanks for this

by mode gap, i meant the most common gap appearance between the specific number

I might be able to implement mode (using formulas not VBA).  How important is it?  Do you still need mode?