Hi, I need help on Part 4, 5, 6, and 7. Excel should help with these! Thanks!!

Intro The following table shows realized rates of return for two stocks. 1 Year Stock A Stock B 2 1 5% 15% 3 2 -14% -14% 4 3 -6% -7% 5 4 5% 28% 6 5 14% 8% 7 CO 13% 7% Part 1 | Attempt 1/10 for 10 pts. What is the arithmetic average return for stock B? 6.167% Correct . B 1 Year Stock A Stock B Formula 2 1 5% 15% 3 2 -14% -14% 4 3 -6% -7% 5 4 5% 28% 6 5 14% 8% 7 6 13% 7% 8 Average | 0.02833 0.0617 | =AVERAGE(C2:07) Part 4 | Attempt 1/10 for 10 pts. What is the mean return of a portfolio with 20% invested in stock A and the remainder in stock B (assuming annual rebalancing)? 3+ decimals Submit Part 5 | Attempt 1/10 for 10 pts. What is the standard deviation of a portfolio with 20% invested in stock A and the remainder in stock B (assuming annual rebalancing)? 3+ decimals Submit Part 6 | Attempt 1/10 for 10 pts. What is the mean return of a portfolio with 60% invested in stock A and the remainder in stock B (assuming annual rebalancing)? 4+ decimals Submit Part 7 Attempt 1/10 for 10 pts. What is the standard deviation of a portfolio with 60% invested in stock A and the remainder in stock B (assuming annual rebalancing)? 3+ decimals Submit