Copy and paste the data below into Excel. There are 14 observations; be sure to copy all of them.

Use 2 decimal places for all your calculations.

Calculate the mean of X [ Select ] ["3", "4.25", "2.2", "3.36", "1.84"]

Calculate the mean of Y [ Select ] ["1.48", "21.63", "3.63", "1.84", "3.36"]

Calculate (xix)(yiy) is [ Select ] ["0.0524", "0.67", "0.1377", "483.44", "0.000", "0.48"] .

Which excel function would you use to calculate covariance? [ Select ] ["=covariance.p", "=correl.s", "=covar.s", "=covar.p", "=covariance.s", "=correl"]

Calculate the covariance [ Select ] ["0.67", "37.19", "0.00", "0.05"]

The interpretation of covariance [ Select ] ["The covariance is positive and indicates that as Y increases, X decreases.", "because the covariance is a large number, we can conclude there is a strong relationship between Y and X.", "The covariance is positive and indicates that as Y increases, X increases.", "The covariance is positive and indicates that as X increases, Y does not change."]

Y	X
1	0.5
1.5	1.75
2	3.5
2.5	5.75
3	8.5
3.5	11.75
4	15.5
4.5	19.75
5	24.5
5.5	29.75
6	35.5
6.5	41.75
7	48.5
7.5	55.75

abcde