Question: Using the data in the copy a contents into wing table, and the fact that the correlation of A and B is 0.54, calculate the

Using the data in the copy a contents into wing table, and the fact that the correlation of A and B is 0.54, calculate the volatility (standard deviation) of a portfolio that is 70% invested in stock A and 30% invested in stock B. (Click on the following icon in ord a spreadsheet) Reallrad Returne Year Stock A Stock B 2008 -11% 17% 2009 30% 20% 2010 0% 8% 2011 -3% -IN 2012 15 -4% 2013 12% 31% The standard deviation of the porte is Rund to be decimal places) Time Remaining: 01:12:28 esc O * 20 F11 2 F2 #3 3 F3 54 4 000 800 4 25 % FS ^ 6 MacBook Air 44 14 & a 7 * 8 11 FB 9 F9 0 F10 11 Next 112 5 Using the data in the following table, and the fact that the correlation of A and B is 0.54 to copy its contents into a spreadsheet.) Realized Returns Year Stock A Stock B 2008 -11% 17% 2009 20% 26% 2010 6% 6% 2011 - 3% -8% 2012 1% -4% 2013 12% 31% The standard deviation of the portfolio is%. (Round to two decimal places.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
