Plagiarism and use of any articles, paragraphs, data, and tables on the Internet or from other people is strictly prohibited; only use the information I provide to write, and all sentence should be in your words. Attention: You must upload the completed word within 3 hours. Please answer the question: Question 1: The data in the following table are annual total returns for Coca-Cola (stock symbol: KO) and Microsoft (stock symbol: MSFT) for the period 1994-2004. Microsoft is highly regarded by many investors. It had a return more than twice as large as that of Coca-Cola. Suppose an investor had placed half her funds in Coca-Cola and half in Microsoft during this 11-year period. Complete the following calculations to determine the resulting portfolio return and risk. (1) Calculate the mean returns for each stock. (2) Calculate the standard deviation for each stock. (3) The correlation coefficient between the two stocks is 0.16, what are the portfolio return and standard deviation? (4) How does the return and risk of this portfolio compare to the figures for Coca-Cola alone? Why?