Please do in excel with formulas if possible

Exhibit 4 You Can Play, but Will You Win? Expected Value Exercises One-Year Expected Value Calculation-College Players \begin{tabular}{rrr} ProbabilityDistribution & ValueofOutcome & Expected Value (Salary) \\ \hline 1.20% & $5,150,000 \\ 11.60% & $3,200,000 \\ 1.30% & $2,400,000 \\ 1.70% & $1,900,000 \\ 1.00% & $160,000 \end{tabular} O ne-Year Expected Value Calculation-High School Players ProbabilityDistribution0.03%0.60%0.10%0.08%0.04%ValueofOutcome$5,150,000$3,200,000$2,400,000$1,900,000$160,000ExpectedValue(salary) Lifetime Value-College Players AveragePlayingCareer(inyears)5.65.53.53.2LifetimeValue4.8 Lifetime Value-High School Players Average Playing Career (in Lifetime years) Lifetime Value-Engineering Probability Distribution 84% $137,243 $137,243 (in years) 45 45 Source: Created by author. Exhibit 4 You Can Play, but Will You Win? Expected Value Exercises One-Year Expected Value Calculation-College Players \begin{tabular}{rrr} ProbabilityDistribution & ValueofOutcome & Expected Value (Salary) \\ \hline 1.20% & $5,150,000 \\ 11.60% & $3,200,000 \\ 1.30% & $2,400,000 \\ 1.70% & $1,900,000 \\ 1.00% & $160,000 \end{tabular} O ne-Year Expected Value Calculation-High School Players ProbabilityDistribution0.03%0.60%0.10%0.08%0.04%ValueofOutcome$5,150,000$3,200,000$2,400,000$1,900,000$160,000ExpectedValue(salary) Lifetime Value-College Players AveragePlayingCareer(inyears)5.65.53.53.2LifetimeValue4.8 Lifetime Value-High School Players Average Playing Career (in Lifetime years) Lifetime Value-Engineering Probability Distribution 84% $137,243 $137,243 (in years) 45 45 Source: Created by author