Know of any formulas or VBA for some lottery prediction tasks?

[angExcel-entflea]

Permission to post, admins...

As per advice of a moderator, I did a search related to lottery and pulled up search results of topics totally unrelated to what I'm specifically asking for. If it isn't a topic about pick-3, it's either about random number generation or predicting numbers from a really huge pool - like 15 numbers out of 25, or 5 numbers out of 90...

So, I'm wondering if anyone here knows some VBA formulas or Excel functions for the following tasks:

a) Counting the frequency of each number in a lottery game

b) Determine which are "hot" numbers, "cold" numbers and "overdue" numbers within a certain draw period in a lottery game

c) Know how many times a number is paired with another number

Hope you would consider helping me out in this...

PS - Due to earlier circumstances, was forced to post this concern in other Excel forums. Here's the link to the other forum: https://www.mrexcel.com/forum/excel-...recasting.html

[AliGW]

I suggest you find all posts by forum member Jorel - there are over a thousand all to do with predicting lottery outcomes.

https://www.excelforum.com/search.php?searchid=9760691

[AliGW]

I am sorry that Jorel's threads did not prove of any use to you.

Please continue here now.

For your information: I did NOT instruct you not to post here. I merely pointed you to some threads that I thought might be of interest to you. This thread is and has always been open.

[MrShorty]

Are you required to use VBA formulas only, or will you consider spreadsheet formulas?

a) would probably be a COUNTIFS() (or maybe a FREQUENCY()) function: https://support.office.com/en-us/art...c-aa8c2a866842
Even if I were doing this in VBA, I would probably call the worksheet function from VBA: https://docs.microsoft.com/en-us/off...n-visual-basic

b) A lot of this question depends on exactly what "hot", "cold", etc. actually means. My guess (as someone who does not do any serious gaming) is these categories involve some comparison between the results of step (a) and theoretically expected frequencies. Exactly what that looks like probably depends on what your table of theoretical frequencies looks like (and whether or not this part of the question includes calculating those theoretical frequencies). Assuming that the question does not include calculating the theoretical frequencies, I would expect this question to involve either IF() or CHOOSE() or a lookup (like VLOOKUP()) function.

c) Also looks like an application for COUNTIFS(). The only thing really different from (a) is that you will need a table of pairings that you want to count.

Excel function help files by category: https://support.office.com/en-us/art...rs=en-US&ad=US
alphabetical list: https://support.office.com/en-us/art...6-c6d90033e188

I'm not sure exactly what parts of these tasks you will need help with, but let us know what you need help with and we'll see how we can help.

[angExcel-entflea]

Reply intended for Ms. AliGW

Though I have already written this in the other thread, I am re-posting this reply as an apology if my previous statement bore some resentment on my part. If Jorel has come across this, I hope he would know about what I'm asking for. If not, I hope he can refer me to someone in this forum, or outside of it, who can... Point taken about your FYI - mea culpa...

[AliGW]

Thanks for the apology - not needed, but appreciated.

Have you seen Mr Shorty's post above?

[angExcel-entflea]

Yes - am noting details in his reply. Thanks for your help, both of you

[AliGW]

Administrative Note:

Unfortunately it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new here, I am providing that link for you this time.)

https://www.mrexcel.com/forum/excel-...recasting.html

[angExcel-entflea]

Reply intended for Ms. AliGW:

Okay, so I'll post the link from that forum in the original post?

While the misunderstanding in this forum occurred, I was forced to seek other forums - wasn't expecting at first that this concern of mine would be answered....

I'm editing the OP (original post) to include the link...

[AliGW]

No, it's fine - as I said in my post, I've provided the link for you.

I was forced to seek other forums

Give over ... You'd jumped to conclusions and thrown a hissy fit.

Anyway, it's not the cross-posting that is the issue - in itself, it's perfectly fine. We just require you to disclose where else you've asked the question.

[jorel]

Then you have to think about filters !! mainly the dynamics,
* according to your lottery characteristic,
filter by limit of previous draws, by last digit, from 0 to 9. by cycles, by repetitions and absences, from last to next, etc., even so it can only reach a certain point in 70% to 80%, will always have the random factor is like the pareto law 75% 80% 25% to 20% take a test on 49/6
* will hit from 3.4 numbers, this is where math or statistics can go !!!, this is why sometimes a random game hits a prize, there are many variables to master. because the hit space
less than wrong, example in a game 59/5
* You have 54 to make mistakes and only 5 to get it right, you have to think about filtering to make mistakes because it is 54/5 the fight

[angExcel-entflea]

< reply intended for jorel and Ms. AliGW >

I just had this observation:

Assuming that a certain draw period - let's say "10" - was sampled for hot, cold and overdue number determination, the following would say...
a) hot numbers follow the formula: "if x >= 10 = hot"
b) cold numbers follow the formula: "if x < 10 = cold"
b) overdue numbers follow the formula: "if x = 0 = overdue"

Is this line of thought correct?
If yes, how can this be translated into a user-defined VBA function code?

[AliGW]

I think it's time you provided us with a set of sample data. What you are describing does not require VBA. Provide some sample data in the format you expect to be working with it (rows of lottery draws) and we can better advise.

[MrShorty]

Not sure what "x" represents, but I can go ahead and assume the value exists. I would guess that x represents some kind of count, but that is just a guess. Assuming that x is already calculated, the checks you describe could easily be performed using Excel's built in IF() function: https://support.office.com/en-us/art...c-aa8bbff73be2 Starting from low to high (assuming x cannot be less than 0), =IF(x=0,"overdue",IF(x<10,"cold","hot")) where x is a reference to a cell containing the desired analysis. Does that help?