A Blog That Creates Better Data Analysts
A blog focused primarily on Microsoft Excel, PowerPoint, & Word with articles aimed to take your data analysis skills to the next level. Learn anything from creating dashboards to automating tasks with VBA code!
Excel PowerBall Lottery Simulator Spreadsheet
With all the excitement over the $900 Million PowerBall Jackpot this past weekend, I thought it would be interesting to create an Excel-based simulator so I could pretend that I had money to blow on purchasing lottery tickets (I ended up buying 2 losing tickets, so it looks like I won’t be retiring in my 20’s. )
I busted this simulator out in 2 hours (thanks to a little dose of caffeine). So feel free to dig into the VBA logic and correct anything that may be wrong, but I am fairly confident it’s performing as intended.
The basic premise of the simulator, is you tell it how much money you want to spend playing the lottery, pick some numbers, and then watch as you play the PowerBall lottery over and over until you run out of money. I’m not going to lie this simulator is both extremely addicting and filled with lot’s of disappointment. kind of like the real thing!
Below is the simulation dashboard I came up with, and yes 100% of it was created in Excel (even the lottery icons)!
Inspiration for this simulator came from the LA Times website
The Odds Are DEFINITELY Not In Your Favor
I think we all are aware that it is very hard to win the lottery, but I think it’s sometimes hard to relate to really crazy odds like 1 in 11.6 million. So here are a few different ways at looking at the lottery odds:
- Struck by lightning, while drowning (1 in 183 million)
- Killed by an asteroid strike (1 in 700,000)
- Have an IQ of 190 or greater (1 in 107 million)
- Attacked by a shark (1 in 11.5 million)
- Elected President of the United States (1 in 10 million)
- Getting struck by lightning (1 in 164,968)
- Being drafted by an NBA team (1 in 6.8 million)
- Becoming a movie star (1 in 1.5 million)
- Dating a supermodel (1 in 88,000)
- Being killed by a vending machine (1 in 112 million)
PowerBall Lottery Winnings/Odds
Below is a little info-graphic I created in Excel with the official statistics for the PowerBall Lottery drawing as of January 2016.
Download the Excel Simulator & Test Your Luck
If you want to download my PowerBall Lottery Simulator spreadsheet (fully unlocked), you can sign up for my free newsletter and instantly gain access to this file and any other of the many example files used in my blog posts. Plus you’ll get my best tips & hacks to improve as an analyst, emailed to you a couple of times a month (none of them are posted on this website, so it’s completely new content).
Just click the green download button below and you can quickly sign up and get your own copy of the simulator spreadsheet!
With all the excitement over the $900 Million PowerBall Jackpot this past weekend, I thought it would be interesting to create an Excel-based simulator so I could pretend that I had money to blow on purchasing lottery tickets (I ended up buying 2 losing tickets, so it looks like I won’t be retiring in my 20’s….)