Iculate the standard deviation of returns for each of the three alternatives. the basis of your findings in parts a and b. which of the three investment alternatives would you recommend? D X Data table Icu (Click on the icon here in order to copy its contents of the data table below into a spreadsheet.) Alternative Investment 1 100% of asset A 2 55% of asset A and 45% of asset B 55% of asset A and 45% of asset 3 Print Done hat hat Iculate the standard deviation of returne for noch of the three alternatives th X Data table (Click on the icon here in order to copy its contents of the data table below into a spreadsheet.) Expected Return Year Asset A Asset B Asset C 2021 4% 8% 2% 2022 6% 6% 4% 2023 8% 4% 6% 2024 10% 2% 8% D Icu hat hat Print Done nd? You have been given the following return data, on three assets A, B, and C-over the period 2021-2024. Using these assets, you have isolated three investment alternatives: a. Calculate the average portfolio return for each of the three alternatives. b. Calculate the standard deviation of returns for each of the three alternatives. c. On the basis of your findings in parts a and b, which of the three investment alternatives would you recommend? Why? a. Calculate the portfolio return over the 4-year period for each of the 3 alternatives. Alternative 1: 7.00% (Round to two decimal places.) Alternative 2: 7.00% (Round to two decimal places.) Alternative 3: 7.00% (Round to two decimal places.) b. Calculate the standard deviation of returns over the 4-year period for each of the 3 alternatives. Alternative 1: 2.582 % (Round to three decimal places.) Alternative 2: 0.258 % (Round to three decimal places.) Alternative 3: 2.582 % (Round to three decimal places.) c. On the basis of your findings in parts a and b, which of the 3 investment alternatives would you recommend? Why? (Select the best choice below.) A. Alternative 2 is the best choice: it is perfectly negatively correlated and has the least risk. OB. Alternative 3 is the best choice: it is perfectly negatively correlated and has the least risk. O C. Alternative 1 has the highest average return; therefore, it is the most attractive alternative. O D. Alternative 3 has positively correlated assets; therefore, it is the least risky