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