Mega Millions Lottery

The Mega Millions lottery is up to $540 million and still growing for the draw to happen on March 30. If you win this lottery, the payout is somewhere around $389 million. The lottery craze swept through my office and recently my brother told me I should play.

What’s funny is that he sent me an excel spreadsheet indicating the most picked numbers in the past 25 rounds. This is where my inner nerd came in and said, “25 rounds? We should take a bigger data set and run more numbers.”

The CA Lottery website has a feature where you can download the data set of the past winners. The data dates back to the year 2000. After creating my formulas I was set to make the parameters.

The result is the following PDF, CA Lottery Picks 2012. This PDF contains the winning numbers constrained by date. Past winning numbers for 3 months, 6 months, 1 year, 2, years, 3 years, 5 years, 7 years, and 10 years. Adding the color coding helps to visually find the numbers most picked. There were some rules that I had to adjust for the color combinations. Between 3 months and 5 years, anything above 75% showed up as green, less than 75% and greater than 50% are in yellow, and under 50% are in red. Between 5 years and 10 years, I had to adjust the percentages where green were the ones that came up more than 90% of the time.

That change became apparent when the number of instances of the numbers started to plateau and the variation between the lowest instances to the highest number of instances tapered off.
From these numbers I generated 5 sets of numbers, showed off my spreadsheet, made deals to split the money, crossed my fingers, and purchased some tickets. We’ll see what happens tomorrow night.


Similar Articles



Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Recent Posts


Most Popular

Super Mario Bros Wii – Mushroom Houses

I was wondering how to get all the matches in on the mushroom houses in Super Mario Bros Wii. Sure enough there are patterns...

Zipcode to City, State Excel Spreadsheet

I just decided to do this. I've been meaning to learn more about the vlookup function in Excel. I figured this one would be...

Community Service Letter Template

I’ve been asked on occasion by parents if their child can volunteer some hours in the non-profit organization I help out at. I guess...