LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 829
Default List all combinations of 6/36 with unique 4 numbers

"Martin-888" wrote:
It is part of a lottery strategy, but it does imply buying
all the 320 combinations [...], therefore guaranteeing at
least one win of the 4 out of 6 prize.


Sounds like a scam.

Please provide a URL (http://...) for the website that describes the
strategy or offers the product.

Also, please provide a URL (http://...) for the particular lottery.


"Martin-888" wrote:
I'm not very good in math, but since there is 1 chance
out of 320, it made me believe that there was many groups
of 320 combinations.


No. For example, there are 6525 ways (tickets) of matching exactly 4 out of
6 numbers drawn. That translates into about a 1 in 298.5 chance of matching
exactly 4, since there are 1,947,792 possible drawings (tickets) of 6 out of
36 numbers.

I still do not understand where 320 comes from. That is why I would like
the URLs that I requested above. They probably don't explain the math
directly. But they might have information that I can use to intuit the
computation.

For now, I stand by my finding that you would have to buy 2240 tickets in
order to be sure to match at least 4 of 6.

Of course, that makes sense to do only if the payout for matching exactly 4
is more than $2240, assuming $1 per ticket. (And of course, by "$", I mean
whatever your currency is.)

I suspect you will find that the payout is much smaller. Otherwise,
everyone would be doing this.

"If it sounds too good to be true, it usually is".


"Martin-888" wrote:
In my 4 out of 6 unique combinations, the 4 out of 6 has
to be completely unique

[....]
Is this how you first understood my question


Yes. You can download the file "uniq 4 from 6 of 36.xls" from
https://www.box.com/s/2a361ad6de78e8f4865e.

Columns A and B are somewhat configurable by changing A1, A2 and A3.
However, the table starting at A11 might need to be adjusted manually.

The macro that generates the results in columns D through I is hardwired for
the particular parameters that you mentioned, namely: drawing 6 of 36
numbers, and generating all combinations with unique sets of 4 numbers.

I hardwired the numbers in order to ensure the best performance.

The worksheet and macro might not be very self-explanatory. Let me know if
you have any questions or comments.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sum up combinations of numbers from list to get specific total KMiles Excel Discussion (Misc queries) 3 May 15th 23 11:45 AM
Unique combinations of records in a list Leon Excel Programming 7 July 3rd 08 10:29 PM
Unique random numbers from list Matt Excel Discussion (Misc queries) 3 January 23rd 08 09:36 PM
List of unique texts and numbers vsoler Excel Worksheet Functions 7 May 19th 07 06:47 PM
how to extract unique numbers once from a list of repeated numbers? [email protected] Excel Discussion (Misc queries) 2 May 2nd 06 04:17 PM


All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"