Regression and Correlation Analysis

Please Detailed step by step explanation required

Refer to the Baseball 2016 data, which reports information on the 2016 Major League Baseball season. Let attendance be the dependent variable and total team sal-ary be the independent variable.

Determine the regression equation and answer the following questions.

a. Draw a scatter diagram. From the diagram, does there seem to be a direct relation-ship between the two variables?

b. What is the expected attendance for a team with a salary of $100.0 million?

c. If the owners pay an additional $30 million, how many more people could they ex-pect to attend?

d. At the .05 significance level, can we conclude that the slope of the regression line is positive? Conduct the appropriate test of hypothesis.

e. What percentage of the variation in attendance is accounted for by salary?

f. Determine the correlation between attendance and team batting average and be-tween attendance and team ERA. Which is stronger? Conduct an appropriate test of hypothesis for each set of variables.

Team League Opened Team Salary Attendance Wins ERA BA HR year Average Salary W N Arizona National 1998 65.80 2080145 79 4.04 0.264 154 2000 1.99 4 Atlanta National 1996 89.60 2001392 67 4.41 0.251 100 2001 2.26 Baltimore American 1992 118.90 2281202 81 4.05 0.25 217 2002 2.38 6 Boston American 1912 168.70 2880694 78 4.31 0.265 161 2003 2.56 7 Chicago Cubs National 1914 117.20 2959812 97 3.36 0.244 171 2004 2.49 8 Chicago White Sox American 1991 110.70 1755810 76 3.98 0.25 136 2005 2.63 9 Cincinnati National 2003 117.70 2419506 64 4.33 0.248 167 2006 2.87 10 Cleveland American 1994 87.70 1388905 81 3.67 0.256 141 2007 2.94 11 Colorado National 1995 98.30 2506789 68 5.04 0.265 186 2008 3.15 12 Detroit American 2000 172.80 2726048 74 4.64 0.27 151 2009 3.24 13 Houston American 2000 69.10 2153585 86 3.57 0.25 230 2010 3.3 14 Kansas City American 1973 112.90 2708549 95 3.73 0.269 139 2011 3.31 15 LA Angels American 1966 146.40 3012765 85 3.94 0.246 176 2012 3.44 16 LA Dodgers National 1962 230.40 3764815 92 3.44 0.25 187 2013 3.65 17 Miami National 2012 84.60 1752235 71 4.02 0.26 120 2014 3.95 18 Milwaukee National 2001 98.70 2542558 68 4.28 0.251 145 2015 4.25 19 Minnesota American 2010 108.30 2220054 83 4.07 0.247 156 2016 4.4 20 Ny Mets National 2009 100.10 2569753 90 3.43 0.244 17721 NY Yankees American 2009 213.50 3193795 87 4.05 0.251 212 22 Oakland American 1966 80.80 1768175 68 4.14 0.251 146 23 Philadelphia National 2004 133.00 1831080 63 4.69 0.249 130 24 Pittsburgh National 2001 85.90 2498596 98 3.21 0.26 140 25 San Diego National 2004 126.60 2459742 74 4.09 0.243 148 26 San Francisco National 2000 166.50 3375882 84 3.72 0.267 136 27 Seattle American 1999 123.20 2193581 76 4.16 0.249 198 28 St. Louis National 2006 120.30 3520889 100 2.94 0.253 137 29 Tampa Bay American 1990 74.80 1287054 80 3.74 0.252 167 30 Texas American 1994 144.80 2491875 88 2.24 0.257 172 31 Toronto American 1989 116.40 2794891 93 3.8 0.269 232 32 Washington National 2008 174.50 2619843 83 3.62 0.251 177 33