Monopoly is Rigged

You’re not paranoid.

Monopoly is out to get you.

Even with a data-driven, YouTuber certified, “can’t lose” strategy, you can still go bankrupt.

Improbably, a hotel-enhanced Connecticut Avenue led to my recent downfall .

“Six hundred bucks, dad,” my son called out.

THREE. FREAKING. TIMES.

Penniless, I cursed the dice and mumbled about my rotten luck.

He just laughed.

There is a reason why Monopoly is the most banned board game.

Perhaps, you have experienced similar financial ills from Illinois Avenue or been bankrupted by Boardwalk. With this post, we will find the “hot” properties and why we land on them so much, why playing the odds doesn’t always work, and finish with some tips to stay financially solvent.

Need a rules refresher? Start here.

Mechanics of Monopoly

To start, there are 40 positions on the game board (numbered in red):

Figure 1: Monopoly game board. Positions numbers from 1 (GO) to 40 (Boardwalk)

During gameplay, we take turns rolling two, 6-sided dice, sum the total, and move that many spaces. Roll doubles and we roll again but roll three consecutive doubles and we go to jail for “speeding”.

If we land on any of the 22 properties (e.g. Boardwalk), four railroads (e.g. Reading Railroad), two utilities (Electric Company and Water Works), Income Tax, Luxury Tax, Free Parking, Jail, or GO, we remain there at the end of our turn.

Conversely, the other seven positions can cause additional movement . GO TO JAIL is self-explanatory. The others, three Community Chest and three Chance, lead to card draws for some unknown fate. While both 16-card decks contain “Advance to GO” and “Go directly to Jail”, Chance has eight more movement-inducing cards sending us to St. Charles Place, Illinois Avenue, Boardwalk, Reading Railroad, the next railroad, the nearest railroad, the next utility, or back three spaces.

There’s a lot going on, but already we see a couple of things:

1. We are going to jail. A lot!

One position is Jail. Another sends us to Jail. Cards send us to jail. “Speeding”? Jail. We will end our turn on jail more than any other position. This also has a secondary effect: Properties one or two rolls away from jail will see a bump up in their end of turn probabilities.

2. We probably won’t stay on Chance if we land there

Ten of the 16 cards send us elsewhere on the board. Chance should be the least frequent end of turn position. We should also end on positions called out by the cards, e.g. GO and Reading Railroad, more frequently than other places on the board.

With the mechanics in mind, let’s find those hot spots!

Methodology

We have two ways to find the probability of ending a turn on each property: analytical and empirical.

For an analytical solution, we need to identify every combination of 40 board positions, 216 dice roll combinations (to account for speeding), and 20,922,789,888,000 possible Chance and Community Chest decks. The numbers get astronomical in a hurry.

Option two is an empirical approach: play the game and count as we go. Looking at a 50-move game, the end of turn distribution might look like this:

Figure 2: End of turn distribution for a simulated 50-move game (left) and Monopoly game board (right).

In this game, we ended on some positions 8% of the time and several others not at all! There’s no way to tell where the true hot spots are based on this alone. We need more data. In fact, it takes about 20,000 games to reach a steady state where the probabilities change a negligible amount regardless of how many additional games we play. In other words, the probabilities after 20,000 games and 1,000,000 games look almost identical.

With normal play taking 60 minutes per game, it would take us over 800 days to hit steady state. Thankfully, computers are much more effective at this type of work! Business Insider, for example, put together this analysis:

Figure 3: End of Turn Steady State Probabilities for game play. Simulated players “posted bail” immediately after being sent to jail. https://www.youtube.com/watch?v=7_SXFtdf65s

All things equal, we land on each position 2.5% of the time. But they’re not equal. Jail, as expected, is tops at 6.3%. The top five properties are Illinois Ave (3.2%), B&O Railroad (3.2%), GO (3.1%), New York Avenue (3.1%), and Reading Railroad (3.0%). Note that all five are associated with Chance cards.

The bottom 3? All Chance. We knew it!

This is all very nice, but it still doesn’t explain Connecticut Avenue. How did a property with a 2.3% end of turn probability put me in the poor house?!?

