I need to use Excel to do most of these calculations. Please HELP

$1.$ Using the annual return data provided in Exhibit $1$ of the case for Lyxor ChinaH and Lyxor MSIndia, calculate their mean returns, standard deviations, covariance, and correlation $($you may use excel for this$).$ With these numbers calculate the standard deviation and return for Susie's entire portfolio.

$2.$ After adding Lyxor USDJIA, what is the portfolio's new standard deviation and return? How does the new portfolio compare with the calculation in Question $1?$

$3.$ Based on your data analysis, should Susie diversify her portfolio or remain invested in China and India only? Support your position using the three possible correlation coefficients here. China$/$India$,$ China$/$US$,$ Us$/$India$.$

$4.$ Calculate the betas of Lyxor ChinaH, Lyxor MSIndia, and Lyxor USDJIA. To calculate the covariance with the market proxy, use the Lyxor World return data shown in Exhibit $1$ in the case. Assuming a risk$-$free rate of $2\mathrm{.}5\%$ and a market risk premium of $5\mathrm{.}5\%,$ what are the required returns for each of the three ETFs? Compare the required returns, estimated from CAPM's E$($R$),$ to the mean historical returns. Are the ETFs undervalued, rightly valued, or overvalued?

$5.$ Calculate the existing portfolio's beta and the new portfolio's beta. Assuming a risk$-$free rate of $2\mathrm{.}5\%$ and a market risk premium of $5\mathrm{.}5\%,$ what are the two portfolios' required returns? Compare the required returns, estimated from CAPM, to the mean historical returns under the old and new portfolios. What do these results tell you?