|
What makes KenoRND() Unique?
KenoRND() is based on live games of Keno from real casinos.
There are no other random number generators that are based on live Keno that I am aware of.
Keno is a game made up of 80 total balls, and then 20 balls are pulled out at random.
At first glance, it is not obvious how many possible ways a given Keno game can be played out, but the number is huge.
In fact there are actually 8,601,077,741,927,290,708,534,393,031,884,800,000 ways (or permutations) a given game of Keno can end.
That number is so large that most programming languages cannot deal with that number with the built in math functions.
Try pasting that number into Excel, and it will round the number to 8,601,077,741,927,290,000,000,000,000,000,000,000 because Excel is not designed to handle numbers that large.
Many stock random number generators can only generate numbers up to the size of a quadrillion.
But because of the vast number of ways a Keno game can end, you can generate a number up to the size of a undecillion (which is defined as a number with 36 zeros) using KenoRND().
This makes KenoRND() very unique.
If a random number generator is capable of generating a single bit, then it can be used to generate a number infinite in size, so you can create random numbers with stock generators larger than a quadrillion, but not in a single pass.
The formula to determine how many possible ways a given game of Keno can finish is basically (80!)/((80-20)!).
This formula takes into consideration the order in which each ball comes out.
Keno players only care what numbers come out, not which order they come out.
I take the order into consideration to increase the precision of KenoRND().
You can use a shortcut to estimate this number in Excel by using the function Permut(80,20), but as I said earlier, it will round the number.
|