In this assignment the MLB association has hired you as a consultant. They want you to analyze data regarding the earnings index for relevant teams. You should give your prospective outlook for the teams.

A. Use Excel to calculate the mean, median and mode for salary, attendance, and wins. Then, make a histogram for each variable and discuss skewness. Display and discuss this information in your PowerPoint.

B. Use the rule of 2? to generate a frequency table for salary, attendance, and wins. Do a relative frequency table and a pie graph for those variables as well. Which class has the largest frequency? Which class has the smallest frequency? Display and discuss this information in your PowerPoint.

C. Do a scatter plot between salary and attendance as well as salary and wins. Is there a direct or indirect relationship between salary and attendance? What about the relationship between salary and the number of wins? What are the correlation coefficients? Display and discuss this information in your PowerPoint.

D. Calculate the standard error for salary, using the formula in your textbook, with the appropriate sample size adjustments. Then, calculate a confidence interval around the mean associated with an alpha of 0.05, 0.10 and 0.32. Explain in each case how confident you are that the mean falls in that interval. Display and discuss this information in your PowerPoint.

E. Conclude your presentation with a short write up using the scientific method. You will want to determine the critical values for a two tailed hypothesis test for the 95%, 90% and 68% levels of confidence for salary, attendance, and wins. Display and discuss this information for each variable on a separate slide.

1. Is the mean sample mean for salary, attendance, and wins significantly different from the population mean for salary, attendance, and wins? (Note: the population mean for team salary is 175, the population mean for attendance is 2758667, and the population mean for wins is 95.) What was/were the testable hypothesis(es) from the data?

2. What statistic did you use (t-stat or z-score) and why?

3. Did you reject the hypothesis(es) or fail to reject the hypothesis(es) at the 95%, 90% and 68% levels of confidence?

4. Compute 2 regressions in Excel with salary as the dependent variable. Explain the relationship between salary and attendance as well as the relationship between salary and wins. Are the slope coefficients significant at the 95% level of confidence? How well is the variation in the dependent variable explained?

5. What inference can be safely drawn from your hypothesis testing? Specifically, would you advise the MLB association to do in the future?

AutoSave O A A 9 5 . C ... XMLB Assignment.xIsx - Read-Only Q Search (Cmd + Ctrl + U) Comments Share Home Insert Draw Page Layout Formulas Data Review View ap Wrap Text General EX AY- O. Comic Sans MS v 12 AA Sort & Find & Analyze Conditional Format Cell Insert Delete Format Paste BIUV DVAv E Merge & Center v $ ~ % 9 Formatting as Table Styles Filter Select Data Restart Now x Update Available We've made some fixes and improvements. To complete the process, the app needs to restart. 01 4 X V j N A B C D E F G H I J K L M Team League Year Opened Team Salary Attendance Wins Arizona National 1998 65.80 2080145 19 W N Atlanta National 1996 39.60 2001392 67 Baltimore American 1992 118.90 2281202 81 American 1912 168.70 2880694 78 Boston Chicago Cubs National 1914 117.20 2959812 97 Chicago Sox American 1991 110.70 1755810 76 8 Cincinnati National 2003 117.70 2419506 64 9 Cleveland American 1994 87.70 1388905 81 10 Colorado National 1995 98.30 2506789 68 11 Detroit American 2000 172.80 2726048 74 12 Houston American 2000 69.10 2153585 36 13 Kansas City American 1973 112.90 2708549 95 14 LA Angels 1966 146.40 85 American 3012765 15 LA Dodgers National 1962 230.40 3764815 92 16 Miami National 2012 84.60 1752235 71 17 Milwaukee National 2001 98.70 2542558 68 18 Minnesota American 2010 108.30 2220054 83 19 NY Mets National 2009 100.10 2569753 90 20 NY Yankees American 2009 213.50 3193795 87 21 Oakland American 1966 80.80 1768175 68 22 Philadelphia National 2004 133.00 1831080 23 Pittsburgh National 2001 85.90 2498596 98 24 San Diego National 2004 126.60 2459742 74 2000 166.50 3375882 34 25 San Francisco National 76 26 Seattle American 1999 123.20 2193581 27 MLB Data Set 17e + + 130% Ready Accessibility: Good to go