In the Excel file that is linked to this question, you will see the stock prices for 2 different stocks.

a) Please calculate the Mean, Variance, Standard Deviation, Covariance and Correlation for your two stock returns.

b) Assume that you have a hypothetical portfolio of 30% (stock 1) and 70% (stock 2 ). Calculate the portfolio mean return and standard deviation of this portfolio.

c) Vary the proportions of your stock 1 between -1 and +1 (increments of 0.1) and create a data table for portfolio means and standard deviations for the different weights used

d) Draw a graph of portfolio standard deviations and mean returns using the different values you found in the data table.

e) Describe/Explain what the graph shows us with your own words