| Posted: October 10, 2007, 10:21 pm - IP Logged | |
does anyone have a copy of Saliu's SuperFormula.exe ? i am using util632 for the florida lottery and need this to get the FFG.
thanks
turtle0747
Hi turtl0747,
The FFG in excel,
An example:
In an event of 1/1000 the degree of certainty is 50.01% that your number will hit within 693 drawings,
Formulas used:
=COMBIN(999;0)/COMBIN(1000;1)=0,001
=COMBIN(693;0)*(0,001^0)*(1-0,001)^(693-0)=49,99%
=1-(COMBIN(693;0)*(0,001^0)*(1-0,001)^(693-0))=50,01%
Regards