A Football Tournament Is Conducted Between Team-A and Team-B of a College

Essay

A football tournament is conducted between Team-A and Team-B of a college and the winner being the first team to win four games of seven games. The probability that Team-A wins each game are as follows: $$\begin{array} { l | c c c c c c c } \text { Game } & 1 & 2 & 3 & 4 & 5 & 6 & 7 \\\hline \text { Probability of Win } & 0.48 & 0.5 & 0.45 & 0.6 & 0.55 & 0.40 & 0.55\end{array}$$ ​
a. Set up a spreadsheet simulation model in which whether Team-A wins each game is a random variable.
b. What is the probability that the Team- A win the tournament?
c. What is the average number of games played regardless of winner?