please show work in excel

8. 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 44% of its funds invested in Portfolio A and 56% 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 to 1 in increments of 0.20 . Portfolio C will consist of the appropriate proportion of funds invested in Portfolio A and the remainder of the funds invested in Portfolio B. PORTFOUO WEIGHTS DATA \begin{tabular}{l|c|c|} \hline Assets & Portfolio A Weights & Portfolio B Weights \\ \hline Stock 1 & 21.00% & 15.00% \\ \hline Stock 2 & 15.00% & 21.00% \\ \hline Stock 3 & 28.00% & 16.00% \\ \hline Stock 4 & 14.00% & 20.00% \\ \hline Stock 5 & 10.00% & 17.00% \\ \hline Stock 6 & 12.00% & 11.00% \\ \hline \end{tabular}