Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-06-2019, 06:50 AM
angExcelentflea angExcelentflea is offline Know of any Excel VBA or Excel functions that can help with general lottery forecasting? Windows XP Know of any Excel VBA or Excel functions that can help with general lottery forecasting? Office 2007
Novice
Know of any Excel VBA or Excel functions that can help with general lottery forecasting?
 
Join Date: Aug 2019
Posts: 3
angExcelentflea is on a distinguished road
Default Know of any Excel VBA or Excel functions that can help with general lottery forecasting?

Permission to post, admins...

Since this group doesn't have any search function, I have no way of telling if the topic of my post has already been made before.
I am only concerned with general, simple lottery forecasting concerns.

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...
Reply With Quote
  #2  
Old 08-08-2019, 12:31 PM
p45cal's Avatar
p45cal p45cal is offline Know of any Excel VBA or Excel functions that can help with general lottery forecasting? Windows 10 Know of any Excel VBA or Excel functions that can help with general lottery forecasting? Office 2016
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Quote:
Originally Posted by angExcelentflea View Post
Know of any Excel VBA or Excel functions that can help with general lottery forecasting?
No. Although it should be possible to put together such statistics as you suggest, they seem to be based on the premise that past results influence future results which in a truly random situation doesn't happen.
If I toss a coin 100 times and each time it turn up heads, the chance of it turning up tails on the 101st toss is still 1 in 2.
In fact, faced with such statistics, I'd bet on the 101st toss being heads again because it looks likely the coin is heads on both sides or there's some other bias causing it to land showing heads. But this is no longer random. The chances of a lottery not being random should be zero.
Reply With Quote
  #3  
Old 08-08-2019, 10:31 PM
angExcelentflea angExcelentflea is offline Know of any Excel VBA or Excel functions that can help with general lottery forecasting? Windows XP Know of any Excel VBA or Excel functions that can help with general lottery forecasting? Office 2007
Novice
Know of any Excel VBA or Excel functions that can help with general lottery forecasting?
 
Join Date: Aug 2019
Posts: 3
angExcelentflea is on a distinguished road
Default

So, does that mean no Excel function can do anything about that?
How user-defined VBA functions?
Reply With Quote
  #4  
Old 08-09-2019, 12:19 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Know of any Excel VBA or Excel functions that can help with general lottery forecasting? Windows 7 64bit Know of any Excel VBA or Excel functions that can help with general lottery forecasting? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

If predictions were possible, the Lottery would be out of business Perhaps take a few moments to brush up your theory on probabilities of independent events
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 08-09-2019, 02:05 AM
p45cal's Avatar
p45cal p45cal is offline Know of any Excel VBA or Excel functions that can help with general lottery forecasting? Windows 10 Know of any Excel VBA or Excel functions that can help with general lottery forecasting? Office 2016
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Quote:
Originally Posted by angExcelentflea View Post
So, does that mean no Excel function can do anything about that?
Correct. No function, statistical analysis, user-defined function, Excel or not, can help forecast a random general lottery.
Quote:
Originally Posted by angExcelentflea View Post
How user-defined VBA functions?
While it should be possible (with a bit of work) to produce the statistics you want in (a), (b) and (c), these statistics will not help at all in forecasting a random general lottery.
Reply With Quote
  #6  
Old 08-09-2019, 05:50 PM
Kenneth Hobson Kenneth Hobson is offline Know of any Excel VBA or Excel functions that can help with general lottery forecasting? Windows 10 Know of any Excel VBA or Excel functions that can help with general lottery forecasting? Office 2016
Advanced Beginner
 
Join Date: Jun 2018
Posts: 37
Kenneth Hobson is on a distinguished road
Default

If it was not random, then you would make a lot of money if someone made this macro for you. I had thought about doing that sort of thing in the past. The idea for not random would be that as balls get picked more frequently, it is likely that one or more of those would turn up again. Of course if the ball or balls are replaced at some point, the frequency will likely drop or increase. Someone knows how often balls are replaced. My guess is that they replace all balls periodically.

If you want help with that sort of thing, you should make the file with the history of past results and attach that file. I don't know if this forum prohibits this sort of post or not.

I have helped people refine random pick5 with powerball. e.g.
Quote:
R1 R2 R3 R4 R5 PB
11 21 31 41 57 14
03 14 25 51 53 10
17 32 42 45 55 10
History:
Quote:
DrawDate WB1 WB2 WB3 WB4 WB5 PB PP tf
1/18/2017 41 9 58 40 53 12 2 FALSE
1/14/2017 55 69 23 64 59 13 5 FALSE
1/11/2017 1 16 13 43 3 24 2 FALSE
1/7/2017 37 63 12 24 3 10 2 FALSE
1/4/2017 17 16 42 41 29 4 3 FALSE
pp=powerplay, tf=True if a ball is same as powerball. For 20 years, there was a 9% chance that tf=True.

I think that I would trust my random picks over the random picks at the lotto machines. I only get a PB pick when it gets over 200 million. I mean, what can one do with a measly 199 million?
Reply With Quote
  #7  
Old 08-11-2019, 05:15 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Know of any Excel VBA or Excel functions that can help with general lottery forecasting? Windows 7 64bit Know of any Excel VBA or Excel functions that can help with general lottery forecasting? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi and welcome
Please,do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question

Do not post any further responses in this thread until a link has been provided to these cross posts.
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
lottery, lottery forecasting, lotto

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Know of any Excel VBA or Excel functions that can help with general lottery forecasting? Excel VBA interprets numeric values from worksheet formatted as General in several ways ArviLaanemets Excel Programming 1 03-08-2018 01:58 AM
Know of any Excel VBA or Excel functions that can help with general lottery forecasting? Excel General Question Excel#1 Excel 1 07-09-2015 11:16 PM
Know of any Excel VBA or Excel functions that can help with general lottery forecasting? excel functions Dotty Excel 1 05-11-2015 03:38 PM
implementing integral & gamma functions in excel pid3control Excel 0 05-05-2015 01:10 PM
Know of any Excel VBA or Excel functions that can help with general lottery forecasting? Excel 2010 Functions cmf10 Excel 6 07-02-2014 08:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft