1 Cell I18 Use Correl Function Determine Relationship Number Wins Team Earned 2010 Amount Q37229920

1. In cell i18, use the CORREL function to determine if there isa relationship between the number of wins a team earned in 2010 andthe amount teams’ salary amount.

2. In cell I21, use the CORREL function to determine if there isa relationship between the number of wins a team earned in 1990 andthe amount teams’ salary amount.

3. In cell I27, use the FORECAST.LINEAR function (or theFORECAST function if you are not using Excel 2016) to determine howmany games a team could expect to win in 2010 if they paid$150,000,000 in salary. Reference the appropriate ranges in thetable and the salary

OR
OR

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.