We wish to predict the salary for baseball players (y\displaystyle {y}) using the variables RBI (x1\displaystyle {x}_{{1}}) and HR (x2\displaystyle {x}_{{2}}), then we use a regression equation of the form y^=b0+b1x1+b2x2\displaystyle \hat{{y}}={b}_{{0}}+{b}_{{1}}{x}_{{1}}+{b}_{{2}}{x}_{{2}}

  • HR - Home runs - hits on which the batter successfully touched all four bases, without the contribution of a fielding error.
  • RBI - Run batted in - number of runners who scored due to a batters's action, except when batter grounded into double play or reached on an error
  • Salary is in millions of dollars.

The following is a chart of baseball players' salaries and statistics from 2016.

Player NameRBI'sHR'sSalary (in millions)
Miquel Cabrera1083828.050
Yoenis Cespedes863127.500
Ryan Howard592525.000
Albert Pujols1193125.000
Robinson Cano1033924.050
Mark Teixeira441523.125
Joe Mauer491123.000
Hanley Ramirez1113022.750
Justin Upton873122.125
Adrian Gonzalez901821.857
Jason Heyward49721.667
Jayson Werth702121.571
Matt Kemp1083521.500
Jacoby Ellsbury56921.143
Chris Davis843821.119
Buster Posey801420.802
Shin-Soo Choo17720.000
Troy Tulowitzki792420.000
Ryan Braun913120.000
Joey Votto972920.000
Hunter Pence571318.500
Prince Fielder44818.000
Adrian Beltre1043218.000
Victor Martinez862718.000
Carlos Gonzalez1002517.454
Matt Holliday622017.000
Brian McCann582017.000
Mike Trout1002916.083
David Ortiz1273816.000
Adam Jones832916.000
Curtis Granderson593016.000
Colby Rasmus541515.800
Matt Wieters661715.800
J.D. Martinez68226.750
Brandon Crawford84126.000
Rajai Davis48125.950
Aaron Hill381012.000
Coco Crisp551311.000
Ben Zobrist761810.500
Justin Turner90275.100
Denard Span53115.000
Chris Iannetta2474.550
Leonys Martin47154.150
Justin Smoak34143.900
Jorge Soler31123.667
Evan Gattis72323.300
Logan Forsythe52202.750
Jean Segura64202.600

So you don't have to type all the data into the Reg2 sheet, you can copy the entire table and paste it into the Reg3 sheet or a new sheet. Then copy just the rows you need from the Reg3 sheet or the new sheet and paste them into the Reg2 sheet.

a) Find the multiple linear regression equation. Enter the coefficients rounded to 4 decimal places.
     y^=\displaystyle \hat{{y}}= x1\displaystyle {x}_{{1}} +  x2\displaystyle {x}_{{2}} 

b) Use the multiple linear regression equation to predict the salary for a baseball player with an RBI of 53 and HR of 25. Round your answer to 1 decimal place, do not convert numbers to dollars.
millions of dollars 

c) Holding all other variables constant, what is the correct interpretation of the coefficient b1=0.111\displaystyle {b}_{{1}}={0.111} in the multiple linear regression equation?

d) Holding all other variables constant, what is the correct interpretation of the coefficient b2=0.0371\displaystyle {b}_{{2}}={0.0371} in the multiple linear regression equation?