Quote:
Originally Posted by angExcelentflea
Know of any Excel VBA or Excel functions that can help with general lottery forecasting?
|
No. Although it should be possible to put together such statistics as you suggest, they seem to be based on the premise that past results influence future results which in a truly random situation doesn't happen.
If I toss a coin 100 times and each time it turn up heads, the chance of it turning up tails on the 101st toss is still 1 in 2.
In fact, faced with such statistics, I'd bet on the 101st toss being heads again because it looks likely the coin is heads on both sides or there's some other bias causing it to land showing heads. But this is no longer random. The chances of a lottery not being random
should be zero.