# Question: Reconsider the coin flipping game introduced in Sec 20 1 and

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).

(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).

**View Solution:**## Answer to relevant Questions

The weather can be considered a stochastic system, because it evolves in a probabilistic manner from one day to the next. Suppose for a certain location that this probabilistic evolution satisfies the following ...The game of craps requires the player to throw two dice one or more times until a decision has been reached as to whether he (or she) wins or loses. He wins if the first throw results in a sum of 7 or 11 or, alternatively, ...Obtaining uniform random numbers as instructed at the beginning of the Problems section, generate four random observations from an exponential distribution with mean = 1. Then use these four observations to generate one ...Michael Wise operates a newsstand at a busy intersection downtown. Demand for the Sunday Times at this newsstand averages 300 copies with a standard deviation of 50 copies. (Assume a normal distribution.) Michael purchases ...Reconsider Prob. 20.3-1. Suppose now that you want to convert these random integer numbers to (approximate) uniform random numbers. For each of the three parts, give a formula for this conversion that makes the approximation ...Post your question