It’s due to the chaotic nature of dice rolls and card draws that led to an unexpected (and unprofitable!) result. While the steady state analysis provides a good strategy, a single Monopoly game will never get to steady state. We expect to land on Connecticut Avenue once per 50-turn game (2.3% x 50 turns = 1.15) but it’s possible to land there over 12 times! I lost, in part, because my son snagged the property early on, built a hotel, and cashed in on my unlikely string of landings.

Rigging Monopoly in our favor

Steady state or no, we want to win! This succinct guide will improve our odds.

Some highlights:

1. Buy orange and red properties

These are on the hottest part of the board. Scoop ’em up, finish the monopoly, build houses, and collect that rent!

2. Build three houses on your monopolies ASAP

This provides the optimal balance of the cost to build houses and the benefit of higher rent. Properties with three houses make money back sooner than any other situation.

3. Stock up on railroads; avoid the utilities

Railroads rake in the rent, especially when we get all four. The utilities? Not so much.

With these tips and an understanding of the game’s statistics, we will be ready for our next Monopoly matchup. And while it might not make strategic sense, if my son even thinks about buying Connecticut Avenue, he’s grounded!


Gratitude

Thanks for reading! Comment below about what you liked (or didn’t!).

Also, a big thank you to the Foster crew – Chris, Stew, Joel, David, and Christine – for edits and suggestions!

Further reading

Here are a few more resources to check out:

Daylight Savings Time: A brief history with a touch of astronomy

Another year of Daylight Savings Time (DST) is coming to an end and with it, the joy of an extra hour to sleep or celebrate.

It used to give me nightmares.

For a time, I managed an Excel file that tracked a production schedule.  Operators entered in start times and the spreadsheet calculated when the process should end.  This was very time-sensitive.  Ending the process early caused significant operational issues.  Delays led to lost production.  Spreadsheets aren’t a great application for this, but 99.9% of the time we had no issues.

The 0.1% we did, DST was usually involved, which meant more than a few late nights of scrambling to get things right.

While the concept of shifting time twice a year is easy to understand, it’s really freaking hard to account for the two hours out of 8760 per year that act differently.  To the programmers make this a seamless change every time, I salute you!  In honor of their brilliance and of humanity’s tendency to make things unnecessarily complicated, here is a brief history of DST with a touch of astronomy to explain why we mess with our clocks twice a year.

Let’s dive in.


DST started off as a joke by Benjamin Franklin no less.  In 1784, his anonymous letter to Journal de Paris quipped that the French could save ~$200 million a year spent on candles if they only rose with the sun and retired at sundown.  And with so much at stake, forcing citizens to comply only made sense!  His suggestions?

  1. Tax window shutters that blocked the sun
  2. Ration out candles
  3. Restrict nighttime travel to physicians, surgeons, and midwives
  4. Ring out church bells and fire off cannons (!) at dawn

Alas, his brainchild would have to wait.

While Franklin’s cheeky missive was ignored, George Hudson, a New Zealand entomologist, renewed the cause with papers in 1895 and 1898 that proposed a 2-hour shift forward on March 1st and back on October 1st to make better use of daylight.  This would also have conveniently supported his prodigious bug collecting interests!  In 1907, Englishman William Willett published “The Waste of Daylight” that suggested a 20-minute shift on four consecutive weekends in April and September with similar effect.  His persistent campaign eventually led Parliament to review a “Daylight Saving Bill” in 1908.   It was initially mocked, but with some tweaks gained substantial support over the next few years, though not enough to become law.

That changed during World War I when Germany implemented sommerzeit or “summer time”, on April 30, 1916 in an effort to conserve coal.  England followed suit shortly after on May 17th.  The U.S. waited until March 31st, 1918, though its DST trial was short-lived nationally.  Congress shut it down in October 1919 overriding President Woodrow Wilson’s veto in the process.  However, DST lived on locally as some communities enjoyed the summer shift.  By 1923, nearly 500 cities were in the DST camp.

