motizer
motizer
  • Threads: 2
  • Posts: 2
Joined: Oct 18, 2011
October 18th, 2011 at 2:54:52 PM permalink
Michael -

I calculated the odds of the "All" bet by programing an MS Excel 2003 spreadsheet with a macro that examined all 3,628,800 possible winning combinations of the 10 numbers required to win this bet, created a 10 fraction product for each combination, and then summed the products for the odds of winning this bet. I didn't calculate the odds of losing because my answer for the winning odds matched yours, thus the odds of losing is just the difference from 1. However, I was wondering if there were actually an easier way to calculate this. Despite the fact I'm an amateur at Visual Basic, I still enjoy solving math problems with for/next loops and other basic programming techniques. The program took 21 hours 44 minutes to run and resulted in the number: 0.00525770409619906. It took me about 4 or 5 hours to program it over a week's time to make sure it would run effectively. The "All" wager at the Aria casino pays 176 for 1 so the house hold percentage is only 7.464407907%. If there is an easier way to calculate this, would you please post it?

Thank you
Motizer
I'm just another water molecule in a sea of ignorance.
  • Jump to: