Good morning, please see the question below regarding standard deviation, average portfolio return and ratio...Please show calculations, in excel, if applicable

Problem 1 Table below shows the historical returns for Companies A, B and C - - um um um um 1. If one investor has a portfolio consisting of 50% Company A and 50% Company B, what are the average portfolio return and standard deviation? What is Sharpe ratio ifthe risk- free rate is 3.8%? 2. If another investor has a portfolio consisting of 1/3 Company A, 1/3 Company B and 1/3 Company C, what are the average portfolio return and standard deviation? What is Sharpe ratio if the risk-free rate is 3.8%