The U.S. once again enacted year-round DST in 1942 during World War II, which united the nation’s time-changing ways, only to have them shut down again in 1945 at the end of the war.  However, some states and cities continued to do their own thing for the next 20 years until the Department of Transportation got involved. Cross-country travel was gaining popularity and industries had a tough time keeping track of the mishmash of time changes throughout the country.  The Uniform Time Act of 1966 forced states to adopt standard time or DST.  Cities could no longer go rogue either, though the entire state could opt out of DST should they choose, which Arizona and Michigan did.  Michigan opted back in to DST in 1972 while Arizona continues to go without as does Hawaii.

Globally, DST is all over the place.  178 countries currently don’t observe it.  Of those, about 100 never have while the rest did at one point, but gave it up.  The other 70 or so countries had a similarly tumultuous journey as the U.S. and ended up opting for the twice annual hourly shift.  Wikipedia summarizes it nicely by country as does this map below:

Map credit:  UnaitxuGV

In the Northern hemisphere, Mexico, the U.S., Canada, a few Middle Eastern countries, and a smattering of island nations observe DST.  Most of Europe currently uses DST, however that will be changing as soon as 2021.  The European Parliament voted to end the seasonal time change leaving each country to decide its standard time, though the Council of the European Union has yet to finalize its decision.

The Southern hemisphere has a much sparser adherence with Chile and Paraguay in South America, New Zealand, some more island nations, and about a third of Australia, which is worth a deeper look:

The 90-minute shift from Western to central Australia is odd enough, but it gets downright ridiculous during daylight savings.

As you can see from the map, geography, specifically latitude, plays a significant role in what countries practice DST.  That’s because of a little thing astronomers call obliquity.  Also known as axial tilt, the Earth spins on its axis at a different angle than it orbits the sun.  Written descriptions of this are tough.

Gifs make it easier.

Take this car doing donuts, for example:

The rear tires spin about their axis perpendicular to the road.  They also “orbit” around the center of the donut, parallel to the road.  This corresponds to an axial tilt of 90°.

The Earth’s tilt is not as dramatic, currently ~23.4°, as shown here:

When the North pole leans toward the sun, the Northern hemisphere experiences summer and longer days.  On the other end of the orbit, the North Pole tilts away from the sun leading to winter and shorter days.  The variability in daylight hours becomes more extreme the further away from the equator.  Note below how the Antarctic Circle is shielded from the sun during the June solstice (left) and the Arctic Circle is in darkness during the December solstice (right).

For a practical comparison, look at the times for sunrise and sundown for Quito, Ecuador and Reykjavik, Iceland over the course of a year.  Quito, near the equator (latitude 0° 10’ S), remains nearly constant at ~12 hours of daylight while Reykjavik (latitude 64° 08’ N) goes from 4-hour days to 3-hour nights and back every year.

Sunrise/sunset data for Quito, Ecuador and Reykjavik, Iceland

Cities near the equator see almost no variation in daylight hours.  In Quito, sundown varies between 6:01pm and 6:31pm and sunrise varies between 5:58am and 6:24am.  DST would only serve to throw a wrench into a perfectly stable day!  On the other hand, Reykjavik is so far away from the equator that days and nights get REALLY long.  DST would move sundown from midnight to 1am on the summer solstice.  If the lack nighttime didn’t mess you up, the hour shift would do the trick!


Daylight Savings Time continues to be an oddity of mankind.  Its satirical beginning from an American statesman advocating wake-up calls with artillery fire only adds to its colorful history.  In a hundred years it may be nothing but a distant memory.  Until then, some of us will keep on springing forward and falling back.

I’m just thankful I don’t have to program my phone to do the same.


Thanks Muhammed, Kyla, and Jeremiah for feedback on the drafts!

And Compound Writing for the forum to meet these fascinating people.

Painless Chart Title Updates

I originally called this post “Dynamic Chart Titles in Excel”.

SEO-friendly, perhaps.  But it could have been catastrophic.

In weaponized form, that five-word combination could unleash a wave of drowsiness not seen in modern times.  Even in an 11-point font, it will cause you to blink for a second or two longer than normal.

Use with caution!


This post takes the tedious task of updating an Excel chart title and makes it less painful.  Typically, we send the same chart to the same people day after day after day after day…

