a$.$ Using Matrix Algebra compute the portfolio asset weights for Portfolio C if Portfolio C has $75\%$ of its funds invested in Portfolio A and $25\%$ 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\mathrm{.}5$ in increments of $0\mathrm{.}25.$ Portfolio C will consist of the appropriate proportion of funds invested in Portfolio A and the remainder of the funds invested in Portfolio B$.($please if you can answer B with excel work only$)$Assets Portfolio A Weights Portfolio B Weights

Stock $123\mathrm{.}00\%17\mathrm{.}00\%$

Stock $226\mathrm{.}00\%23\mathrm{.}00\%$

Stock $321\mathrm{.}00\%25\mathrm{.}00\%$

Stock $412\mathrm{.}00\%18\mathrm{.}00\%$

Stock $518\mathrm{.}00\%17\mathrm{.}00\%$