Lottery - FAQ
.9 = 1 - (1-p)n
.1 = (1-p)n
ln(.1) = ln((1-p)n)
ln(.1) = n*ln(1-p)
n = ln(.1)/ln(1-p)
n = ln(.1)/ln(.9999999)
n = 23,025,850.
So, the lottery would need to sell 23,025,850 tickets for the probability of at least one winner to be 90%. In case you were wondering, if the lottery sold exactly ten million tickets the probability of at least one winner would be 63.2%, which is very closely approximated as 1-(1/e).
With two arguments f(x,y)= combin(13,x)*combin(13,y)*12/combin(52,5).
With three arguments f(x,y,z)= combin(13,x)*combin(13,y)*combin(13,z)*12/combin(52,5).
With four arguments f(w,x,y,z)=combin(13,w)*combin(13,x)*combin(13,y)*combin(13,z)*4/combin(52,5).
The probability of all four suits is COMBIN(13,1)3*COMBIN(13,2)*4/combin(52,5) = 26.37%.
The probability of three suits is COMBIN(13,3)*COMBIN(13,1)2*12 + COMBIN(13,1)*COMBIN(13,2)^2*12/combin(52,5) = 58.84%
The probability of two suits is COMBIN(13,3)*COMBIN(13,2)*12 + COMBIN(13,4)*COMBIN(13,1)*12/combin(52,5) = 14.59%
The probability of one suit (including straight and royal flushes ) is 4*combin(13,5)/combin(52,5) = 0.20%.
So three suits are the most frequent outcome.
(8/36)n = 1/41,400,000
log((8/36)n) = log(1/41,400,000)
n × log(8/36) = log(1/41,400,000)
n = log(1/41,400,000)/log(8/36)
n = -7.617 / -0.65321
n = 11.6608
So there you go, the probability of hitting the SuperLotto is the same as rolling a seven or eleven 11.66 times in a row. For those who can’t comprehend a partial throw I would rephrase as the probability falls between 11 and 12 consecutive rolls.
Probability of MatchingNumbers in 6/49 Lottery
| Years | Probability |
| 5 | 0.009640 |
| 10 | 0.038115 |
| 15 | 0.083800 |
| 20 | 0.144158 |
| 25 | 0.215822 |
| 30 | 0.295459 |
| 35 | 0.379225 |
| 40 | 0.463590 |
| 45 | 0.545437 |
| 50 | 0.622090 |
| 55 | 0.691985 |
| 60 | 0.753800 |
| 65 | 0.807008 |
| 70 | 0.851638 |
| 75 | 0.888086 |
| 80 | 0.917254 |
| 85 | 0.940000 |
| 90 | 0.957334 |
| 95 | 0.970225 |
| 100 | 0.971954 |
In case you were wondering, the number of draws for the probability of a matching draw to first exceed 50% is 4,404.
For example, on the Monday Night football game of November 9, 2009 they have the following choices:
Steelers win by 3.5 or more: pays 1.9 for 1
Broncos win by 3.5 or more: pays 3.25 for 1
Margin of victory 3 or less: 3.65 for 1
The sum of the inverses is (1/1.9)+(1/3.25)+(1/3.65) = 1.107981. The inverse of that number is 1/1.107981=0.902543. So, the expected return is 90.25. For a parlay, take the product of the return of all picks made.
I looked at several events, and the return per event ranged from 75.4% to 90.3% (from the above example). The average was 82.6%. Based on that average, here is the expected return according to the number of picks:
2: 68.2%
3: 56.3%
4: 46.5%
5: 38.4%
6: 31.7%
I do indeed think that is a factor that should be considered, albeit a somewhat minor one, in the decision to purchase a lottery ticket. To answer your question, I used the jackpot amount and sales figures found at lottoreport.com. I looked at the Powerball going back to Jan. 2008, because that is as far back as that website has data. I also looked at Mega Millions going back to June 2005, a point at which there was a change in the rules. The following table summarizes my results.
Split Jackpots in Powerball and Mega Millions
| Item | Powerball | Mega Millions |
| Probability of winning jackpot | 1 in 195,249,054 | 1 in 175,711,536 |
| Average jackpot offered | $73,569,853 | $65,792,976 |
| Average sales per draw | $23,051,548 | $25,933,833 |
| Average expected winners per draw | 0.118 | 0.148 |
| Average probability of a split jackpot per draw | 0.74% | 1.29% |
| Loss in return due to shared jackpots (unadjusted) | 4.01% | 6.59% |
| Loss in return due to shared jackpots (adjusted) | 1.41% | 2.31% |
So the average probability that a jackpot will be split is 0.74% in Powerball and 1.29% in Mega Millions. As the jackpot gets higher, and sales go up, so does the probability of splitting the jackpot. The reason the split jackpot probability is higher in Mega Millions is because the probability of winning is greater and there is more competition from other players.
All things considered, I show 4.01% is lost in return due to jackpot sharing in Powerball and 6.59% is lost in Mega Millions. However, those figures don’t account for taxes, or that jackpots are paid in the form of an annuity. To adjust for that, I assumed the player gets only half of it, either by taking the lump sum option or the loss in value from choosing the annuity. I also assumed that 30% of the rest is lost in taxes, so the winner can expect to receive 35% after both factors. After that adjustment, I show a 1.20% loss in return due to jackpot sharing in the Powerball and 1.98% in Mega Millions.
This question was raised and discussed in the forum of my companion site Wizard of Vegas.
You must be referring to the Ca$h WinFall game. I first learned about this from the article A game with a windfall for a knowing few at the boston.com web site.
It is not unusual for the jackpot in progressive lottery games to get so big that the return exceeds over 100%, before considering taxes, annuitized payments, the small odds of winning, and the decreasing utility of money for enormous jackpots. After factoring in these things, the lottery is almost never a good bet.
What makes the Ca$h WinFall game different is that when the jackpot exceeds two million dollars, and nobody hits it, they roll all but $500,000 of the prize money down to the lower prizes. That makes a hefty profit almost ensured for groups with six-figure bankrolls.
Let's take a look at the recent July 18, 2011 drawing as an example. It is a simple 6-46 game in which the player chooses six numbers from 1 to 46 and the lottery does the same. The more your numbers match the lottery's, the more you win. The following table shows the probability and return for each event. The win for catching two numbers is a free ticket, which I show separately as having a value of 26¢. Each ticket costs $2, so the return column is product of the probability and win, divided by ticket price. The lower right cell shows an expected return of 117%, or a player advantage of 17%.
Ca$h WinFall Drawing — July 18, 2011
| Catch | Pays | Combinations | Probability | Return |
|---|---|---|---|---|
| 6 | 2392699.1 | 1 | 0.00000011 | 0.12772207 |
| 5 | 19507 | 240 | 0.00002562 | 0.24990768 |
| 4 | 802 | 11700 | 0.00124909 | 0.50088509 |
| 3 | 26 | 197600 | 0.02109574 | 0.27424465 |
| 2 | 0.24 | 1370850 | 0.14635171 | 0.01756221 |
| 1 | 0 | 3948048 | 0.42149293 | 0.00000000 |
| 0 | 0 | 3838380 | 0.40978479 | 0.00000000 |
| Total | 9366819 | 1.00000000 | 1.17032170 |
Since I initially wrote my answer, the Massachusetts Lottery has restricted the number of tickets any one store can sell in a day to 2,500, or $5,000 worth, according to the article, Lottery restricts high-level players at boston.com. This would obviously make it more difficult to get down huge amounts of money, but it may be good for smaller-bankrolled players, as it should minimize competition from other players. There is only so much money in the "roll down," so the less competition for it the better. I would certainly at least try to play it if I lived anywhere close to Massachusetts.
This question was raised and discussed in the forum of my companion site Wizard of Vegas.
For those not familiar with the story, the Quebec Lottery offers a game titled Extra. The machine randomly picks a 7-digit number, and the player has to match as many digits as possible, in order, from a random draw. The matching digits can be aligned in either direction. The smallest prize is $2 for matching the right-most digit only. The largest prize is $1,000,000 for matching all seven digits.
What the plaintiffs in the lawsuit noticed was that if you purchased ten Extras then for the first and last digits the game picked one of each numeral. In other words, if you looked at the first, or last, position only then you would see all ten numbers from 0 to 9. The plaintiffs claim this gives them only two chances to win and is non-random.
I see their point. Almost all the variance in that game comes from the $1,000,000 jackpot. The standard deviation of ten completely independent random tickets would be 1002.845. The way the Quebec Lottery does it the standard deviation of ten tickets purchased at the same time is almost the same at 1002.833.
In my opinion if the player buys multiple quick pick lottery tickets each ticket should be independent of the others. However, I find the lawsuit of $20 million almost totally frivolous. If I were the judge, I would award the plaintiffs $1.
This question was raised and discussed in the forum of my companion site Wizard of Vegas.
The following table shows the three most frequent set of numbers chosen according to the Quebec Lottery. The number of tickets is out of a total of 366,518 sold for the Jan. 30, 2010 lottery. For those who don't recognize the pattern of the third set, those were the "Lost" numbers, which played a significant role on that show.
Quebec Lottery Most Frequent Picks
| Numbers | Number of Sales in Quebec | Frequency |
|---|---|---|
| 7-14-21-28-35-42 | 824 | 1 in 444.8 |
| 1-2-3-4-5-6 | 424 | 1 in 864.4 |
| 4-8-15-16-23-43 | 377 | 1 in 972.2 |
By extrapolating, if the numbers 7-14-21-28-35-42 were drawn by the Lotto 6/49 game then the jackpot would be split among thousands of players, each receiving only 0.03% of the jackpot.
My advice, if you must play the lottery, is to go with a Quick Pick.
To begin, the article was published on Dec. 17, 2013, before the $636 million drawing that evening. Let's look at the math to evaluate the value of a $1 ticket. The following table shows the probability and expected return of all possible outcomes for the $636 million jackpot, before considering such things as the lump sum penalty, taxes, and jackpot sharing. The top three probabilities are in scientific notation because the numbers are so small.
Mega Millions -- $636 Million Jackpot
| Catch | Mega Ball | Pays | Combinations | Probability | Return |
|---|---|---|---|---|---|
| 5 | Yes | $636,000,000 | 1 | 3.86E-09 | 2.456634 |
| 5 | No | $1,000,000 | 14 | 5.41E-08 | 0.054077 |
| 4 | Yes | $5,000 | 350 | 1.35E-06 | 0.006760 |
| 4 | No | $500 | 4,900 | 0.000019 | 0.009463 |
| 3 | Yes | $50 | 24,150 | 0.000093 | 0.004664 |
| 3 | No | $5 | 338,100 | 0.001306 | 0.006530 |
| 2 | Yes | $5 | 547,400 | 0.002114 | 0.010572 |
| 1 | Yes | $2 | 4,584,475 | 0.017708 | 0.035416 |
| 0 | Yes | $1 | 12,103,014 | 0.046749 | 0.046749 |
| Loser | $0 | 241,288,446 | 0.932008 | 0.000000 | |
| Total | 258,890,850 | 1.000000 | 2.630865 | ||
That shows a $1 ticket will get back $2.630864. After deducting the dollar the ticket cost, the expected profit is $1.630864. Business Insider gets $1.632029. A difference of 0.001164, but no big deal.
However, there are three things that depress the value significantly:
- The lump sum penalty.
- Taxes.
- Jackpot sharing.
Let's look at them one at a time.
Large lottery progressive jackpots are usually paid out in the form of an annuity of about 30 years, including Mega Millions. If the winner wants the money all at once, which most do, he must take a significant reduction. This is only fair because a dollar today is worth more than a dollar in the future. In the case of the December 17, 2013 drawing, the total prize money was reduced to $347.6 million, or 54.65% of the advertised jackpot.
Next, let's look at taxes. The highest federal marginal income tax rate is 39.6%. State taxes range from 0% to 12.3%, so let's just say 6% on average. After taking out 45.6% in taxes, we're left with $189.1 million.
Now comes the trickiest part -- jackpot sharing. It should be noted that starting with the October 22, 2013 drawing Mega Millions changed the rules to a 75-15 format, where they draw five numbers from 1 to 75, and then one from a separate pool of 1 to 15. This reduced the odds of winning to 1 in 258,890,850, evidently in an effort to have bigger jackpots. Looking at just the 17 drawings since then, using jackpot and sales data from LottoReport.com, I find there is an exponential relationship between jackpot size and demand. I found the same thing for the Powerball lottery, by the way. Using exponential regression, my formula for total tickets sold (in millions) is 12.422 × exp(0.0052 × j), where j is the jackpot size (in millions). For example, for a $636 million jackpot, the expected sales would be 12.422 * exp(0.0052*636) = 339.2 (million). Actual sales were $337 million, so pretty close.
Based on the actual ticket sales of 336,545,306, we can expect 336,545,306/258,890,850 = 1.300 winners. The pertinent question is if you win how many other people can you expect to share the money with? This is easily answered looking at the Poisson distribution. Given a mean of 1.3 winners, the probability of exactly x winners is exp(1.3)×1.3x/fact(x). The following table shows the probability of 0 to 10 other winners, your share of the jackpot in each case, and expected share, assuming that you win.
Expected Jackpot Share Given 1.3 Other Winners on Average
| Other winners | Probability | Jackpot share | Expected share |
|---|---|---|---|
| 10 | 0.000001 | 0.090909 | 0.000000 |
| 9 | 0.000008 | 0.100000 | 0.000001 |
| 8 | 0.000055 | 0.111111 | 0.000006 |
| 7 | 0.000339 | 0.125000 | 0.000042 |
| 6 | 0.001827 | 0.142857 | 0.000261 |
| 5 | 0.008431 | 0.166667 | 0.001405 |
| 4 | 0.032429 | 0.200000 | 0.006486 |
| 3 | 0.099786 | 0.250000 | 0.024946 |
| 2 | 0.230283 | 0.333333 | 0.076761 |
| 1 | 0.354295 | 0.500000 | 0.177148 |
| 0 | 0.272545 | 1.000000 | 0.272545 |
| Total | 1.000000 | 0.559602 |
The bottom right cell shows that you can expect to keep 55.96% of the money, and the other 44.04% will go to those darned other winners you'll have to share with.
Now our $636 million jackpot is down to $189.1 × 55.96% = $105.8 million. Let's see what the return table looks like with that figure as the jackpot.
Mega Millions -- $105.8 Million Jackpot
| Catch | Mega Ball | Pays | Combinations | Probability | Return |
|---|---|---|---|---|---|
| 5 | Yes | $105,800,000 | 1 | 3.86E-09 | 0.408666 |
| 5 | No | $1,000,000 | 14 | 5.41E-08 | 0.054077 |
| 4 | Yes | $5,000 | 350 | 1.35E-06 | 0.006760 |
| 4 | No | $500 | 4,900 | 0.000019 | 0.009463 |
| 3 | Yes | $50 | 24,150 | 0.000093 | 0.004664 |
| 3 | No | $5 | 338,100 | 0.001306 | 0.006530 |
| 2 | Yes | $5 | 547,400 | 0.002114 | 0.010572 |
| 1 | Yes | $2 | 4,584,475 | 0.017708 | 0.035416 |
| 0 | Yes | $1 | 12,103,014 | 0.046749 | 0.046749 |
| Loser | $0 | 241,288,446 | 0.932008 | 0.000000 | |
| Total | 258,890,850 | 1.000000 | 0.582898 | ||
The bottom right cell shows that an expected return of 58.29%. In other words your $1 investment can expect to get back about 58 cents, for an expected loss, or house edge, of about 42%. Does that sound like the math saying you should buy a ticket?
According to the article, "So, as long as there are fewer than 730 million tickets sold, a fairly likely situation right now, the expected value of a ticket should be positive, and so you should consider buying a Mega Millions ticket today."
There were a lot fewer than 730 million in sales and it still was a terrible value. However, in all fairness, the article went on to say the following:
"Bear in mind that there are many caveats to this analysis. Taxes will likely hurt your expected winnings pretty severely — the Feds will take about 40%, and your home state will claim anywhere from 0% to around 13%.
A lot of people have been buying tickets, and as discussed above, this will greatly increase the odds of a tie, and the reduced payout that goes with it." — Business Insider
Those are some pretty big caveats! They shouldn't just be mentioned in passing at the bottom but factored into the analysis to begin with.
Not that you asked, but I find the math says you should never play Mega Millions. Given the exponential demand for tickets, based on jackpot size, I find the optimal time to play is a jackpot of $545 million. With jackpots larger than that you'll have to share it with too many other winners. At that jackpot size, the player can expect a return of 60.2%, or a loss of 39.8%. That is as good as it gets.
In closing, no, I do not agree with Business Insider for tricking readers with a sensational title and not doing a proper analysis of taxes and jackpot sharing.
This question is asked and discussed in my forum at Wizard of Vegas.
If we ignore the effects of taxes, the annuity on the jackpot, and jackpot sharing, then if the jackpot is greater than $224,191,728 you should invoke the "Jackpot Only" option. If we do consider those factors, then you should never invoke but the Megaplier instead.
For more information, please see my page on the Mega Millions lottery.
Wiz, I know you're a wet blanket when it comes to the lottery, but can you suggest an easier way to turn $2 into a $1,000,000?
Yes. The house advantage in most lotto-based lottery games is close to 50%. So, a hypothetical $2 game with a $1,000,000 jackpot, with no smaller prizes, would need to have a probability of winning of 0.5*(2/1000000) = 1 in one million to retain a 50% house edge.
Here is my strategy to turn $2 into $1,000,000 with better odds than that.
- First bet $2 on any number in double-zero roulette. You can find $2 minimums at some Vegas casinos, like the El Cortez and South Point. If you win, you'll be up to $72.
- Next, parlay your $72 onto another single-number bet. If you win, you'll be at $2,592.
- Next, carry that $2,592 into one of the high-end casinos on the Strip, like the Wynn, Venetian, or Bellagio. Bet your $2,592 from roulette on the Banker bet in baccarat. Do this a total of nine times, letting everything ride each time. After your ninth win, you'll be up to $1,056,687. Your ninth bet would be for $541,891, which I'm sure any of these casinos would take if they saw you win it in front of their noses.
The probability of winning a single-number bet in double-zero roulette is 1/38. The probability of winning the Banker bet in baccarat is 50.6825%, not counting ties. So, the probability of two roulette wins and nine Banker wins is (1/38)^2 × 0.506825^9 = 1 in 654,404. Those are better odds than the 1 in a million you would get with a lottery and you'll have a little more than a million dollars too.
In the California Lottery there is a game called Hot Spot. It involves a randomly selected "Bulls Eye" ball drawn randomly from 1 to 80. There are 300 games per day. What are the chances that in five days the same Hot Spot number is drawn at the same daily game number in 3 out of the 5 days? For example, the number 23 being drawn in game number 134 (what is Biblical about that number?) on Monday, Wednesday, and Friday.
First, let's solve for the probability that any given game number has exactly 3 out of 5 days with the same number. That answer is COMBIN(5,3)*(1/80)^2*(79/80)^2 = 0.001523682. This is the number of ways to choose the 3 matching days out of 5 times the probability the second and third day match the first times the probability the other two days don't.
So, the probability there is not a 3 out of 5 day match for any given game number is 1 - 0.001523682 = 0.9984763.
The probability this does not happen for 300 days is 0.9984763300 = 63.29%.
Thus, the probability of the alternative, that there is at least one drawing number with 3 out of 5 days matching the same Bulls Eye number is 36.71%.
This question is asked and discussed in my forum at Wizard of Vegas.
I won't go into all the math, but here are the jackpot points where multiple winners are equally likely as exactly one:
- PowerBall: $975 million
- Mega Millions: $1.65 billion
Not that you asked, but here are the jackpots where the probability of at least one winner is equal to the probability of none (50%).
- PowerBall: $704 million
- Mega Millions: $867 million
This question is raised in discussed in my forum at Wizard of Vegas.
What is the breakeven jackpot for the Pennsylvania Cash 5 game? You may ignore taxes and jackpot sharing.
First, let's go over the rules. The bet cost is $2. The game is based on drawing five balls out of 43. Here is the pay table:
- Match 5 = Jackpot
- Math 4 = $200
- Match 3 = $10
- Match 2 = $2
In addition, the player gets what I presume is like a scratch-off card. This has a 1/80 chance of paying $6 and 1/5 chance of paying $2.
The following table shows my analysis of the base game. It shows the value of catching 2 to 4 numbers is $0.287784.
Cash 5 Return Table
| Catch | Pays | Combinations | Probability | Return |
|---|---|---|---|---|
| 5 | jackpot | 1 | 0.000001 | ? |
| 4 | 200 | 190 | 0.000197 | 0.039477 |
| 3 | 10 | 7030 | 0.007303 | 0.073032 |
| 2 | 2 | 84360 | 0.087638 | 0.175276 |
| 1 | 0 | 369075 | 0.383416 | 0.000000 |
| 0 | 0 | 501942 | 0.521445 | 0.000000 |
| Total | 0 | 962598 | 1.000000 | 0.287784 |
The following table shows my analysis of the Quick Cash instant win feature. The lower right cell shows a value of $0.475
Instant Cash Return Table
| Catch | Pays | Probability | Return |
|---|---|---|---|
| 6 | 1 | 0.012500 | 0.075000 |
| 2 | 16 | 0.200000 | 0.400000 |
| 0 | 63 | 0.787500 | 0.000000 |
| Total | 80 | 1.000000 | 0.475000 |
Thus, the value of the non-progressive prizes is $0.287784 + $0.475000 = $0.762784.
Let j equal the value of the breakeven jackpot. Then:
2 = 0.762784 + j × (1/962598)
1.237216 = j × (1/962598)
j = 1.237216 × 962598
j = $1,190,941.95.
The overall rate of return is 0.381392 plus 0.051943 for every $100,000 in the jackpot.
As stated in the question, all this ignores taxes and jackpot sharing.
This question is asked and discussed in my forum at Wizard of Vegas.
My advice for all forms of gambling is based on maximizing how much the player can expect to get back from his bet. In my 25 years of analyzing gambling, that policy has done well for me and you’re the first one to attack me for it.
However, I’m always open to considering other points of view. In this effort, let’s consider a player who cares equally about excitement and value. This player is not going to be happy with low-volatility games, but rather wants to win the whole chandelier or lose trying. To quantify any given bet for such a player, I have created a statistic I call the Excitement Quotient. This I define as the ratio of the standard deviation to element of risk. As a reminder, the element of risk is the ratio of expected player loss to the average amount bet by the end of the hand (including subsequent wagers like doubling in blackjack and raising in poker variants).
The following table shows the Excitement Quotient for a variety of casino games and bets, in order from highest to lowest. It does indeed show that for such an excitement-seeking player, the Mega Millions offers the most excitement for the money.
Excitement Quotient
| Game | Bet | Standard Deviation |
Element of Risk |
Excitement Quotient |
|---|---|---|---|---|
| Mega Millions | 40M jackpot, no Megaplier* | 1158.38 | 0.8104 | 1429.38 |
| Video poker | 25-15-9 Deuces Wild | 5.06 | 0.0109 | 465.68 |
| Video keno | Pick-8 spot keno: 2,12,98,1652,10000 pay table | 29.96 | 0.0769 | 389.56 |
| Blackjack | Liberal low-limit rules** | 1.15 | 0.0049 | 236.60 |
| Roulette | Double zero game, single number bet | 5.76 | 0.0526 | 109.49 |
| Baccarat | Banker bet | 0.93 | 0.0106 | 87.74 |
| Craps | Pass line | 1.00 | 0.0141 | 70.71 |
| Pai gow poker | Dealer banker, house way | 0.75 | 0.0272 | 27.57 |
| Roulette | Double zero game, even money bet | 1.00 | 0.0526 | 18.97 |
*: The line for the Mega Millions does not consider the annuity or taxes.
**: Blackjack assumes six decks, blackjack pays 3-2, dealer hits soft 17, double after split allowed, surrender allowed, re-splitting aces allowed.
Thank you for the comment and for the insult.
This question is asked and discussed in my forum at Wizard of Vegas.