You get the point.

To get us started, we’ll use a sample chart looking at my daily steps so far in August:

I want to track my daily step average and maximum step count for the month.  I also want the chart to update when I add more data.  The axis titles, “Steps” (y-axis) and “Date” (x-axis), stay the same but my chart title will change every day I add more information.

Doing this manually gets very old very quickly.

Any data moves require a micro-adjustment to the title.  No biggie until you realize that three minutes of daily tweaks costs you 12.5 hours of labor per year.

Egad!

No need to fret, however.  We can do it automatically.

Building the statistics

To start, we need to determine the month’s start date, last day of data entered, average steps for the month, and month’s maximum steps.

Briefly reviewing these formulae:

  • Month start date:  EOMONTH(DATE, 0) returns the last day of DATE’s month (e.g. 7/5/2020 will yield 7/31/2020).  EOMONTH(DATE, -1) yields the last day of last month.  By adding 1, we get to the start of the current month!
  • Last date entered:  Excel converts dates into the number of days after January 1, 1900 (or 1/1/1904 for some Mac users).  The largest number is the most recent date, hence the use of MAX().
  • Avg. steps in month:  AVERAGEIFS() will average together all values in Column B with corresponding values, i.e. in the same row, that satisfy all conditions of the expression.  For example, B2 (value of 5000) will only be included if A2 (value of 8/1/20) is between the start of the month (D16 or 8/1/20) and the last date entered (D17 or 8/6/20). Since it satisfies all conditions, it is averaged in.
  • Max. steps in month:  Similarly, MAXIFS() finds the largest value of Column B with corresponding dates between 8/1/20 and 8/6/20.

Building the title

Now, we can create a descriptive title that updates as we add more data by combining three separate lines:

  1. August Steps – Through 8/6/20
  2. Average = 6567 steps
  3. Max = 9000 steps

The TEXT() function and ampersand “&” will come in handy.  Observe:

For the first title line (cell D21), we use TEXT() in two ways:

  1. TEXT(D17,”mmmm”) converts “8/6/20” into month’s full name, i.e. “August”
  2. TEXT(D17,”m/d/yy”) maintains the “m/d/yy” format in the formula result.  Without it, “44049” would appear in its place.

For more details on date formats used with the TEXT() function, check out this post.

Using “&” we can stitch together “August” with “ Steps – Through “ and “8/6/20” to complete the line.  Keep in mind that spaces are important in the connecting text.  Sans spaces,  “AugustSteps-Through8/6/20” borders on unreadable.

TEXT(D18,”0”) in cell D22 and TEXT(D19,”0”) in cell D23 keep each formula result as an integer for tidy reporting.  Without it, August’s average becomes 6566.66666666667 steps, an impressive (though ridiculous!) display of accuracy to within 10 picosteps.  “Average = “ and “Max = “ are tied with their corresponding statistic with “&” to complete each line.

To finish the title, we use “&” to combine these three lines (i.e. D21, D22,and D23) with line breaks (a.k.a. carriage returns) as shown in Cell M25 below (bordered in red).  Hold down the “Alt” key and then press Enter” to insert the carriage return.  (Akin to “Shift+Return” used in several apps to insert a line without sending a message.)  This keeps the title clean with each statistic on a separate line.

Cell D25 (bordered in purple) is the output, though there is no evidence of carriage returns.  That’s ok.  We will see them in a second.

Our chart is now ready for the final step!

Automating the title

Select the chart title’s text box and click in the formula bar toward the top of the page.  Instead of typing in text, select cell D25 to reference our well-crafted title!

Voila!

Now comes the fun part.  When we enter the next day’s data, the title updates automatically!  Let’s try 10,000 steps for August 7th and see what happens:

Bingo!

All our stats updated, including the new max steps for August, just by adding the data. A couple extra minutes of work should save you a ton time going ahead!


Thank you for reading! Feel free to add your comments below – what you liked or other Excel tricks worth learning about.

Shout out to Megan, Tyler, Joel, Eugene, Tom and colleagues at Compound Writing for your feedback!

