UseBaseball_2015.xlsfile (SEE COMMENTS BELOW FOR LINK TO DATA SET) which consists of 30 Major League Baseball teams' statistics from 2015. It includes variables regarding the games played, wins & losses, at bats, runs scored, hits, homeruns, total bases, runs batted in, batting average, on base percentage, strikeouts, stolen bases, earned run average, saves, opponent runs, opponent batting average, errors, team payroll, the dollar value of each team win, and whether the team made it to the playoffs (FYI, Kansas City ultimately won the World Series).

ASSIGNED PROBLEM 1: Conduct a simple correlation analysis to determine if there is a correlation between Runs and Wins. Use a .05

significance level.

1. Which is the dependent variable?

A. Wins

B. Runs

2. What is the computed p-value?

3. True or False....The null hypothesis should be rejected.

4. True or False....It can be concluded that correlation exists.

5. What is the computed correlation coefficient?

6. Is the correlation direct or inverse?

A. It is a direct correlation

B. It is an inverse correlation

C. It is neither direct nor inverse

7. What is the strength of the correlation?

A. Perfect

B. Strong

C. Moderate

D. Weak

E. There is zero correlation

8. Fill in the best fit regression equation: ____=____+____*_____

9. How many wins would you predict for a team that scored 800 runs?

10. What percent of variability in the Wins can be explained by the regression model?

11. The slope of the equation tells us that a one unit increase in the number of_______would predict an increase in the number of _______by_______

ASSIGNED PROBLEM 2: Conduct a simple correlation analysis to determine if there is a correlation between Payroll and Wins. Use a .05 significance level.

1. Which is the dependent variable?

A. Payroll

B. Wins

2. What is the computed p-value?

3. True or False....The null hypothesis should be rejected.

4. True or False....It can be concluded that correlation exists.

5. What is the computed correlation coefficient?

6. Is the correlation direct or inverse?

A. It is a direct correlation

B. It is an inverse correlation

C. It is neither direct nor inverse

7. What is the strength of the correlation?

A. Perfect

B. Strong

C. Moderate

D. Weak

E. There is zero correlation

8. Fill in the best fit regression equation:____=____+____*____