goo.gl/MXbT - Using a spreadsheet to analyse lottery number statistics and frequencies
Пікірлер: 50
@Paul998-B4 жыл бұрын
Didn't know you could get lotto numbers like that,I'v got them now,to late to the rest now,Thank you for the work and time you put in to your video,same i didn't see it 10 years ago...
@scotsguy42212 жыл бұрын
Actually what the numbers are really indicating is how remarkably uniform the series is. The process used to obtain the final result(s) could have been achieved more elegantly than shown in the video. The only way to really gain an edge for those obsessed with the idea they can win the Lotto is to break down the series further (1-9, 10-19, etc...) by Wed/Sat draw history - even then its a fools errand!
@ericp99902 жыл бұрын
Hello, great video. I was wondering if its possible to track the 6 number combinations and see how many times they were drawn?
@BrutusJones4 жыл бұрын
Is there a way for Excel to do a prediction based on past winning numbers?
@kltan8884 жыл бұрын
i have try follow your step but only bonus column has count . the rest no counted.
@timryan88678 жыл бұрын
I am using the most recent version of excel and cannot get the 2 column graph you created. Anyone?
@kemi768911 жыл бұрын
if you save it as .csv, it easier and it automatically put it in table in excel, then you can save as the excel version you want
@yuthistak18525 жыл бұрын
Very easy to learn.... but I have one question how to find out the next draw number by using excel calculations ... can help me to do that
@26dragon7614 жыл бұрын
Thank you very much for this video and teached me how to create frequency tables.I was for first time for me ,I created all national lottery and EuroMillion frequency tables for all years,and also I created different colour for all numbers between number 1 to 49 ,so I can track them very easily,but I takes 1 week for me to do coloured more than 30,000 number .for show my appreciation to you ,I really be happy to send my colour frequency table to you,I can send it to you,
@jasonparker3338 жыл бұрын
Good video but can you leave out the banners please as these were getting in my view
@josecazares92864 жыл бұрын
Hello friend what is the page to download the history of lottery numbers please :(
@mari027510 жыл бұрын
great.but how do i sort numbers across.for example i have 5 numbers 30 15 01 28 06 how do i sort and get them from lowest to highest like 01 06 15 28 30?
@petern92629 жыл бұрын
Very good video to play around with lottery results. Just make sure sure you lock table array to absolute values with frequency formula with dollar signs otherwise it won't give you true figures.
@Paul998-B4 жыл бұрын
I get to 4-40 and the thing go's red and wont do the numbers.???
@italyralfy9313 жыл бұрын
very simple to follow , it's great
@jameswilliamson60217 жыл бұрын
Hi , I have asked this question about a hundred times but i have to keep trying to find somebody to help so here goes again. I never even get a reply. Is it really that difficult because i have tried and failed a thousand times. Question How can i use combin, (not combina) to create a list of all the combinations of 24 from 35. I need to create a list from low to high in a column. Thanks Jim
@gulbe20009 жыл бұрын
Great video! Thank you! Also I have a question. I have a sequence of numbers of which some of them repeat , so I used the countif function to list how many times each number repeats if exists in the sequence. Now I want to group them(in a table) so the numbers that never occur in the sequence will be listed under 0, numbers that come up once under 1 and so on. i.e numbers : 1,2,3,4,5,6,7,8,9 ; sequence 2,3,5,3,3,7,8,6,7,5,7,5,8. So we have 1 and 9 should be listed under 0; 2,6 under 1; 8 under 2 and 3,5,7 under 3.
@josecazares92864 жыл бұрын
Hello friend, I am interested in uk premier football results and statics please :(
@kpkaus5 жыл бұрын
What formula can I use to find out, how many times 1 and 2 appeared together or 1 and 3 appeared together?
@MarkNorville5 жыл бұрын
You might have to use the countifs formula, when I am on my office PC and have some time to try this, I shall paste the formula for you, since this channel seems to be dead. However, there are programs that can do this for you. If you google smart luck, advantage gold, download the trial and then do a search for a serial code, it still works. It is good for stats, but pretty useless for picking numbers.
@sithembisomdlalose71783 жыл бұрын
@@MarkNorville hi did you succeed in getting the formula for common pairs ( lotto numbers based on history) ? if yes can you please share your method with me
@christopherbeasley88365 жыл бұрын
How can I use excel to make sure the numbers I pick have never won before?
@MarkNorville5 жыл бұрын
This is possible to do, but a lot of work and hard to explain if you do not already know how to do this. I have a spreadsheet that checks the numbers drawn against my tickets, it then uses conditional formatting to highlight numbers that I have matched, I then have a count of what lines have drawn numbers in. You could use the same to look through the previous drawings, and then count which numbers came out where, and then use a max function, so you can see what the maximum hits were.
@cynthiacoc64006 жыл бұрын
01-02-03-08-09-10-12-15-16-18-22-24 02-03-04-05-06-08-14-15-16-17-22-23 03-06-07-08-09-10-12-15-16-17-20-23 07-08-09-10-12-14-16-17-19-22-23-24 02-03-06-07-09-11-14-15-16-18-21-22 03-05-06-07-08-09-11-16-17-20-21-22 Question: Is there an excel formula that I can use to find a duplicate of all 12 numbers chosen in a lottery database over a series of data collected from 2014 to 2018. Example: I want to see how many times the 12 numbers altogether in row 1 have been duplicated in the whole database. Question 2: Once i am able to find that, is there a way in one formula to have the second row be locate in the series and so on...
@spassky646 жыл бұрын
With SPSS is easy, use find dupplicates
@cynthiacoc64006 жыл бұрын
thank you will try
@dificileambroise952311 ай бұрын
I want play i dont no😢😢
@4reyes212 жыл бұрын
thank you I was looking for a way to do this.
@Nokiunia12 жыл бұрын
link seems fishy..it doesnt open to you tube
@dave112828 жыл бұрын
nice vid, soothing voice
@iblessyou.forextrablessing75977 жыл бұрын
everyone can do that. but you didn't provide the gese to strike lottery.
@Nev21227 жыл бұрын
Guys I found a Lоtto Crusher System that helрs mе to win my first lotteryheеeere is thе link ==> twitter.com/cb3a3511bf0cbc069/status/822770318271881216 Lottery Numbeеers in a Spreadshееt
@aungmyint47732 жыл бұрын
Hello
@KpxUrz57455 жыл бұрын
Frequency of #38 proves: ------ exactly Nothing.
@denniscalafatilotto3 жыл бұрын
bogus they use many different machines and ballsets tracking them useless
@hem99039 жыл бұрын
thank you very much it was useful
@finisher3x5 жыл бұрын
Everything is taught better, when you have a British accent.
@AkwasiMintah-jv2rb11 ай бұрын
Akwasi
@mienzillaz6 жыл бұрын
waste of time.. i was looking for real analysis not just the count of occurrence..
@ecarusnock3 жыл бұрын
Try " DEFINE LOTTO SYSTEM " Try " HOW TO WIN LOTTO WITH BARE MINIMUM OUTLAY " See " WIN LOTTO WITH FIVE GAMES .."
@mienzillaz3 жыл бұрын
@@ecarusnock weird timing, as I have picked up this project yesterday.. who are you?;)