Question: Use R code to create multiple linear regression models that answer the following questions. 1. Once we control for the number of games played, what

Use R code to create multiple linear regression models that answer the following questions.

1. Once we control for the number of games played, what is the relationship between Two-Point Shooting Percentage and number of wins?

2.Once we control for the number of games played and the Two-Point Shooting Percentage, what are the differences in average numbers of wins when comparing the conferences? [For this model, treat YEAR as a categorical variable, i.e. as.factor(YEAR)]

3. Once we control for individual variability between schools, are there differences in Two-Point Shooting Percentage when comparing the years in the data set?

4.Once we control for individual variability between schools, are there differences in Two-Point Shooting Percentage when comparing the conferences?

Please just include the R code used to create each of these models: I can't upload the excel file for you to get the results so all I need is the code and I can do the rest, thank you. Here are the variables:

  • TEAM: The Division I college basketball school
  • CONF: The Athletic Conference in which the school participates in
  • G: Number of games played
  • W: Number of games won
  • ADJOE: Adjusted Offensive Efficiency (An estimate of the offensive efficiency (points scored per 100 possessions) a team would have against the average Division I defense
  • ADJDE: Adjusted Defensive Efficiency (An estimate of the defensive efficiency (points allowed per 100 possessions) a team would have against the average Division I offense)
  • BARTHAG: Power Rating (Chance of beating an average Division I team)
  • EFG_O: Effective Field Goal Percentage Shot
  • EFG_D: Effective Field Goal Percentage Allowed
  • TOR: Turnover Percentage Allowed (Turnover Rate)
  • TORD: Turnover Percentage Committed (Steal Rate)
  • ORB: Offensive Rebound Percentage
  • DRB: Defensive Rebound Percentage
  • FTR: Free Throw Rate (How often the given team shoots Free Throws)
  • FTRD: Free Throw Rate Allowed
  • TWO_P_O: Two-Point Shooting Percentage. Note the O in the name of the variable is the capital letter O, not the number zero.
  • TWO_P_D: Two-Point Shooting Percentage Allowed
  • THREE_P_O: Three-Point Shooting Percentage. Note the O in the name of the variable is the capital letter O, not the number zero.
  • THREE_P_D: Three-Point Shooting Percentage Allowed
  • ADJ_T: Adjusted Tempo (An estimate of the tempo (possessions per 40 minutes) a team would have against the team that wants to play at an average Division I tempo)
  • WAB: Wins Above Bubble (The bubble refers to the cut off between making the NCAA March Madness Tournament and not making it)
  • YEAR: Season (2015, 2016, 2017, 2018, or 2019)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!