Student GPA (y) ACT (x) y-avg(y) x-avg(x) (y-avg(y))*(x-avg(x)) (x-avg(x))^2 estimated y residual 1 2.8 21 -0.33 -4.93 1.64 24.34 2.67 0.13 2 3.4 24 0.27 -1.93 -0.52 3.74 2.95 0.45 3 3.0 26 -0.13 0.07 -0.01 0.00 3.14 -0.14 4 3.5 27 0.37 1.07 0.39 1.14 3.23 0.27 5 3.6 29 0.47 3.07 1.43 9.40 3.42 0.18 6 3.0 25 -0.13 -0.93 0.12 0.87 3.04 -0.04 7 2.7 25 -0.43 -0.93 0.40 0.87 3.04 -0.34 8 3.7 30 0.57 4.07 2.30 16.54 3.52 0.18 9 3.2 23 0.07 -2.93 -0.20 8.60 2.86 0.34 10 3.0 28 -0.13 2.07 -0.28 4.27 3.33 -0.33 11 3.5 30 0.37 4.07 1.49 16.54 3.52 -0.02 12 2.5 20 -0.63 -5.93 3.76 35.20 2.57 -0.07 13 3.8 32 0.67 6.07 4.04 36.80 3.71 0.09 14 2.6 26 -0.53 0.07 -0.04 0.00 3.14 -0.54 15 2.7 23 -0.43 -2.93 1.27 8.60 2.86 -0.16 sum sum n sum(y) sum(x) 15.83 166.93 15 47 389 estimated avg(y) avg(x) beta0 0.67 3.13 25.93 beta1 0.09 ##### Sheet/List 2 ##### Student GPA (y) ACT (x) vector y matrix X X' estimated y residual 1 2.8 21 2.8 1 21 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2.67 0.13 2 3.4 24 3.4 1 24 21 24 26 27 29 25 25 30 23 28 30 20 32 26 23 2.95 0.45 3 3.0 26 3.0 1 26 3.14 -0.14 4 3.5 27 3.5 1 27 X'X 3.23 0.27 5 3.6 29 3.6 1 29 15 389 3.42 0.18 6 3.0 25 3.0 1 25 389 10255 3.04 -0.04 7 2.7 25 2.7 1 25 3.04 -0.34 8 3.7 30 3.7 1 30 (X'X)^(-1) 3.52 0.18 9 3.2 23 3.2 1 23 4.10 -0.16 2.86 0.34 10 3.0 28 3.0 1 28 -0.16 0.01 3.33 -0.33 11 3.5 30 3.5 1 30 3.52 -0.02 12 2.5 20 2.5 1 20 X'y beta 2.57 -0.07 13 3.8 32 3.8 1 32 47.00 beta0 0.67 3.71 0.09 14 2.6 26 2.6 1 26 1234.70 beta1 0.09 3.14 -0.54 15 2.7 23 2.7 1 23 2.86 -0.16 ##### Sheet/List 3 ##### y x vector y matrix X X' estimated y real model y residual disturbance 2 1 2 1 1 1 1 1 1 1 1 1.80 1.50 0.20 0.50 6 4 6 1 4 1 4 2 5 3 4 5.77 6.00 0.23 0.00 3 2 3 1 2 3.12 3.00 -0.12 0.00 8 5 8 1 5 X'X (X'X)^(-1) 7.09 7.50 0.91 0.50 5 3 5 1 3 6 19 1.09 -0.29 4.45 4.50 0.55 0.50 4 4 4 1 4 19 71 -0.29 0.09 5.77 6.00 -1.77 -2.00 X'y beta real 28.00 beta0 0.48 0 103.00 beta1 1.32 1.5