Bernd,
Thank you, I basically want to predict the outcome. An educated guess so to
speak.
The result I get with the historical likelihood (which seems to be what I am
looking for) is 0.142857142857143.

Is there a way to translate that result to a "0, 1, 2, ..or 9" as an answer?
in other words as in my example, would "5" be the most likely number to be
next or something else like 0, 3, 8, 6 or so on through 9.

I want the result to be of the numbers that I put into A1:A14.

Hope this makes since.
Luke



"Bernd P" wrote:

Hello Luke,

Just a guess: If you want to have the most often occuring value, enter
into B1:
=MODE(A1:A14)

Or, if you like its "historical" likelihood:
=COUNTIF(A1:A14,MODE(A1:A14))/COUNT(A1:A14)

If that's not what you intend give another detailed example, please.

Regards,
Bernd