Reconsider the coin flipping game introduced in Sec. 22.1 and analyzed with simulation in Figs. 22.1, 22.2, and 22.3.

(a) Simulate one play of this game by repeatedly flipping your own coin until the game ends. Record your results in the format shown in columns B, D, E, F, and G of Fig. 22.1. How much would you have won or lost if this had been a real play of the game?

E

(b) Revise the spreadsheet model in Fig. 22.1 by using Excel’s VLOOKUP function instead of the IF function to generate each simulated flip of the coin. Then perform a simulation of one play of the game.

E

(c) Use this revised spreadsheet model to generate a data table with 14 replications like Fig. 22.2.

E

(d) Repeat part

(c) with 1,000 replications (like Fig. 22.3).