I'm not sure your looking at it quite rite.
For simplicities sake, were only going to look at the 7th column over, not the very last column.
The $1 lucky for life ticket has a 1 in 6,000,000 chance to win $650,000.00.... basically if you invest 6 million dollars
you should find one top prize winning ticket. This is a net loss of $5,350,000 for the expected odds to hit a top prize ticket.
If we look at the $20 ticket, the top prize of 5 million dollars has expected odds of 1 in 2,400,000. If you play the expected
amount of tickets, you will likely net a loss of $43,000,00.00
Now, we need to look at the scale of each investment. Ramp up the 6 million dollar investment to 48 million you need to
increase it by a factor of 8. So then now lets increase our losses by a factor of 8 as well. Increases the losses to 42.8 million.
BTW, I scale this investment so that the numbers are easier to see for what they really are. By choosing a certain scale,
one can try to make the numbers show in a certain way so that unless the person looking at the results knows better, they
can be led to make false assumptions. At any rate, I scale both the investments and the winnings by the same amount so
it's still perfectly balanced.
So of course we arrive at very nearly the same investment, and the same net losses. It's still not undeniable to say that the $1
ticket is the better investment when crunching the numbers. It almost becomes a wash, but we need to
look at the other odds involved, and those are of the other prizes that can be won and their odds. That's when the much more
realistic prizes become more important, usually the somewhat smaller prizes.
Again this is just my train of thought, if I'm missing something anyone can please feel free to correct me :)