This MTH154 Excel

B In this problem, you will flip a coin and bet on Tails coming up. You will start with a $10 bet and will double your bet if you lose; once you win you revert to the $10 bet. Then you will determine the maximum bet and the maximum winnings. Steps to Perform: Step Instructions Points Possible Start Excel. Download and open the workbook named: Chapter 11-4 Casino Start In cell C6, use the IF and nested RAND functions to flip a coin for the first time. 2 2 Note: Use "H" for head and "T" for tail in the arguments of the IF function. w In cell D6, use the IF function that returns 1 if the first flip is H, else it returns 0. IN In cell E6, use the IF function that returns $10 if the first flip is T. else it returns -$10. Format cell E6 as Currency with 2 decimal places. A In cell B7, use the IF function that returns $10 if the first flip is T. else it doubles the previous bet. Fill cell B7 down the column to cell B155. Format cells B7:B155 as Currency with 2 decimal places. 6 Fill cell C6 down the column to cell C155. N 7 In cell D7, use the IF function that returns 0 if the flip is T when you flip the coin for the second time, else it adds 1 to the number in previous cell in column D (i.e., the IF function in cell D7 should refer to cell D6). Fill cell D7 down the column to cell D155. 4 In cell E7, use the IF function to determine the winnings when you flip the coin for the second time. Fill cell E7 down the column to cell E155. Format cells E7:E155 as Currency with 2 decimal places. 9 In cell J27, calculate the maximum number of H in a row. IN 10 In cell J28, calculate the probability of flipping a fair coin and getting that many heads in a row determined in cell J27. Format cell J28 as Percentage with 3 decimal places. 11 In cell J29, calculate the expected number of times you get the maximum number of H in a row in 150 flips. IN 12 In cell J32, use the MAX function to determine the maximum bet at 150 flips. Format cell J32 as Currency with 2 decimal places. 4 13 In cell J33, use the MAX function to determine the maximum winnings at 150 flips. Format cell J33 as Currency with 2 decimal places. 4 14 In cell J36, determine by how much your winnings increase from just before the losing streak starts to right after it ends. 2 15 In cell J39, determine the reason why this is called "gambler's ruin". N 16 Save your file and submit for grading. 0 Total Points 46