Hi I need help on part 5, 6 and 7 please! Excel will help with this! Thanks!

Intro The following table shows realized rates of return for two stocks. A B 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 6 13% 7% Part 1 Attempt 1/10 for 10 pts. What is the arithmetic average return for stock B? 6.167% Correct A B D 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 2 | Attempt 1/10 for 10 pts. What is the variance for stock B? 0.0228 Correct B D 9 Variance 0.01198 0.02278 =VAR.S(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)? .055026 Correct A B D Portfolio Portfolio Portfolio 12 weight mean standard on A return deviation 13 0.2 0.055 =A13*B$8+ (1- A13)*C$8 Part 5 Attempt 3/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 2/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 - Attempt 2/10 for 10 pts. Part 7 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