
X

Y

Obs 1

3

2

Obs 2

2

1

Obs 3

1

2

Obs 4

2

0

Obs 5

2

5


Consider a random sample of 5 paired measurements in the
following format. It is easy to demonstrate that the sample mean of
each variable is 0.
Using Microsoft Excel, compute the
following:
 Calculate the sample standard deviation of X.
 Calculate the sample standard deviation of Y.
 Calculate the covariance of X and Y.
 Calculate the correlation coefficient of X and Y.
 Are your answers to any of the previous letters the same as in
the previous example?
 Calculate the ratios of your answers in 2a, 2b and 2c to your
answers in 1a, 1b and 1c respectively.
 If n=5, what is n1?
 Using Microsoft Excel, run a regression output from the Data
Analysis ToolPak.
 If you don’t know how to do this, Zoom me.
 Does the sum of squares regression look like the squared norm
of a vector from Question 1? If so, state what it is.
 Does the sum of the squares residual look like the squared norm
of a vector from Question 1? If so, state what it is.
 Does the slope of the least squares regression line appear
anywhere in your calculations in question ? If so, what is it?