B. Use the rule of 2 to generate a frequency table for salary, attendance, and wins. makea relative frequency table and a pie graph for those variables as well. Which class has the largest frequency? Which class has the smallest frequency?

C. makea 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?

D. Calculate the standard error for salary. 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.

E. Conclude 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.

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