C-calculate the covariance between these two stocks based on the15 years of returns .?

Spreadsheet Exereises 8-1 Closing prices for Sil Tech and New Mines for the years 1999-2014 are shown below a. Calculate the total returns for each stock for the years 2000-2014 to three decimal places. Note that the price for 1999 is used to calculate the return for 2000. b. Assume that similar returns will continue in the future (ie, average returns - expected returns). Calculate the expected return, variance, and standard deviation for both stocks and insert these values in the spreadsheet. Use Average, Var, and STDEV functions. Spreadsheet Exereises 8-1 Closing prices for Sil Tech and New Mines for the years 1999-2014 are shown below a. Calculate the total returns for each stock for the years 2000-2014 to three decimal places. Note that the price for 1999 is used to calculate the return for 2000. b. Assume that similar returns will continue in the future (ie, average returns - expected returns). Calculate the expected return, variance, and standard deviation for both stocks and insert these values in the spreadsheet. Use Average, Var, and STDEV functions