Question: need to use excel Question Help Consider the folwing 6 months of retuns for 2 stocks and a portfolio of those 2 stocks: EB Note:

need to use excel
Question Help Consider the folwing 6 months of retuns for 2 stocks and a portfolio of those 2 stocks: EB Note: The portiolio is composed of Aand 50% of Stock B. a. What is the expected return and standard deviation of returns for each of the two stocks? b. What is the expected return and standard deviation of returns for the portfolio? c. Is the portfolio more or less risky than the two stocks? Why? Data Table (Click on the icon located on the top-rightporner of the data table below in order to copy its contents into a spreadsheet.) Feb 5% -3% Mar 8% 1% Jun 4% -2% Jan Stock A Stock B 3% 196 2% 4% Portfolio 1% 1% 1% 196 1% Print Done Check Answer 6:39 PM 10/19/2018 ^
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
