Major League Baseball team from 2004 to 2009

Question # 00004426 Posted By: expert-mustang Updated on: 12/02/2013 11:04 PM Due on: 12/03/2013
Subject Mathematics Topic Calculus Tutorials:
Dot Image

he file P14_49.xlsx lists the average salary for each Major League Baseball team from 2004 to 2009, along with the number of team wins in each of these years.

a. Rearrange the data so that there are four long columns: Team, Year, Salary, and Wins. There should be 6*30 values for each.

b. Create a scatterplot of Wins (Y) versus Salary (X). Is there any indication of a relationship between these two variables? Is it a linear relationship?

c. Run a regression of Wins versus Salary. What does it say, if anything, about teams buying their way to success?
Dot Image
Tutorials for this Question
  1. Tutorial # 00004201 Posted By: expert-mustang Posted on: 12/02/2013 11:05 PM
    Puchased By: 2
    Tutorial Preview
    The solution of Major League Baseball team from 2004 to 2009...
    Major_League_Baseball_team_from_2004_to_2009_-_P14_49.xlsx (32.06 KB)

Great! We have found the solution of this question!

Whatsapp Lisa