Excel - Mega Millions Most Popular Numbers and Strategy

Excel - Mega Millions Most Popular Numbers and Strategy - Episode 1911

Рет қаралды 34,734

Күн бұрын

Microsoft Excel Tutorial: Analyzing Mega Millions Numbers: Find the Most Popular Lottery Numbers in Excel | MrExcel Podcast.
Welcome back to the MrExcel podcast, hosted by the one and only Bill Jelen! In this episode, we delve into the intriguing world of the Mega Millions lottery, aiming to find the most popular numbers that might just change your life forever.
📈 Key Points:
📅 Downloading Mega Millions winning numbers.
📊 Preparing the data for analysis, including inserting necessary headings.
🔄 Utilizing the "unwind process" to restructure the data.
🔄 Excel versions pre-2010 using Alt D P for multiple consolidation ranges.
📆 Adding extra columns for year, new game status, and formatting the data.
🔄 Creating a pivot table for insightful analysis.
🔍 Identifying the most popular numbers over the entire game history and post-game changes.
📅 Filtering data for specific years to analyze number popularity trends.
💡 Insights and Strategies:
🤔 Analyzing the most popular numbers since the game changed in October 2013.
🔢 Understanding the impact of a smaller pool of numbers on the frequency of higher numbers.
📈 Sorting and filtering data to explore trends for specific years.
🔮 Future Considerations:
📅 Adjusting strategies based on changing trends in number popularity.
🔄 Adapting analysis techniques for extended datasets.
🚀 Excel Tips and Tricks:
🔄 For Excel 2013 or newer users: Skip adding the date field to the pivot table for convenience.
💾 Saving the pivot table data as XLSB for future use.
🙏 Special Thanks:
Thanks for watching. Clicking Like really helps with the algorithm. See you next time for more valuable Excel tips and tricks! 🎉📈💼
How to download past drawing results of the Mega Millions game and find the most common numbers in the last year, quarter, or month. This long video is a followup to episode 453, where I glossed over how to put the results in a long column. Update: +MrBubeTube pointed out that the Iowa lottery website offers the results in a nice tab-delimited form that imports better to Excel: www.ialottery.com/Results/MM.txt
Table of Contents
(00:00) Most popular numbers in Mega Millions Lottery
(01:05) Download CSV of all winning numbers
(02:12) Cleaning the data
(03:15) Unwind the data
(03:50) Pivot with Multiple Consolidation Ranges
(04:26) Power Query would be easier
(05:30) Add Year column
(06:02) Old or New Game
(07:22) Adding a Pivot Table
(08:43) Sort by descending popularity
(09:17) Limit to only new game
(09:48) The most popular lottery numbers
(10:47) Most popular by Year
(11:52) Timeline Slicer
(13:18) Which numbers are overdue?
(14:36) Using Slicers
(16:11) Save as Excel instead of CSV
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #lottery
This video answers these common search terms:
how do pick random numbers for lottery in excel
how to create a lottery for a list in excel
how to make an excel lottery numbers generator
how to use excel to use lottery numbers
excel mega millions number analysis tutorial
how to find popular lottery numbers in excel
analyzing mega millions data in excel
mega millions winning numbers excel pivot table
excel lottery number trends tutorial
most popular mega millions numbers strategy
mega millions data analysis for beginners
mrexcel podcast lottery number insights
using excel to analyze lottery number frequency
Join the MrExcel Message Board discussion about this video at www.mrexcel.com/board/threads...

Пікірлер: 39

@monp.4903 5 жыл бұрын

Watching this in 2019! There are definitely very significant patterns in the lottery. I have been analyzing it. You can get the excel file of all the history from the Wisconsin lottery! lol

@liufox1292 3 жыл бұрын

This is glorious, I been tryin to find out about "what winning numbers are most popular in the lotto" for a while now, and I think this has helped. Have you ever come across - Menaleb Prefatory Method - (search on google ) ? It is an awesome one off guide for discovering how to find your lucky day to make you succeed in the lottery without the normal expense. Ive heard some great things about it and my mate got excellent results with it.

@jenseeman2527 8 жыл бұрын

Thank you for teaching me about Pivot tables.

@myvn4ever Жыл бұрын

Very good tutorial, and also, your voice is very soothing.

@woolysamoan 6 жыл бұрын

Time for a new video, since they changed the number fields on us again on October 31, 2017. What a treat those tricksters gave us!

@griffin5012 4 жыл бұрын

This is great but how do you update all sheets and Pivot Tables if the original (raw) data is amended (i.e. new lines added to the source table)?

@gnasa2102 Ай бұрын

Thank you 💙 Can you please provide me the Power Query link version.

