Data table Expected Return 0.14 0.19 0.40 Standard Deviation 0.17 0.23 Firm A's common stock Firm B's common stock Correlation coefficient (Click on the icon in order to copy its contents into a spreadsheet.) (Computing the standard deviation for a portfolio of two risky investments) Mary Gulott recently graduated from Nichols State University and is anxious to begin investing her meager savings as a way of applying what she has learned in business school. Specifically, she is evaluating an investment in a portfolio comprised of two fims' common stock. She has collected the following information about the common stock of Firm A and Firm B: 5. alf Mary invests half her money in each of the two common stocks, what is the portfolio's expected rate of return and standard deviation in portfolio return? b. Answer part a where the correlation between the two common stock investments is equal to zera. C. Answer pari a where the correlation between the two cominon stack investments is equal to +1. 2. Osing your responses to questions a describe the relationship between the correlation and the risk and retum of the portfolio dbetween the two common to 1 a. If Mary decides to invest 50% of her money in Fim A's common stock and 50% in Firm B's corrman stock and the correlation between the two stocks is 0.40, then the expected rate of return in the portfolio is 0% (Round to two decimal places.) The standard deviation in the portfolio is (Round ta twc decimal places.) b. If Mary decides to invest 50% of her money in Firm A's common stock and 50% in Firm B's common stock and the correlation between the two stocks is zero, then the expected rate of return in the portfolio is %. (Round to two decimal places.) The standard deviation in the portfolio is * {Round to two decimal places.) C- If Mary decides to invest 50% of her money in Firm A's common stock and 50% in Firm B's common stock and the correlation coefficient between the two stacks is +1, then the expected rate of retum in the portfolia is 7%. (Round to two decimal places. The standard deviation in the portfolio is %. (Round to two decimal places.) d. If Mary decides to invest 50% of her money in Firm A's common stock and 50% in Firm B's common stock and the correlation coefficient between the two stocks is - 1, then the expected rate of return in the portollos % (Round to two decimal 6098.) The standard deviation in the portfolio is* (Round to two decimal places.) c. Using your responses to questions -d, which of the following statements best describes the relationship between the correlation and the risk and return of the portfolio? (Select the best choice below.) O A The correlation coefficient has no effect on the expected return of a portfolio, but the closer the correlation coefficient is to negative one. - 1. the lower the risk. OB. The correlation coefficient has a negative effect on the expected return of a portfolo, and the closer the correlation coefficient is to negative one. -1, the lower the risk. O c. The correlation coefficient has no effect on the expected return of a portfolio, but the closer the correlation coefficient is to one, the lower the risk. OD. The correlation coefficient has no effect on the expected return of a portfolio, but the closer the correlation coefficient is to negative one. - 1. the higher the risk