Most probable digit return ?

[serge]

Hi,
I wanted to know if it would be possible to create a formula or code that would return in cell M3 the most probable digit 1,2,3, which start in column M6:M317 ? Thank you.

1

1

1

1

1

1

1

3

2

3

3

3

1

2

3

1

2

3

1

1

3

2

3

1

3

3

2

1

1

3

3

1

1

3

2

1

2

1

2

2

2

1

2

3

2

1

1

3

1

1

3

2

3

2

3

3

2

2

2

1

2

2

1

3

1

3

3

2

3

2

1

3

1

2

3

3

3

2

2

2

2

2

3

1

3

1

1

3

2

2

3

2

3

1

3

3

1

2

3

1

2

2

1

3

2

1

1

1

1

2

3

1

1

3

1

1

2

1

2

2

1

2

3

2

2

2

3

3

1

3

2

3

3

1

1

3

1

2

1

3

1

2

3

1

2

2

2

2

3

2

1

3

1

2

2

3

2

1

1

3

2

3

3

3

3

1

3

2

1

3

2

3

2

1

3

1

3

3

1

1

3

3

2

1

1

1

1

3

1

1

1

1

3

2

2

2

3

1

1

3

2

2

1

2

3

1

3

2

3

2

2

3

1

1

3

3

1

2

3

3

1

1

3

2

3

1

2

3

1

3

2

2

3

2

2

2

3

1

3

3

2

3

2

1

2

3

2

2

1

2

3

2

2

1

3

3

3

2

3

3

1

1

2

3

1

3

1

1

2

3

2

2

2

3

3

2

3

3

1

1

1

1

3

1

3

3

3

1

3

1

1

2

3

2

2

1

3

2

2

1

3

3

2

2

2

2

3

3

2

3

1

3

 

[LogChief]

Have you tried Mode.Sngl?

=MODE.SNGL(M6:M317)

 

[serge]

Thank you LogChief for your quick response, I copy/paste your formula but it returned " #NAME? " is that because I'm still in 2007 ?

 

[LogChief]

Thank you LogChief for your quick response, I copy/paste your formula but it returned " #NAME? " is that because I'm still in 2007 ?

Thank you LogChief for your quick response, I copy/paste your formula but it returned " #NAME? " is that because I'm still in 2007 ?

Just use the older function MODE:

=MODE.SNGL(M6:M317)

 

[serge]

I don't understand it's the same as post 2 ??

 

[LogChief]

I don't understand it's the same as post 2 ??

Sorry, something happened to the post. Use the older function, MODE:

=MODE(range)

That will give return the number that occurs the most times, i.e., the most probable.

 

[serge]

Thanks, I'm not looking for the digits that occur the most times, but the digit that would be the most probable to return according to the orders of that list.

 

[hagia_sofia]

Thanks, I'm not looking for the digits that occur the most times, but the digit that would be the most probable to return according to the orders of that list.

Hello, could you please expain in more detail what is it that you are looking for? If it is which of the numbers within the given data has the highest chance to be randomly picked, then based on a large number of iterations @LogChief's answer is correct.

 

[hagia_sofia]

I am not sure about the compatibility but maybe you could test it by using:

=INDEX($M$6:$M$317,RANDBETWEEN(1,ROWS($M$6:$M$317)),1)

Drag this formula down to cover e.g. 10,000 cells and then count how many times each digit was picked.

 

[serge]

Thank you hagia_sofia, when I use your formula and I pasted it in my next column, the data in the previous columns change Why ? for my understanding I need the return to be solid and not change I guess it would take a long analyzed study of the digits tread, maybe that can not be done, Oh well Thank you for trying I really appreciate you guys help.
Here below is the beginning portion of my table.