2. Use the Excel file Data for Two Stocks to determine the following: a. Create a two-way data table that determines the 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.50 for the possible correlation coefficient values. Vary the proportion invested in Stock A from 0 to 1.00 in increments of 0.20. b. Compute the expected return for each of these portfolio combinations. c. Construct a graph of the expected return and standard deviation for these portfolios based on each correlation value. d. Provide a title on the graph and label the axes of the graph. e. Use EXCELs Text Box feature to explain what this table and graph indicate about the impact of the correlation coefficient on a portfolios risk and expected return?

	A	B
Expected return	12.00%	18.00%
Variance of return	0.49	0.64
Standard deviation of return	70.00%	80.00%
Correlation	0.5
Proportion of A	0.2