Combined overall odds

ryan8200

Active Member
Joined
Aug 21, 2011
Messages
357
Anyone can help me to calculate the combined overall odds for lotto game.

The information is at last page of the pdf that could be downloaded at link below.

Link: Atlantic Lottery

For draw game, pick 5 out of 38 balls. Total combinations is 501,942.

Thanks
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
with the first ball you have 5 chances of one of your numbers coming up out of 38
assuming one of yours comes up you have 4 chances of one coming up next out of 37 left in the draw
assuming one of yours comes up you have 3 chances of one coming up next out of 36 left in the draw
assuming one of yours comes up you have 2 chances of one coming up next out of 35 left in the draw
assuming one of yours comes up you have 1 chances of one coming up next out of 34 left in the draw

so % chance of winning is (5/38)*(4/37)*(3/36)*(2/35)*(1/34)=0.00000199226205418156%

This equates to a one in 501,942 chance to win (s you've mentioned), or 501,941-1 in bookmaking odds terms.
 
Upvote 0
with the first ball you have 5 chances of one of your numbers coming up out of 38
assuming one of yours comes up you have 4 chances of one coming up next out of 37 left in the draw
assuming one of yours comes up you have 3 chances of one coming up next out of 36 left in the draw
assuming one of yours comes up you have 2 chances of one coming up next out of 35 left in the draw
assuming one of yours comes up you have 1 chances of one coming up next out of 34 left in the draw

so % chance of winning is (5/38)*(4/37)*(3/36)*(2/35)*(1/34)=0.00000199226205418156%

This equates to a one in 501,942 chance to win (s you've mentioned), or 501,941-1 in bookmaking odds terms.


This is the probability for winning jackpot which is equivalent to reciprocal of 501,942.
My question is the games consist of draw game and instant game. For draw game, overall odds is 8.4 and 13.9 for instant game. Combined overall odds is 5.5. How to calculate the combined overall odds?

Thanks.
 
Upvote 0
if the combined odds of a win are 5.5 (which I assume is decimalised odds), then 100/5.5 = 18.18% change of a win
adding the chance of landing the jackpot as above would be so neglibible as to have no impact on this value.

For each outcome:
draw game 100/8.4 = 11.90%
instant game 100/13.9 = 7.19%
 
Upvote 0
if the combined odds of a win are 5.5 (which I assume is decimalised odds), then 100/5.5 = 18.18% change of a win
adding the chance of landing the jackpot as above would be so neglibible as to have no impact on this value.

For each outcome:
draw game 100/8.4 = 11.90%
instant game 100/13.9 = 7.19%

Thanks for the reply. Anyway, this is not the output that I required.

Another example: (OLG Poker Lotto )
OLG - POKER LOTTO

Odds for lotto draw: 15.01
Odds for instant prizes : 4.80
Combined overall odds : 3.66

How to calculate combined odds from odds for lotto draw and instant prizes ?
 
Upvote 0

Forum statistics

Threads
1,216,426
Messages
6,130,547
Members
449,584
Latest member
kennysmith1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top