Please use excel and show all steps/formulas

The Excel file Portfolio Weights Data contains information about two portfolios. a. Using Matrix Algebra compute the portfolio asset weights for Portfolio C if Portfolio C has 55% of its funds invested in Portfolio A and 45% of its funds invested in Portfolio B. b. Using EXCEL's Data Table Feature, create a one-way data table to compute the Portfolio C asset weights by varying the proportion of funds invested in Portfolio A from 0.10 to 0.90 in increments of 0.10. Portfolio C will consist of the appropriate proportion of funds invested in Portfolio A and the remainder of the funds invested in Portfolio B. A B 1 PORTFOLIO WEIGHTS DATA 2 3 4 Assets Portfolio A Weights 5 Stock 1 18.00% 6 Stock 2 12.00% 7 Stock 3 14.00% 8 Stock 4 10.00% 9 Stock 5 8.00% 10 Stock 6 20.00% 11 Stock 7 5.00% 12 Stock 8 13.00% Portfolio B Weights 21.00% 9.00% 12.00% 16.00% 10.00% 14.00% 9.00% 9.00% 9 The Excel file Portfolio Weights Data contains information about two portfolios. a. Using Matrix Algebra compute the portfolio asset weights for Portfolio C if Portfolio C has 55% of its funds invested in Portfolio A and 45% of its funds invested in Portfolio B. b. Using EXCEL's Data Table Feature, create a one-way data table to compute the Portfolio C asset weights by varying the proportion of funds invested in Portfolio A from 0.10 to 0.90 in increments of 0.10. Portfolio C will consist of the appropriate proportion of funds invested in Portfolio A and the remainder of the funds invested in Portfolio B. A B 1 PORTFOLIO WEIGHTS DATA 2 3 4 Assets Portfolio A Weights 5 Stock 1 18.00% 6 Stock 2 12.00% 7 Stock 3 14.00% 8 Stock 4 10.00% 9 Stock 5 8.00% 10 Stock 6 20.00% 11 Stock 7 5.00% 12 Stock 8 13.00% Portfolio B Weights 21.00% 9.00% 12.00% 16.00% 10.00% 14.00% 9.00% 9.00% 9