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 EXCELs 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.

\begin{tabular}{|c|c|c|} \hline PORTFOLIO WEIGHTS DATA & \\ \hline & & \\ \hline & & \\ \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}