Question

please show your work step by step, don't put it in writing sometime i can't read it, use excel its very important, show me the formula so i can see how u do it

The following is a set of data from a sample of n = 11 items. Complete parts (a) through (c). o X Y 16 32 8 16 17 34 12 24 18 36 3 6 10 20 19 38 4 8 7 14 15 30 a. Compute the sample covariance. (Round to three decimal places as needed.) b. Compute the coefficient of correlation. c. How strong is the relationship between X and Y? Explain.

Answer 1

First, enter the data in excel sheet

Enter x data from A1 to A11 and y data from B1 to B11

(A) use excel function COVARIANCE.S

select x data as array1 and y data as array2, we get

Covariance =COVARIANCE.S(A1:A11,B1:B11)

or covariance = 64.836

(B) use excel function CORREL to find correlation coefficient

select x data as array1 and y data as array2, we get

r = CORREL(A1:A11,B1:B11)

r = 1.00 (2 decimals)

(C) We have observed a correlation coefficient of 1.00, this means that there is very strong positive correlation correlation. We can say that we have a perfect positive correlation between x and y data values.