No video

Lottery Numbers in a Spreadsheet

  Рет қаралды 294,979

AssocTeachersMaths

AssocTeachersMaths

Күн бұрын

goo.gl/MXbT - Using a spreadsheet to analyse lottery number statistics and frequencies

Пікірлер: 50
@Paul998-B
@Paul998-B 4 жыл бұрын
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...
@scotsguy422
@scotsguy422 12 жыл бұрын
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!
@ericp9990
@ericp9990 2 жыл бұрын
Hello, great video. I was wondering if its possible to track the 6 number combinations and see how many times they were drawn?
@BrutusJones
@BrutusJones 4 жыл бұрын
Is there a way for Excel to do a prediction based on past winning numbers?
@kltan888
@kltan888 4 жыл бұрын
i have try follow your step but only bonus column has count . the rest no counted.
@timryan8867
@timryan8867 8 жыл бұрын
I am using the most recent version of excel and cannot get the 2 column graph you created. Anyone?
@kemi7689
@kemi7689 11 жыл бұрын
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
@yuthistak1852
@yuthistak1852 5 жыл бұрын
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
@26dragon76
@26dragon76 14 жыл бұрын
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,
@jasonparker333
@jasonparker333 8 жыл бұрын
Good video but can you leave out the banners please as these were getting in my view
@josecazares9286
@josecazares9286 4 жыл бұрын
Hello friend what is the page to download the history of lottery numbers please :(
@mari0275
@mari0275 10 жыл бұрын
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?
@petern9262
@petern9262 9 жыл бұрын
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-B
@Paul998-B 4 жыл бұрын
I get to 4-40 and the thing go's red and wont do the numbers.???
@italyralfy93
@italyralfy93 13 жыл бұрын
very simple to follow , it's great
@jameswilliamson6021
@jameswilliamson6021 7 жыл бұрын
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
@gulbe2000
@gulbe2000 9 жыл бұрын
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.
@josecazares9286
@josecazares9286 4 жыл бұрын
Hello friend, I am interested in uk premier football results and statics please :(
@kpkaus
@kpkaus 5 жыл бұрын
What formula can I use to find out, how many times 1 and 2 appeared together or 1 and 3 appeared together?
@MarkNorville
@MarkNorville 5 жыл бұрын
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.
@sithembisomdlalose7178
@sithembisomdlalose7178 3 жыл бұрын
@@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
@christopherbeasley8836
@christopherbeasley8836 5 жыл бұрын
How can I use excel to make sure the numbers I pick have never won before?
@MarkNorville
@MarkNorville 5 жыл бұрын
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.
@cynthiacoc6400
@cynthiacoc6400 6 жыл бұрын
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...
@spassky64
@spassky64 6 жыл бұрын
With SPSS is easy, use find dupplicates
@cynthiacoc6400
@cynthiacoc6400 6 жыл бұрын
thank you will try
@dificileambroise9523
@dificileambroise9523 11 ай бұрын
I want play i dont no😢😢
@4reyes2
@4reyes2 12 жыл бұрын
thank you I was looking for a way to do this.
@Nokiunia
@Nokiunia 12 жыл бұрын
link seems fishy..it doesnt open to you tube
@dave11282
@dave11282 8 жыл бұрын
nice vid, soothing voice
@iblessyou.forextrablessing7597
@iblessyou.forextrablessing7597 7 жыл бұрын
everyone can do that. but you didn't provide the gese to strike lottery.
@Nev2122
@Nev2122 7 жыл бұрын
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
@aungmyint4773
@aungmyint4773 2 жыл бұрын
Hello
@KpxUrz5745
@KpxUrz5745 5 жыл бұрын
Frequency of #38 proves: ------ exactly Nothing.
@denniscalafatilotto
@denniscalafatilotto 3 жыл бұрын
bogus they use many different machines and ballsets tracking them useless
@hem9903
@hem9903 9 жыл бұрын
thank you very much it was useful
@finisher3x
@finisher3x 5 жыл бұрын
Everything is taught better, when you have a British accent.
@AkwasiMintah-jv2rb
@AkwasiMintah-jv2rb 11 ай бұрын
Akwasi
@mienzillaz
@mienzillaz 6 жыл бұрын
waste of time.. i was looking for real analysis not just the count of occurrence..
@ecarusnock
@ecarusnock 3 жыл бұрын
Try " DEFINE LOTTO SYSTEM " Try " HOW TO WIN LOTTO WITH BARE MINIMUM OUTLAY " See " WIN LOTTO WITH FIVE GAMES .."
@mienzillaz
@mienzillaz 3 жыл бұрын
@@ecarusnock weird timing, as I have picked up this project yesterday.. who are you?;)
@geshiagift3463
@geshiagift3463 3 жыл бұрын
has anyone won any money using this method?
How to Move Data Automatically Between Excel Files
11:37
Kenji Explains
Рет қаралды 69 М.
My Cheetos🍕PIZZA #cooking #shorts
00:43
BANKII
Рет қаралды 24 МЛН
The Giant sleep in the town 👹🛏️🏡
00:24
Construction Site
Рет қаралды 16 МЛН
黑天使遇到什么了?#short #angel #clown
00:34
Super Beauty team
Рет қаралды 39 МЛН
World’s Largest Jello Pool
01:00
Mark Rober
Рет қаралды 129 МЛН
Can You Pass This Excel Interview Test?
11:20
Kenji Explains
Рет қаралды 879 М.
Writing a formula from a sequence
7:32
Duane Habecker
Рет қаралды 3,4 МЛН
I saw my boss do these 10 things in Excel!
7:36
Chandoo
Рет қаралды 2,6 МЛН
10 Excel Formulas That Will Set You Apart (+Cheat Sheet)
18:04
MyOnlineTrainingHub
Рет қаралды 246 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 499 М.
Forecasting in Excel Tutorial
11:23
Kevin Stratvert
Рет қаралды 286 М.
Create an Excel Lottery Number Generator
14:15
Computergaga
Рет қаралды 837 М.
Spreadsheets #1: Introduction
13:27
ExplainingComputers
Рет қаралды 1 МЛН
My Cheetos🍕PIZZA #cooking #shorts
00:43
BANKII
Рет қаралды 24 МЛН