Create an excel worksheet and populate it, in columns, with
values of X that are -2, -1, 0, 1, 2 and values of Y that are -1,
1,1,1,3. As an aside, note that the sample mean of X is 0. Create
the columns shown below, and enter the proper formulas into
excel.
(X minus
(X minus mean)
Mean)
times (Y
Y
Y-mean
X
X-mean
squared
minus mean)
Y-hat
u-hat
-1
-2
1
-1
1
0
1
1
3
2
sum...