{"id":2944,"date":"2012-03-29T21:10:16","date_gmt":"2012-03-30T04:10:16","guid":{"rendered":"https:\/\/edelalon.com\/blog\/?p=2944"},"modified":"2017-08-26T20:58:51","modified_gmt":"2017-08-27T03:58:51","slug":"mega-millions-lottery","status":"publish","type":"post","link":"https:\/\/www.edelalon.com\/blog\/mega-millions-lottery\/","title":{"rendered":"Mega Millions Lottery"},"content":{"rendered":"

\"\"<\/a><\/p>\n

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.<\/p>\n

What\u2019s 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, \u201c25 rounds? We should take a bigger data set and run more numbers.\u201d<\/p>\n

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.<\/p>\n

The result is the following PDF, CA Lottery Picks 2012<\/a>. 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.<\/p>\n

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.
\nFrom 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\u2019ll see what happens tomorrow night.<\/p>\n

References:
\ncalottery.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

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\u2019s funny is that he sent me […]<\/p>\n","protected":false},"author":1,"featured_media":2945,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"tdm_status":"","tdm_grid_status":"","footnotes":""},"categories":[6,44],"tags":[109],"class_list":{"0":"post-2944","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-general","8":"category-technology","9":"tag-excel"},"yoast_head":"\nMega Millions Lottery • Edel Alon<\/title>\n<meta name=\"description\" content=\"Hello, we have well thought out reading topics on technology, leadership, project management, food, weddings, and tools to help your daily life. Need some Excel tips or wedding planning advice? Read now and don't forget to comment.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.edelalon.com\/blog\/mega-millions-lottery\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mega Millions Lottery • Edel Alon\" \/>\n<meta property=\"og:description\" content=\"Hello, we have well thought out reading topics on technology, leadership, project management, food, weddings, and tools to help your daily life. Need some Excel tips or wedding planning advice? Read now and don't forget to comment.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.edelalon.com\/blog\/mega-millions-lottery\/\" \/>\n<meta property=\"og:site_name\" content=\"Edel Alon\" \/>\n<meta property=\"article:published_time\" content=\"2012-03-30T04:10:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-08-27T03:58:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2012\/03\/ca-lottery-2012-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"630\" \/>\n\t<meta property=\"og:image:height\" content=\"323\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Edel Alon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Edel Alon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/mega-millions-lottery\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/mega-millions-lottery\\\/\"},\"author\":{\"name\":\"Edel Alon\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/#\\\/schema\\\/person\\\/aaf86bfa75efb59a5f0855c63e330e42\"},\"headline\":\"Mega Millions Lottery\",\"datePublished\":\"2012-03-30T04:10:16+00:00\",\"dateModified\":\"2017-08-27T03:58:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/mega-millions-lottery\\\/\"},\"wordCount\":293,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/#\\\/schema\\\/person\\\/aaf86bfa75efb59a5f0855c63e330e42\"},\"image\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/mega-millions-lottery\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/03\\\/ca-lottery-2012-1.jpg\",\"keywords\":[\"excel\"],\"articleSection\":[\"General\",\"Technology\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/mega-millions-lottery\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/mega-millions-lottery\\\/\",\"url\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/mega-millions-lottery\\\/\",\"name\":\"Mega Millions Lottery • Edel Alon\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/mega-millions-lottery\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/mega-millions-lottery\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/03\\\/ca-lottery-2012-1.jpg\",\"datePublished\":\"2012-03-30T04:10:16+00:00\",\"dateModified\":\"2017-08-27T03:58:51+00:00\",\"description\":\"Hello, we have well thought out reading topics on technology, leadership, project management, food, weddings, and tools to help your daily life. Need some Excel tips or wedding planning advice? Read now and don't forget to comment.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/mega-millions-lottery\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/mega-millions-lottery\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/mega-millions-lottery\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/03\\\/ca-lottery-2012-1.jpg\",\"contentUrl\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/03\\\/ca-lottery-2012-1.jpg\",\"width\":630,\"height\":323},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/mega-millions-lottery\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mega Millions Lottery\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/\",\"name\":\"Edel Alon\",\"description\":\"Projects, Tools, Craft, Food, Music, and Other Stuff\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/#\\\/schema\\\/person\\\/aaf86bfa75efb59a5f0855c63e330e42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/#\\\/schema\\\/person\\\/aaf86bfa75efb59a5f0855c63e330e42\",\"name\":\"Edel Alon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/edel-alon-logobl.png\",\"url\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/edel-alon-logobl.png\",\"contentUrl\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/edel-alon-logobl.png\",\"width\":136,\"height\":80,\"caption\":\"Edel Alon\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/edel-alon-logobl.png\"},\"description\":\"Edel-Ryan Alon is a starving musician, failed artist, connoisseur of fine foods, aspiring entrepreneur, husband, father of two, geek by day, cook by night, and an all around great guy.\",\"sameAs\":[\"https:\\\/\\\/edelalon.com\"],\"url\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/author\\\/edelalon\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mega Millions Lottery • Edel Alon","description":"Hello, we have well thought out reading topics on technology, leadership, project management, food, weddings, and tools to help your daily life. Need some Excel tips or wedding planning advice? Read now and don't forget to comment.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.edelalon.com\/blog\/mega-millions-lottery\/","og_locale":"en_US","og_type":"article","og_title":"Mega Millions Lottery • Edel Alon","og_description":"Hello, we have well thought out reading topics on technology, leadership, project management, food, weddings, and tools to help your daily life. Need some Excel tips or wedding planning advice? Read now and don't forget to comment.","og_url":"https:\/\/www.edelalon.com\/blog\/mega-millions-lottery\/","og_site_name":"Edel Alon","article_published_time":"2012-03-30T04:10:16+00:00","article_modified_time":"2017-08-27T03:58:51+00:00","og_image":[{"width":630,"height":323,"url":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2012\/03\/ca-lottery-2012-1.jpg","type":"image\/jpeg"}],"author":"Edel Alon","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Edel Alon","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.edelalon.com\/blog\/mega-millions-lottery\/#article","isPartOf":{"@id":"https:\/\/www.edelalon.com\/blog\/mega-millions-lottery\/"},"author":{"name":"Edel Alon","@id":"https:\/\/www.edelalon.com\/blog\/#\/schema\/person\/aaf86bfa75efb59a5f0855c63e330e42"},"headline":"Mega Millions Lottery","datePublished":"2012-03-30T04:10:16+00:00","dateModified":"2017-08-27T03:58:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.edelalon.com\/blog\/mega-millions-lottery\/"},"wordCount":293,"commentCount":0,"publisher":{"@id":"https:\/\/www.edelalon.com\/blog\/#\/schema\/person\/aaf86bfa75efb59a5f0855c63e330e42"},"image":{"@id":"https:\/\/www.edelalon.com\/blog\/mega-millions-lottery\/#primaryimage"},"thumbnailUrl":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2012\/03\/ca-lottery-2012-1.jpg","keywords":["excel"],"articleSection":["General","Technology"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.edelalon.com\/blog\/mega-millions-lottery\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.edelalon.com\/blog\/mega-millions-lottery\/","url":"https:\/\/www.edelalon.com\/blog\/mega-millions-lottery\/","name":"Mega Millions Lottery • Edel Alon","isPartOf":{"@id":"https:\/\/www.edelalon.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.edelalon.com\/blog\/mega-millions-lottery\/#primaryimage"},"image":{"@id":"https:\/\/www.edelalon.com\/blog\/mega-millions-lottery\/#primaryimage"},"thumbnailUrl":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2012\/03\/ca-lottery-2012-1.jpg","datePublished":"2012-03-30T04:10:16+00:00","dateModified":"2017-08-27T03:58:51+00:00","description":"Hello, we have well thought out reading topics on technology, leadership, project management, food, weddings, and tools to help your daily life. Need some Excel tips or wedding planning advice? Read now and don't forget to comment.","breadcrumb":{"@id":"https:\/\/www.edelalon.com\/blog\/mega-millions-lottery\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.edelalon.com\/blog\/mega-millions-lottery\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.edelalon.com\/blog\/mega-millions-lottery\/#primaryimage","url":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2012\/03\/ca-lottery-2012-1.jpg","contentUrl":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2012\/03\/ca-lottery-2012-1.jpg","width":630,"height":323},{"@type":"BreadcrumbList","@id":"https:\/\/www.edelalon.com\/blog\/mega-millions-lottery\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.edelalon.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Mega Millions Lottery"}]},{"@type":"WebSite","@id":"https:\/\/www.edelalon.com\/blog\/#website","url":"https:\/\/www.edelalon.com\/blog\/","name":"Edel Alon","description":"Projects, Tools, Craft, Food, Music, and Other Stuff","publisher":{"@id":"https:\/\/www.edelalon.com\/blog\/#\/schema\/person\/aaf86bfa75efb59a5f0855c63e330e42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.edelalon.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.edelalon.com\/blog\/#\/schema\/person\/aaf86bfa75efb59a5f0855c63e330e42","name":"Edel Alon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2017\/09\/edel-alon-logobl.png","url":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2017\/09\/edel-alon-logobl.png","contentUrl":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2017\/09\/edel-alon-logobl.png","width":136,"height":80,"caption":"Edel Alon"},"logo":{"@id":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2017\/09\/edel-alon-logobl.png"},"description":"Edel-Ryan Alon is a starving musician, failed artist, connoisseur of fine foods, aspiring entrepreneur, husband, father of two, geek by day, cook by night, and an all around great guy.","sameAs":["https:\/\/edelalon.com"],"url":"https:\/\/www.edelalon.com\/blog\/author\/edelalon\/"}]}},"_links":{"self":[{"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/posts\/2944","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/comments?post=2944"}],"version-history":[{"count":0,"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/posts\/2944\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/media\/2945"}],"wp:attachment":[{"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/media?parent=2944"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/categories?post=2944"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/tags?post=2944"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}