Please answer these questions through excel if calculations are neccesary in the question! Show all formulas. IF YOU ARE NOT GOING TO USE EXCEL, DO NOT ANSWER

the market variance is om error term is (c) 31. (d) 9. (e) 111. 26. (0.3 point) A portfolio consists of Securities A, B, and C in the respective proportions of 0.3, 0.2, 0.5 If the securities' respective betas are 0.8, 1.4, 1.1, the beta for the portfolio is (a) 0.98. (b) 1.12. (c) 1.07. (d) 1.23. to) 1.20 27. (0.5 point) A portfolio consists of Securities A and B in the proportions of 0.7 and 0.3. Security A has a random error standard deviation of 74; Security B at 111. portfolio beta is 1.2, and the market standard deviation is 101. The total portfolio variance is (a) 158. (b) 204. (c) 265. (d) 179. (e) 137. 28. (0.2 point) When using the market model for portfolio development, the analyst assumes that the correlation between each security's random error is (a) 0.5. (b) 0.0. (c) -0.5. (d) -1.0. 1.0