Baseball's World Series is maximum of seven games, with the winner being the first team to win four games.

Asked by bizgrad
Dated: 20th Apr'17 04:12 PM
Bounty offered: $5.00
Baseball's World Series is maximum of seven games, with the winner being the first team to win four games. Assume that the Atlanta Braves are playing the Minnesota Twins 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. Taking into account the projected starting pitchers for each game and the home field advantage, the probabilities of Atlanta winning each game are as follows:

Game1234567
Probability of Win0.460.520.450.550.430.410.6

a. Set up a spreadsheet simulation model in which whether Atalanta wins each game is a random variable

b. What is the probability that the Atlanta Braves win the World Series

c. What is the average number of games played regardless of winners

Baseball's World Series is maximum of seven games, with the winner being the first team to win four games.
Answered by bizgrad
Expert Rating: 2123 Ratings
Dated: 20th Apr'17 04:12 PM
5 words and 1 attachment(s).
Tutorial Rating: Not Rated
Sold 0 times.
(preview of the tutorial; some sections have been intentionally blurred)
…to…

attachments

baseball.xlsx (21.58 KB)
Preview of baseball.xlsx
By1)Prob