Please show xcell formulas $!!$

$1.$ Obtain a year$$s daily historical data from yahoo finance of two securities and a construct in excel a portfolio security that shows graphical presentation of the Efficient Frontier and the Capital Market Line.

$2.$ Write to explain the optimal level of the portfolio when considering the Sharpe Ratio.

$3.$ Compute the following and give their interpretations:

a$.$ Expected Returns of each security

b$.$ The standard deviation of each security

c$.$ The portfolio standard deviation

d$.$ Covariance

e$.$ Correlation

f$.$ Coefficient of Variation