In this assignment you want to conduct the same analysis on the date below where, again, Y is
the dependent variable and X1, X2, and X3 are explanatory variables:
Y
X1
X2
X3
10 0 10 5
15 1 6 4
10 2 8 5
20 3 0 5
30 4 10 4
40 5 4 4
30 6 0 6
50 7 0 4
50 8 2 5
80 9 0 6
In you Excel spreadsheet do each of the following:
1. Place your name in the top left corner.
2. Type out the X and Y matrices.
3. Determine and identify the X'X matrix.
4. Determine and identify the (X'X)¹ matrix.
5. Determine and identify the X'Y matrix.
6. Determine and identify the coefficient matrix β using your matrices above.