Rubric for Assignment 2
Problem 4: (18 points)
- Provide the Excel multiple regression results (4 points) and write down the multiple regression equation (3 points).
- Write down the (two) confidence intervals (3 points). Note: these intervals are part of the regression results from part a.
Based on the first interval, would you remove x1 from the equation? (2 points). Why? (2 points).
Based on the second interval, would you remove x2 from the equation? (2 points). Why? (2 points).
Problem 15: (26 points)
- Provide the Excel results (4 points) and write down the multiple regression equation (3 points).
Perform a test of significance for each coefficient. Note: there are 4 independent variables so you need to perform 4 tests. You need to state if the variable is significant (8 points, 2 points each).
Are the signs of the coefficients as expected? First, state the expected sign and then compare it with the actual sign (4 points, 1 point each).
b. Present a correlation matrix for the independent variables (3 points). Based on this matrix explain if there is evidence of multicollinearity (3 points).
If there is multicollinearity, explain how you would remedy this problem (1 points).
Problem 21: (26 points)
- Provide the Excel multiple regression results (3 points) and write down the multiple regression equation (3 points).
- For each of the 5 independent variables, determine if it should be excluded from the model AND justify your answer (10 points, 2 points each variable).
- Provide the Excel multiple regression results (4 points) and write down the multiple regression equation (3 points) of a model that excludes the least significant variable (there should now be 4 independent variables).
Is this equation better than the one from part a? (1 points) Why? (2 points).
Total: 70 points.
