A B C D E F G H | J 1 Date HSI 0008.HK 0009.HK IBM T GE RF 2 June 30, 2019 20.00 4.11 0.22 126.30 29.95 10.41 0.18% 3 December 31, 2019 24.00 4.29 0.11 125.68 35.94 11.09 0.14% 4 June 30, 2020 22.00 4.16 0.07 115.96 28.67 6.80 0.01% 5 December 31, 2020 55.00 4.65 0.06 124.22 28.26 10.78 0.01% 6 7 a- Calculate the arithmetic average return and the standard deviation of return for the Hang Seng Index. b-Calculate the arithmetic average return and the standard deviation of return for each of the 3 Hong Kong stocks. You have 3 standard deviation measures. Also report the average of these 3 standard deviation measures. c- Calculate the arithmetic average return and the standard deviation of return for portfolio HK. d-Calculate the Sharpe measure of the Hang Seng Index and the Sharpe measure of portfolio HK. Please provide step by step guidance in excel A B C D E F G H | J 1 Date HSI 0008.HK 0009.HK IBM T GE RF 2 June 30, 2019 20.00 4.11 0.22 126.30 29.95 10.41 0.18% 3 December 31, 2019 24.00 4.29 0.11 125.68 35.94 11.09 0.14% 4 June 30, 2020 22.00 4.16 0.07 115.96 28.67 6.80 0.01% 5 December 31, 2020 55.00 4.65 0.06 124.22 28.26 10.78 0.01% 6 7 a- Calculate the arithmetic average return and the standard deviation of return for the Hang Seng Index. b-Calculate the arithmetic average return and the standard deviation of return for each of the 3 Hong Kong stocks. You have 3 standard deviation measures. Also report the average of these 3 standard deviation measures. c- Calculate the arithmetic average return and the standard deviation of return for portfolio HK. d-Calculate the Sharpe measure of the Hang Seng Index and the Sharpe measure of portfolio HK. Please provide step by step guidance in excel