In cell I27, use the FORECAST. LINEAR function to determine how many games a team could expect to win in 2019 if the team's salary was $150,000,000.

Reference the salary amount in cell I28 and the appropriate ranges in the Major League Baseball Salaries and Wins by Team table as arguments for your function.

6

In cell I31, use the CONFIDENCE. NORM function to determine the 95% confidence interval for wins in 2019.

Use 0. 05 as the alpha level in your analysis.

Reference the appropriate calculations for size and standard deviation as the arguments for your function.

6

In cell I33, calculate the upper limit for the 95% confidence interval for your win prediction for a team paying $150,000,000 in salaries in the year 2019.

Reference your prediction in cell I27 and the confidence interval calculation in cell I31 in your formula.

3

In cell I35, calculate the lower limit for the 95% confidence interval for your win prediction for a team paying $150,000,000 in salaries in the year 2019.

Reference your prediction in cell I27 and the confidence interval calculation in cell I31 in your formula