Use Excel to calculate the following Answers:

5. Assume you have a Corp and NeverGot Corp. (The portfolio weights are cited in the table). The mean annual returns, standard deviation of returns and correlation of returns are cited in the following table: portfolio that is not equally invested in GottaHaveit Corp. and Couldhadit Portfolio Weight 25% 50% Mean Return Standard Deviation Gottahaveit Corp. (G) Couldahadit Corp. (C) NeverGotit Corp (N) 9% 11% 14% of Returns 15% 20% 28% | 25% Correlation 0.30 Correlation (G,C) Correlation (G,N) 0.50 Correlation (C,N) 0.10 What is the mean return for this portfolio of Gottahaveit, Couldahadit and NeverGotlt Corp.? d. e. What is the portfolio variance for the weighted portfolio of these three stocks? What is the portfolio standard deviation variance for the weighted portfolio of these three stocks? f