CORREL +1.0 7-2 The data below are annual total returns for General Foods (GF and Sigma Technology (ST for the period 1997-2011. Sigma Technology is highly regarded by many investors for its innovative products. It had returns more than twice as large as that of General Foods. What would have been results if an investor had placed half her funds in General Foods and half the to try to eam alarger return than that in Sigma during this 15-year period in orde available in General Foods alone? Would the risk have been too large? a. Calculate the arithmetic mean returns for each stock. b. Calculate the standard deviation for each stock using the STDEv function in the spreadsheet. c. Calculate the correlation coefficient using the coRREL function in the spreadsheet. d. Calculate the covariance using the covAR function in the spreadsheet. e. Calculate the portfolio return assuming equal weights for each stock