Help with Odds Math - Excel maybe?

Reply #4

cottoneyedjoe — Mon, 11 Jan 2021 00:02:45 GMT

I understand what you're saying and the type of table you're describing. It's different from what Druski is describing and more difficult to compute, but is very useful.

His table is much simpler, and the odds in the table are indeed given by the formula he worked out, but a person cannot buy tickets that way so the table has no practical use. You cannot go to the gas station and tell the clerk you want to buy 24 numbers for 6/49 so that you have a 1 in 3 chance of winning the 3/6 prize, as s... [ More ]

Reply #3

db101 — Sat, 09 Jan 2021 23:32:23 GMT

Yeah that's what he means even though he doesn't understand it. I had a book with that exact same table and I also tried to fill in the gaps for the skipped values on the top row. Lost the paper where I worked them out.

The drawback of this table is that it misses a subtlety about buying wheeled sets of numbers--it only gives you the odds of hitting *at least* one 3/6, 4/6, 5/6, but it doesn't give you the individual odds of hitting exactly one, exactly two, exactly three partial matches,... [ More ]

Reply #2

Druski — Fri, 08 Jan 2021 15:03:46 GMT

Not sure exactly what you mean...

I read it to say, for example... if you wheel or play 9 numbers, the odds of 3 of them being picked would be 1 in 16.85 rather than if you only played 6 numbers your odds of 3 being picked would be 1 in 56.66..

Reply #1

cottoneyedjoe — Tue, 05 Jan 2021 02:07:27 GMT

On the Numbers Played row, I take it to mean you play every 6-number subset of a set of K numbers

Help with Odds Math - Excel maybe?

Druski — Sat, 02 Jan 2021 14:16:15 GMT

Hi Everyone;

I am trying to figure a way to produce the odds for wheeled combinations and not sure how to do it (I am not a math genius) and was wondering if anyone has done this before etc... my efforts searching the forums have not so far been productive. I have found the Odds Calculator here on the site and this works well but I am looking for more etc..

About 30 years ago I bought a little kit for lotto play and inside it, there was a simple chart...

What I want to do is make a