Baseball's World Series is a maximum of seven games, with the winner being the first team to win four games. Assume that the Atlanta Braves and the Minnesota Twins are playing in the World Series and that the first two games are to be played in Atlanta, the next three games at the Twins' ballpark, and the last two games, if necessary, back in Atlanta 0.45 0.42 0.46 0.5 0.46 0.41 0.52
a. Set up a spreadsheet simulation model in whether Atlanta wins each game is a random variable. (Do 100 simulations) What is the probability that the Atlanta Braves win the World Series? If required, round your answer to two decimal places.
b. What is the average number of games played regardless of the winner? If required, round your answer to the nearest whole number.