Enrico Fermi and the Oreo

How many piano tuners are there in Chicago?

How many quarters would you need to stack to be as tall as the Empire State Building?

If all digital data were stored on punch cards, how big would Google’s data warehouse be?

These questions are nearly impossible to answer accurately without extensive research.  Enrico Fermi, 1938 Nobel Laureate and nuclear power forefather, was known for accurately estimating similarly hard-to-know answers with next to no information and posing similar questions.  Most famously, he estimated the power of a nuclear blast by dropping bits of paper as the shockwave passed and then measuring how far they blew away.  His estimate of 10 kilotons was amazingly close to the official U.S. Department of Energy 21-kiloton yield determined 50 years later using gamma-ray spectroscopy, whatever that is.  His crude measurement led to a reasonable estimate within minutes.  The actual answer took decades to determine.

Incredible.

Using Fermi’s technique of applying known concepts and quantities, we too can develop strategies to estimate hard-to-know answers with little effort and decent accuracy.  In short, turn a random, nonsensical wild-ass guess into a scientific wild-ass guess or SWAG.


Munching on a chocolate creme Oreo the other day, I noticed a reversed wafer and wondered about Mondelēz’s quality control process.  I also pondered how many Oreos are manufactured in the U.S. every year.  For kicks, instead of Googling the answer right away, I opted to estimate it first, a la Fermi, and then see how I did.

First:  Population of the U.S.

  • I hear 300 and 330 million people get thrown around in the news.
  • 300 million is rounder, we’ll start there.

Second:  Number of households

  • Two people per household seems low. Four seems high.  Three sounds good.
  • 300 million people / 3 people per household = 100 million households

Third:  Households that consume Oreos

  • Oreos are popular but stores are stocked with all kinds of cookies.  Maybe ten percent?  Why not.
  • 100 million households * 10% = 10 million households consuming Oreos

Fourth:  Oreos consumed per household per year

  • My own empirical evidence suggests one bag of Oreos consumed per week
  • Each bag has ~40 cookies (varies based on standard size, Family Size, etc.)
  • 40 cookies/week x 52 weeks/year = 2,080
  • Call it 2,000 Oreos per household per year.

Fifth:  Final estimate

  • 10 million households * 2,000 cookies per household per year
  • 20 billion Oreos consumed per year.

That’s a lot of cookies.


How did I do?  Well, somewhere between horrific and abysmal.

But that’s ok!

It turns out, the U.S. Oreo production is not readily available, at least where I was looking. 

Mondelēz touts a worldwide Oreo production of over 40 billion per year and net revenue of $3.1 billion in 2019.  That’s about 7.8 cents per Oreo.

With the net revenue per cookie, we can estimate U.S. consumption with sales numbers:

  • 2016:  $742 million / $0.078 per cookie = 9.6 billion
  • 2017:  $674.2 million / $0.078 per cookie = 8.7 billion

Some sites took a direct route and just estimated consumption:

  • 1984:  6 billion per year
  • 2007:  205,000 bags per day or ~3 billion cookies per year
  • 2015:  778.8 million packages per year or ~31 billion cookies per year(!)
  • 2017:  7.5 billion per year

Combining these results, estimates range from 3 to 32 billion Oreos per year.  However, the 2007 and 2015 results seem to be oddballs compared to the other four.  Our range narrows considerably to 6 to 9.6 billion per year once we throw those out.  But now we’re stuck.  Without official U.S. production data, there is no great way to narrow the range further.

All said, I’ll go with 8 billion Oreos per year and call it a day.

Summary of Oreo production: Labels are year of estimate.
Included data   Excluded data My SWAG   Final estimate


Two things I found useful from this exploration:

  1. Billions vs. millions

I had no idea how Oreos Americans eat annually.  Before this, if someone asked me how many million are consumed annually, I would assume the number must be between 1 and 1000.  In the best case, I’m off by a factor of 10!  It turns out, my SWAG was bad, but not that bad.

For more extreme examples, try these questions out:

  • How many thousands of dollars is Amazon worth?
  • How many billions of people will read this blog post?

Messes with your head, doesn’t it?

