Use Excel to answer this question

Refer to the table containing the share price of company T and W below:

(a) Compute the returns for both companies. Please use the return definition used in the labs. (b) Compute the average return and standard deviation for each of the returns. (c) Compute the Covariance between the returns. Provide a brief interpretation of what the Covariance measures. (d) Assume that you construct a portfolio where you invest 40% in company T and 60% in company W. What is the average return and standard deviation of this portfolio? (e) Assume that you construct a portfolio where you invest 60% in company T and 40% in company W. What is the average return and standard deviation of this portfolio? (f) Based on the calculation in parts (d) and (e) above, which portfolio weighting you would like to choose, Le, 40% in companyT and 60% in company W or 60% in company T and 40% in company W? Please provide your reasoning