Reconsider the coin flipping game introduced in Sec. 20.1 and analyzed with simulation in Figs. 20.1, 20.2, and 20.3.
(a) Revise the spreadsheet model in Fig. 20.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.
(b) Use this revised spreadsheet model to generate a data table with 14 replications like Fig. 20.2.
(c) Repeat part (c) with 1,000 replications (like Fig. 20.3).