$1.(10$ Points$)$ Use the Excel file Data for Two Stocks to determine the following:

a$.$ Using EXCEL$$s Data Table Feature, create a one$-$way data table that determines the different means and standard deviations for portfolios consisting of combinations of Stock A and Stock B by varying the correlation coefficient value between Stock A and Stock B through the full range of possible correlation coefficient values.$$ Use increments of $0\mathrm{.}20$ for the possible correlation coefficient values.

b$.$ Graph the correlation coefficients, the means, and the standard deviations of the portfolios from the one$-$way data table.$$ Be sure to include a title for the graph and label the axes.

c$.$ Use Excel$$s Text Box Feature to explain how the portfolio means are affected by changing the correlation coefficient values.

d$.$ Use Excel$$s Text Box Feature to explain how the portfolio standard deviations are affected by changing the correlation coefficient values. $\backslash$begin$\{$tabular$\}\{$c$|$l$|$c$|$c$|$c$|\}$

$\backslash$hline & $\backslash$multicolumn$\{1\}\{|$c$|\}\{$ A $\}$ & B & C & D $\backslash \backslash$

$\backslash$hline $1$ & Data for Two Stocks & & & $\backslash \backslash$

$\backslash$hline $2$ & & & & $\backslash \backslash$

$\backslash$hline $3$ & & & & $\backslash \backslash$

$\backslash$hline $4$ & & A & B & $\backslash \backslash$

$\backslash$hline $5$ & Expected return & $\backslash (5\mathrm{.}00\backslash \%\backslash )$ & $\backslash (10\mathrm{.}00\backslash \%\backslash )$ & $\backslash \backslash$

$\backslash$hline $6$ & Variance of return & $0\mathrm{.}69$ & $0\mathrm{.}89$ & $\backslash \backslash$

$\backslash$hline $7$ & Standard deviation of return & $\backslash (83\mathrm{.}07\backslash \%\backslash )$ & $\backslash (94\mathrm{.}34\backslash \%\backslash )$ & $\backslash \backslash$

$\backslash$hline $8$ & Correlation & $0\mathrm{.}75$ & & $\backslash \backslash$

$\backslash$hline $9$ & & & & $\backslash \backslash$

$\backslash$hline $10$ & Proportion of A & $0\mathrm{.}36$ & & $\backslash \backslash$

$\backslash$hline $11$ & & & & $\backslash \backslash$

$\backslash$cline $\{4-5\}$ & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$