Mathematics Homework Help

I’m working on a statistics multi-part question and need a sample draft to help me learn.

You want to develop aregression model to predict the number of wins achieved byeach NBA team, based on the average point difference and the average field goal percentage difference between the team and itsopponent. Using the Data Analysis add-in, follow the steps listed below and answer the following questions.

6.1Perform multiple linear regression analysis. State the regression equation. 

6.2Interpret the meaning of the slope coefficientsobtained.Explain whether the intercept coefficient hasapractical interpretation or not in the context of this study.

6.3Based on your model, predict wins for a teamwith average point difference of 6, and average field goal % difference of 3.5.

6.4Based  on  the  residual  plots received in  your  model,  comment  on  the plausible satisfaction  of  the normal residual (noise) model assumptions.

6.5 Do you have to use the Durbin-Watson statistic? 

6.6  Repeat  steps  6.1  to  6.4  to  develop  a multiple  linearregression model  that  also  considers  possible interaction between average point difference, and average field goal % difference. Draw your conclusion.

6.7 Based on the results received so far, select and develop a simple linear regression model, repeating steps6.1 to 6.4 for this model. Draw your final conclusion.Submit both your answers summarized in a Word doc file, and your complete Excel solution file. In the Excel file, use the Data Analysis add-in, and store the results in separate (appropriately named)tabs.