Returns for the Red Sox and Yankees companies over the last five years are shown below.

Calculate the average return and Standard deviation of each of the firms returns? (Hint: This is a sample, not a complete population; so the sample standard deviation formula should be used.)

Calculate the average return and standard deviation of a portfolio, consisting of 70% Red Sox and 30% Yankees.

Year Red Sox Return Yankees Return. Portfolio return

2022 26.00% 15.00%

2021 20.00%. 20.00%

2020 12.50% -12.50%

2019 12.00% 4.00%

2018 9.00% 9.00%

Answer in excel please!