Portfolio analysis You have been given the expected return data shown in the first table on three assetsF, G, and H-over the period 2016-2019: E Using these assets, you have isolated the three investment alternatives shown in the following table: B i Data Table a. Calculate the average retum over the 4-year period for each of the three alternatives, b. Calculate the standard deviation of returns over the 4-year period for each of the three alternatives. c. Use your findings in parts a and b lo calculate the coefficient of variation for each of the three alternatives. d. On the basis of your findings, which of the three investment alternatives do you think performed better over this period? (Click on the icon here in order to copy the contents of the data table below a. The expected return over the 4-year period for alternative 1 is %. (Round to two decimal place.) into a spreadsheet.) Expected Return The expected return over the 4-year period for alternative 2 is % (Round to two decimal place.) Year Asset F Asset G Asset H 2016 18% 19% 16% The expected retur over the 4-year period for alternative 3 is %. (Round to two decimal place.) 2017 19% 18% 17% 2018 20% 17% b. The standard deviation of returns over the 4-year period for alternative 1 is % (Round to two decimal places.) 18% 2019 21% 16% 19% The standard deviation of returns over the 4-year period for alternative 2 is %. (Round to two decimal places.) Print Done The standard deviation of returns over the 4-year period for alternative 3 is %. (Round to two decimal places.) c. The coefficient of variation for alternative 1 is (Round to three decimal places.) i Data Table The coefficient of variation for alternative 2 is I. (Round to three decimal places.) The coefficient of variation for alternative 3 is - (Round to three decimal places.) d. On the basis of your findings, which of the three investment alternatives do you recommend? Why? Alternative 1 2 3 Investment 100% of asset F 50% of asset F and 50% of asset G 50% of asset F and 50% of asset H Alternative is the best choice because the assets are (Select the best answers frd Print Done 1 Enter your 2 each of the answer boxes. 3