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 72% of its funds invested in Portfolio A and 28% 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.10. Portfolio C will consist of the appropriate proportion of invested in Portfolio A and the remainder of the funds invested in Portfolio B. PORTFOLIO WEIGHTS DATA \begin{tabular}{|c|c|c|} \hline Assets & Portfolio A Weights & Portfolio B Weights \\ \hline Stock 1 & 18.00% & 20.00% \\ \hline Stock 2 & 14.00% & 11.00% \\ \hline Stock 3 & 16.00% & 10.00% \\ \hline Stock 4 & 10.00% & 15.00% \\ \hline Stock 5 & 12.00% & 14.00% \\ \hline Stock 6 & 16.00% & 18.00% \\ \hline Stock 7 & 14.00% & 12.00% \\ \hline \end{tabular} 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 72% of its funds invested in Portfolio A and 28% 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.10. Portfolio C will consist of the appropriate proportion of invested in Portfolio A and the remainder of the funds invested in Portfolio B. PORTFOLIO WEIGHTS DATA \begin{tabular}{|c|c|c|} \hline Assets & Portfolio A Weights & Portfolio B Weights \\ \hline Stock 1 & 18.00% & 20.00% \\ \hline Stock 2 & 14.00% & 11.00% \\ \hline Stock 3 & 16.00% & 10.00% \\ \hline Stock 4 & 10.00% & 15.00% \\ \hline Stock 5 & 12.00% & 14.00% \\ \hline Stock 6 & 16.00% & 18.00% \\ \hline Stock 7 & 14.00% & 12.00% \\ \hline \end{tabular}