[Feel free to submit your relevant STATA/Excel output) 1. (40 points) Upload Major League Baseball Data Set in STATA and answer the following questions. The Excel file has the variable descriptions. I (a) What is the overall average salary. What is the average salary in the American and National League (Note that league=1 is American League team and league=0 is National League team). (b) Perform a two-sample t-test with unequal variance for the null hypothesis that average salary of American League = average salary of National League against a two-sided alternative hypothesis. (c) Plot a scatter diagram of wins and batting. Does a MLB teams batting average relate to the number of wins over a season? Fit the appropriate simple linear regression model to the dataset and test the significance of the slope parameter (use a significance level of 5%). (d) What is the correlation between salarymil, wins, batting, era and hr. Which variable has the highest correlation with wins? Is the correlation really different across two Leagues. (e) Estimate a multiple regression of wins on salarymil, batting, era and hr. Discuss the statistical significance of all four explanatory variables. Which explanatory variable is the most influential? S10 For x2 fx EX X EX X 1X1 2 1 Team XIB M X2 BIX Lp Scary - ERA ure 3311 577 4 0 10 SIECI LORE GE NO 451 we 1913 1923 16 1919 16 19 16 1 130 Anne 95 2841,743 91 4 3.10. 2.AM 6 91 2016,30 New York Yash Da 7 Le Arir Angela Geveland WS 15 15 20 2003 954 71 971 415 713 11 3232 88 PL 16 40 11 D 5. 11 . ODOSI 10 10 20 200 IN 111 3 1 S0516 WIT 1 1 SA 2.014295 2012 114 I to Pure LOV 11 Min Trey MT Der 23710000 4STIS Sone 2977 000 WOOD ** 10000 700 SI ASEGER VE 14 19 ho 1 LED 41611 . . . IT 1.748 102 WO 10 LE ME . 0 SOO 4099 400 WE we kanssa A Ano 20 a Cat New York 2019371 2. . 18 FEE 11 2000 LO EN 1 C1 1234 O 0 767 10 210 300 EM STELDE 050 0 55735 NI DEBRECROEDERDELE 443 1 ) 3001 15 63 0 . 145 BAN 2. THE RE 41 TO SHOP . . a 0 2004 16 2.1 w 19000 9 NE IN DE 90 921 10 . GIDS OVER 3 LAD SD W 27 France 2 le Morte Maladie 3 Mike Chapeute Gerade TESTI POEWE 42511 . 0210 272 010 11 0910 138 16 115 . 5 30 119 2004 300 1914 2211 1,500,000 DEC ECONE BOSS 10 45 65 o 10 118 SHEMA . [Feel free to submit your relevant STATA/Excel output) 1. (40 points) Upload Major League Baseball Data Set in STATA and answer the following questions. The Excel file has the variable descriptions. I (a) What is the overall average salary. What is the average salary in the American and National League (Note that league=1 is American League team and league=0 is National League team). (b) Perform a two-sample t-test with unequal variance for the null hypothesis that average salary of American League = average salary of National League against a two-sided alternative hypothesis. (c) Plot a scatter diagram of wins and batting. Does a MLB teams batting average relate to the number of wins over a season? Fit the appropriate simple linear regression model to the dataset and test the significance of the slope parameter (use a significance level of 5%). (d) What is the correlation between salarymil, wins, batting, era and hr. Which variable has the highest correlation with wins? Is the correlation really different across two Leagues. (e) Estimate a multiple regression of wins on salarymil, batting, era and hr. Discuss the statistical significance of all four explanatory variables. Which explanatory variable is the most influential? S10 For x2 fx EX X EX X 1X1 2 1 Team XIB M X2 BIX Lp Scary - ERA ure 3311 577 4 0 10 SIECI LORE GE NO 451 we 1913 1923 16 1919 16 19 16 1 130 Anne 95 2841,743 91 4 3.10. 2.AM 6 91 2016,30 New York Yash Da 7 Le Arir Angela Geveland WS 15 15 20 2003 954 71 971 415 713 11 3232 88 PL 16 40 11 D 5. 11 . ODOSI 10 10 20 200 IN 111 3 1 S0516 WIT 1 1 SA 2.014295 2012 114 I to Pure LOV 11 Min Trey MT Der 23710000 4STIS Sone 2977 000 WOOD ** 10000 700 SI ASEGER VE 14 19 ho 1 LED 41611 . . . IT 1.748 102 WO 10 LE ME . 0 SOO 4099 400 WE we kanssa A Ano 20 a Cat New York 2019371 2. . 18 FEE 11 2000 LO EN 1 C1 1234 O 0 767 10 210 300 EM STELDE 050 0 55735 NI DEBRECROEDERDELE 443 1 ) 3001 15 63 0 . 145 BAN 2. THE RE 41 TO SHOP . . a 0 2004 16 2.1 w 19000 9 NE IN DE 90 921 10 . GIDS OVER 3 LAD SD W 27 France 2 le Morte Maladie 3 Mike Chapeute Gerade TESTI POEWE 42511 . 0210 272 010 11 0910 138 16 115 . 5 30 119 2004 300 1914 2211 1,500,000 DEC ECONE BOSS 10 45 65 o 10 118 SHEMA