The Parrondo Paradox has to do with taking two horrible situations and turning them into something beautiful. But let's not spoil the result before we even begin. Let's introduce two games instead:

**Game A**

This one couldn't be simpler. You have a single biased coin. When flipped, this coin only produces heads 49.5% of the time, and tails the rest of the time. You flip the coin. If it is heads, you win a dollar. If it is tails you lose a dollar. That's it -- like I said, it's as simple as they come.

**Game B**

This game requires two biased coins. One produces heads fairly rarely -- only 9.5% of the time. Let us call this coin *B1*. The other produces heads a much more frequent 74.5% of the time, on average (call it *B2*). To play this game, we will choose one of these coins and flip it. If we get heads, we again win a dollar -- and if we get tails, we again lose a dollar. We just need to know which coin to flip...

Suppose it's your birthday and your roomate randomly picked some number of dollars (between 0 and 8, inclusive) and put them in your otherwise empty wallet, as a gift. If you counted up the dollar bills in your wallet and divided the total by 3, wouldn't you have an equal likelihood of getting a remainder of 0, 1, or 2? (Note, 0, 3, and 6 produce a remainder of 0; while 1, 4, and 7 produce a remainder of 1; and 2, 5, and 8 produce a remainder of 2.)

Let's use this as a means to choose the coin to flip in a way that involves some randomness. Every time you want to play game B:

- count your money (in numbers of dollar bills);
- divide that by 3 and find the remainder; and
- if the remainder is 0 flip coin
*B1*, while if the remainder is 1 or 2 then flip coin*B2*

Which of these two games would you rather play?

Certainly, the first game looks like a losing game on average, since one wins less than half the time.

Game B looks more promising. Indeed, you have just learned some techniques in your statistics class for calculating probabilities, and you decide to use them to help you find the probability of winning game B. Under the assumption that one-third of the time you flip coin *B1* and two-thirds of the time you flip coin *B2*, and given the respective probabilities of winning with these coins of $0.095$ and $0.745$, you calculate the probability of winning game B as
$$P(\textrm{Win Game B}) = (1/3)(0.095) + (2/3)(0.745) \doteq 0.5283$$

Not surprisingly, you decide playing game B not only is the better game, but it might eventually win you some money over the long haul. So you start playing game B. But after several rounds, you appear to have lost money. Is this just bad luck? ..or is something more curious going on?

To test whether your original analysis was correct, you decide to model both games in Excel -- simulating the cash won or lost after playing both games for a long time.

Let's start with the easier of the two games to simulate, Game A...

On a new Excel worksheet, fill out cells `B4:C4`

, `B1`

, `B9`

, `B11`

, and `E3:F4`

to agree with what is shown below, and set the amount of money initially in your wallet to some random value of your choosing between 0 and 8, inclusive, by putting this number in cell `E5`

.

Then, enter a formula in `F5`

that can be copied and pasted to cells below this cell, so that each cell "plays game A", returning either $1$ or $-1$ in accordance to whether the game was won or lost, respectively. Your formula should reference the probability seen in `C4`

, allowing you to change the probability of winning game A throughout the worksheet by only changing the value in this one yellow cell.

Each cell below `E5`

should report the sum of the money won or lost from the last game played (i.e., the value in the previous row, column `F`

) and however much money one had previously (i.e., the value in the previous row, same column). Enter an appropriate formula in `E6`

to this end.

We would like to get a good feeling for the potential long term impact on one's wallet, so let us play this game an obscene number of times. As such, copy the formulas in `E6`

and `F5`

and paste them into cells to fill a range long enough vertically to represent 20,000 games played. (*The picture above only shows these (orange) cells down to row 24, but you get the idea.*)

So that we don't have to scroll forever to see how much money you have after 20,000 games played, enter a formula in `C11`

to see this final value easily.

Hit the *F9* key several times to simulate several trials of 20,000 games played. Are the results in `C11`

what you expected?

Now let's do something very similar to simulate game B.

Fill cells `H3:I4`

, `B5:C6`

, and `B13`

as shown below, and initialize your new "money" column by putting a random value between $0$ and $8$ inclusive, into cell `H5`

.

Create a formula in `I5`

that can be copied and pasted below it, so each resulting cell "plays game B", again returning either $1$ or $-1$ in accordance to whether the game was won or lost, respectively. Note that each such cell in column `I`

will need to reference not only the cells `C5`

and `C6`

for the probabilities there, but also the cell representing the current amount of money one has (i.e., the cell to the immediate left), so that the right decision can be made with regard to which coin should be flipped.

Enter a formula in `H6`

to keep track of your total amount of money over time, just like was done in column `E`

previously. Then, add a formula to cell `C13`

to show the final amount of money one has after 20,000 games of game B played.

Was the result what you expected?

You are not sure why, but looking at the evidence, it appears Game B is a losing game!

Befuddled as you are about why this might be, you realize that you might be able to use this unexpected result to your advantage to pay off some debt you owe to your math major roomate -- a result of a rather large "trouncing" you took in a recent poker game.

You tell your roomate about the two games, showing off your calculations for the predicted probabilities (but not revealing the results of your recent simulations). You acknowledge that it looks like, based on your calculations that game B wins slightly more often than 50% of the time (recall you got 52.83%), but you are feeling lucky, and would be willing to go "double-or-nothing" on that poker debt you owe him. If he just plays game B a quick 50 times, you explain, and ends up making money as a result of these games, you'll pay him twice what you owe him in addition to the money he just won. But -- if he loses money after his 50 games, the poker debt you owe him must be forgiven, and he needs to pay you whatever he just lost playing game B.

Your roomate counters -- "What if I play both games A and B -- like if every third time I play game A, playing game B the other two times?" Knowing as you do that both games are losing games, how can you refuse? "Sure!" you reply -- secretly thinking your roomate is a bigger sucker than you thought -- everybody can see that game A is a losing game!

"What game would you like to start with?", you magnanimously gesture -- "Let's start with game A", your roomate replies.

(*50 games later...*)

"How is that possible?", you ask -- as you realize you now owe your roomate even more money. ""I guess today just wasn't your lucky day, sorry.", he replies.

Feeling somehow that your math major roomate may have just tricked you (*you've got to watch out for math majors -- we are a sneaky lot!*), you decide to simulate this third situation in Excel as well.

Set up columns `K`

and `L`

and cells `B15:C15`

to simulate the results of playing the sequence of "losing games" *ABB, ABB, ABB,...* (20,000 times), as suggested by what is below:

As before, use *F9* to simulate many trials of 20,000 games played. Typically, what happens? How can this be?

How can one have their money go up, while playing two games that are both working to make it go down?

*Hmmm...*