CAN YOU PLEASE SHOW ME HOW TO USE EXCEL TO FIND THE STANDARD DEV. FOR ALTERNATIVE 2 AND 3.

You have been given the following return data on three assets-F, G, and H-over the period 2018-2021. Using these assets, you have isolated three investment alternatives: a. Calculate the portfolio return 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. 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: 16.5 % (Round to two decimal places.) Alternative 2: 15.40 % (Round to two decimal places.) Alternative 3: 15.40 % (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 : 1 .291 % (Round to three decima Alternative 2: 10% (Round to three decimal pla Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Year 2018 2019 2020 2021 Expected Return Asset F Asset G Asset H 16% 15% 14% 13% 15% 16% 17% 18% 13% 14% 15% 16% Print Done copy its contents into a spreadsheet.) Alternative Investment 100% of asset F 45% of asset F and 55% of asset G 45% of asset F and 55% of asset H Pint Done