Using “thousands” or “billions” frames the answer between 1 and 1000 when the right answer is either much smaller or much larger.  It is surprisingly persuasive, especially without prior knowledge.

  1. Time vs. accuracy

My SWAG took about two minutes to build.  The “close enough” result took about three hours of trawling through 10-K forms, press releases, and obscure blog posts to determine.

It took me 100 times longer to find a slightly more accurate answer.

For the sole purpose of satisfying a curiosity, that can be hard to justify.  Spending more time makes sense when accuracy is valuable, be it marketing or physics.

Well, that was fun!  Now you’ll have to excuse me.  I have a tall glass of milk and a stack of Double Stufs to attend to.


For more Fermi questions, check out these links:


Many thanks to Stew, Joel, Chris, Jesse, and Dan for your feedback. It really leveled-up this post!

Compound Writing is making me better.

A bit of ingenuity

A bit of fruitful construction last year led to the replacement of old deck railing and addition of a line of 2×6 along the base to make the framework of the deck less visible. Not much has happened since then as I waited for the boards to weather before adding paint.  In the meantime, the bottom boards around the deck had gaps that needed to be closed up. A simple concept, though execution proved to be difficult.  At first, at least.

I unscrewed the lower boards from the deck, fiddled around with some hand clamps, adjusted, re-adjusted, reattached the boards, detached the boards, muttered to myself, reattached the boards, and stood back to see that little progress had been made despite the half-hour or so of effort. In the first few minutes of this bit of futility, my neighbor offer a pipe clamp to help out. I politely declined, thanked him, and then went back to my bout of inefficiency. What was a pipe clamp anyway? It could not be *that* helpful. Still, my curiosity was piqued and back I went to take up his offer.

Game. Changer.

The design is simple enough. Two pieces slide over a piece of pipe. One piece adjusts up and down to hold on to the surface to be compressed, wedging itself into the bar when force is applied. The second piece includes a screw that drives itself toward the other end to squeeze them together, hence the clamping effect.

Here it is in action:

pipe-clamp-e1501444142368.jpg

This beautiful tool saved my afternoon and allowed to make short work of what was turning into a rather daunting task. It even straightened out a warped section of board that would otherwise still be there. It also served as a humble reminder of how little I know about these tricks of the trade. Like so many challenges and tasks we are faced with, the vast majority have been solved and done so in elegant fashion. It often takes asking the right question or having the right person see what your problem is. The trick is figuring out what question to ask or finding that expert. How do you do that?

That is a good question.

Happy pi day!

Just wishing you all a happy pi day.  3/14/16 turned into decimal form (3.1416) rounds pi nicely to the nearest ten-thousandth.

This is much catchier than wishing everyone a happy “Ides of March eve”, which just sounds dreadful.

www.pidaychallenge.com/ makes for some entertaining mathematical puzzling.

www.expii.com is worth a look too with various problem solving sets in math and science set up by Carnegie Mellon math professor Po-Shen Loh, National Coach of the USA International Math Olympiad team.

Georgia Tech hosts a pi mile road race, which has run since 1975, and is actually a 5k (3.1068 miles, not 3.14159265… miles) since a change in 2002.  This is, confusingly, not run on pi day, but toward the end of April.  A portion of the course is on the Tyler Brown Pi-Mile Trail on campus dedicated to a former student government president and military serviceman killed in action in Iraq in 2004.

Enjoy the festivities, wherever you may be!

The leap day

I couldn’t resist posting on February 29th a little piece I wrote, well, about four years ago…


 

February 29th has come and gone with its usual fanfare being celebrated quadrennially.  That is, except every century when we skip the leap day, except every four centuries when we keep it.

Huh?  Perhaps I should back up a bit…

