View Single Post
 
Old 08-08-2019, 12:31 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Quote:
Originally Posted by angExcelentflea View Post
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.
Reply With Quote