@motleyassortment5512 Жыл бұрын

Thankyou for this tutorial. I am thinking of using Excel for keeping track of lotto, this will come in handy.

@mickel6830 3 жыл бұрын

What is the procedure to add additional dates and numbers to the existing tables to make it populate? Tried adding lines but they will not show from the first time set-up of the pivot tables.

@burito1place448 4 жыл бұрын

Can you Provide your finished chart to download? with pivot table? my Chromebook doesn't have a "PivotTable and PivotChart Wizard", nor could I edit my Pivot Tables, I would really appreciated. I learned a lot about Pivot Tables thanks

@MrSunshanmu 2 жыл бұрын

HI, I'M NOT GETTING THE SAME RESULTS WHEN I FOLLOW YOUR STEPS. IS THE PROCESS THE SAME FOR EXCEL 2019 VERSION 16?

@jimnasium3208 5 жыл бұрын

14:16 Someone up in 2019 lol It's cool that the most popular mega ball number shown in this video are still at the top of the list 5 years later.

@MrXL 5 жыл бұрын

+Chantley Wiese wow that is pretty wild and statistically significant.

@devcrestha 4 жыл бұрын

I want someone give me six Lottery numbers from 1-54.

@excelisfun 10 жыл бұрын

Wow, that is so epic!!!!

@liufox1292 3 жыл бұрын

@kennykenaz8340 3 жыл бұрын

This was great, I've been looking for "what are the luckiest lottery numbers?" for a while now, and I think this has helped. Ever heard of - Menaleb Prefatory Method - (search on google ) ? It is an awesome one off product for discovering how to find your lucky day to make you succeed in the lottery without the headache. Ive heard some great things about it and my friend got cool success with it.

@erikguzik8204 Жыл бұрын

ok... great great video (as always) you said someone from 2019 might be doing this... well how about 2022!!!! Yes, I should have done it before the 1.3Billion drawing. Want to know something odd. your video at time stamp 9:26 just filtering New Game. The #10 is the most popular number with 18, well in 2022 guess what the #10 is still the most popular with 129 (all be 56x it was the mega ball) but still funny. (Yes, smaller numbers are skewed because the Mega Ball doesn't' go as high) #31 is most popular now. Thanks so much for a fun video

@arion343 3 жыл бұрын

Hey sir, is it another way I could get in contact with you?

@MrSunshanmu 2 жыл бұрын

Hi is it possible to add data to the pivot table as it becomes available without starting the process from scratch?

@MrXL 2 жыл бұрын

Select a cell in the pivot table. On the PivotTable Analyze tab in the Ribbon, about half way across, there is a group called Data. The second icon there is Change Data Source. Click that, and you can edit that the data which used to go from A1:J999 now goes from A1:J1499 or whatever the new bottom row is.

@OTuit 10 жыл бұрын

Death to Data by pivot table. Hehe. Great stuff!

@davidgreenidge2394 4 жыл бұрын

Can you calculate the most common triplets or pairs.

@todaysreality1575 2 жыл бұрын

Did you win?

@JohnnyQuestFishing 4 жыл бұрын

Currently 1 thru 70 numbers on Megamillions and 1 thru 69 on Powerball :D

@redmatrix Жыл бұрын

14:15 Watching in Q4 of 2022!

@robinowen3899 Жыл бұрын

How do I find most popular numbers in each draw.

@josestudyexcel 10 ай бұрын

Can you make a formula where it generates a series of lottery number combinations out of those most frequent numbers? Let's say I want to generate 50 lottery number combinations out of 18 frequent numbers.

@mrbubetube 9 жыл бұрын

The Iowa state lottery page has the megamillions numbers in a real nice tab delimited text file. Easy to import and no editing needed. www.ialottery.com/Results/MM.txt After you import, just use Bill Jelen's neat little pivot table trick to "unpivot" the data.

@woolysamoan 6 жыл бұрын

The Texas Website also has very good downloading data options. Many states are just pooping all over their players.

@lisac6652 2 жыл бұрын

what if you have a group of popular numbers can you find the combinations of the numbers example 123 132 213 231 321 ect...

@MrXL 2 жыл бұрын

I understand what you are trying to do. It is frustrating. Excel has functions that tell you how many combinations there will be. But they don't have anything to generate the list of combinations.

@forecastinglottery6153 4 жыл бұрын

only artificial intelligence seo8ceo.com can make an assumption about the numbers themselves and the date when this can happen

@goturtlepoop 8 ай бұрын

can I buy list from you? powerball....just 5 white balls...1-69, but I would like to hire you...I am wanting to build a number generator and would love your help....pleasecontact...