Our typical calendar year is 365 days (or 8760 hours, 525,600 minutes, 31,536,000 seconds, you get the point…) but our actual solar year, i.e. the time it takes the Earth to make one rotation around the sun, is approximately 365.242190419 days.  If we were to keep using 365 days per year, after a century December 31st would act a lot like a typical December 7th because we would be 24 days behind.  After 1000 years, we would be off by 242 days and celebrating New Year’s Day at a time when spring was just getting into full swing.  This is clearly a problem!  Hence, the “Leap Day” of February 29th.  Adding this every four years and our average calendar year becomes 365.25 days.  A much better result, but clearly we can do better!  To trim that average to 364.24 days, we skip the Leap Day every one hundred years.  So why, you may ask, did we have a leap day in 2000?  We celebrated this quadricentennial event because an average of 365.24 days is just not good enough!  By adding that leap day back every 400 years, our average calendar year becomes 365.2425 days.  This amounts to a deviation of 26.7 seconds per year or 0.0000848% and a much better result.  Of course, after 3200 years of this, we would be off by an entire day again, but that debate can wait a couple millennia.

What are the odds?

$1.3 billion!  That’s quite a hefty jackpot for the next Powerball drawing, even if the number is deliberately inflated to raise the hype.  Still, the lump sum payout is estimated to be $806 million; not a bad day at the office.

The odds are posted around the web, but how are they determined?

The updated version of Powerball started in October; five numbers are drawn from a set of 69 white balls and one number from the set of 26 Power balls.  To win the jackpot, your five numbers and one Powerball number have to match up with the drawn numbers.  Your chance of one of your five numbers matching the first ball pulled is 5 out of 69 (7.25% probability).  Once a ball is pulled, it is not replaced, hence the chance of one of your four remaining numbers matching is 4 out of 68 (5.88%).  This continues until the five white balls are chosen (3 out of 67, 2 out of 66, and 1 out of 65) and then the Powerball at 1 out of 26.  When all is said and done, out of the 35,064,160,560 ways the six total numbers could be pulled, you could win 120 different ways, since the order that the numbers are pulled doesn’t matter (permutations vs. combinations anyone?).

odds
Odds are 292,201,338 to 1

When does it makes sense to play?  Well, Walter Hickey has made a name for himself looking at this sort of thing.  His 2013 article says it only makes sense if you take the annuity and if the jackpot is greater than $345 to $380 million.  Mind you, this was when Powerball was way easier to win (odds were a paltry 175,223,516 to 1 back then!)  With the tougher odds, breakeven, assuming just one winner, looks like this:

expected value

Once the jackpot hits $491 million, you can statistically justify purchasing a ticket, since the expected value is above $0.  Of course, that is **AFTER TAXES**.  With a top federal tax bracket of 39.6% and state taxes ranging from 0% to 8.8% and some cities adding their own levies as well.  That means it only works with jackpots from $813 million to $1.029 billion!  Assuming multiple winners, which is more and more likely with more tickets purchased, that minimum number keeps going up.  This is getting ugly…

Long story slightly longer, the odds are such that it is nearly impossible to statistically justify purchasing a ticket.  Am I playing?  Uh… yes, I am.  Why?  Consider it a cheap insurance policy.  Should the office pool hit, I’ll have options.  Besides, it’s entertaining to share in the thrill of anticipation, even if it will undoubtedly end with a tiny payback.

Similes and Alt+Esc

Occasionally, from the mind fog of an early morning, a jumble of words makes its way out of my subconscious.  Observe:

He has the charisma of a bowl of shredded wheat.

Sadly, Ron Weiskind of the Pittsburgh Post-Gazette can lay claim to an earlier rendition of the phrase.  Curse you Google…  As useful as a simile, as they say.

Moving on.


I had an issue with an Excel program today .  A VBA script that wouldn’t die even though I “Ctrl + Break”ed (or is that “Ctrl + Broke” it?) a few hundred times.  Normally, I would restart Excel, but I would need to re-run the program for another 20 minutes to get the output I was looking for.  Google came to the rescue this time.

This post saved my bacon.  “Alt” + “Esc” caused my computer to flash between all of the open programs, but within a few seconds the program stopped its endless loop and brought a welcome sight:

interrupted

“Alt” + “Esc” is a different/faster version of “Alt” + “Tab” to switch between open applications.  It helps to switch between Word or E-mail or Excel or your web browser without having to use the mouse while adding to your geek cred.  Less mouse equals more better.  True story.