View the step-by-step solution to:

Team Payroll Wins ALAnaheim 79.03 ALBaltimore 73.88 ALBoston 99.95 ALChicago 51.01 ALCleveland 48.58 ALDetroit 49.17 ALKansas City 40.52 ALMinnesota...

The Question & the Information is in the Excel Sheet
1. Use the Baseball tab and write a memo describing your findings about the relationship between number of wins and payroll. Apply the regression analysis and include the following information:
a. Regression coefficients
b. Coefficient of determination
c. Correlation coefficient
d. Determine how well if the relationship between number of wins and payroll is significant by using testing hypothesis method.

e. Determine an estimate for the cost of an additional win.

Team Payroll Wins ALAnaheim 79.03 77 ALBaltimore 73.88 71 ALBoston 99.95 95 ALChicago 51.01 86 ALClevelan 48.58 68 ALDetroit 49.17 43 ALKansas C 40.52 83 ALMinnesot 55.51 90 ALNew York 152.75 101 ALOakland 50.26 96 ALSeattle 86.96 93 ALTALpa B 19.63 63 ALTexas 103.49 71 ALToronto 51.27 86 NLArizona 80.6 84 NLAtlanta 106.2 101 NLChicago 79.9 88 NLCincinna 59.4 69 NLColorado 67.2 74 NLFlorida 49.1 91 NLHouston 71.0 87 NLLos Ange 105.9 85 NLMilwauke 40.6 68 NLMontreal 51.9 83 NLNew York 117.2 66 NLPhiladelp 70.8 86 NLPittsburg 54.8 75 NLSan Dieg 47.9 64 NLSan Fran 82.9 100 NLSt. Louis 83.5 85

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
• -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents