Module 10: Advanced multiple regression
(The attached PDF file has better formatting.)
Homework assignment: Two correlated independent variables
Do this homework assignment after module 12, which gives the equations for the standard errors of the least squares estimators.
We regress the Y values on the X1 and X2 values in the table below.
X1
X2
Y
1
1.016
6
8
-1.076
2
-3.429
7
4
3.461
3
0.049
9
-2.525
-3.099
5
4.195
0.359
10
-0.746
What is the correlation of X1 and X2?
What is the least squares estimator of
á?
â1, the coefficient of X1?
â2, the coefficient of X2?
What is the standard error of the least squares estimator of
Show the formulas and the computations. You can check your work with Excel or other statistical software.