Matt Peters wishes to evaluate the risk and return behaviors associated with various combinations of assets V and W under three assumed degrees ofcorrelation: perfectlypositive, uncorrelated, and perfectly negative. The expected return and risk values calculated for each of the assets are shown in the followingtable.

See Below

a.If the returns of assets V and W are perfectly positively correlated(correlation coefficient= +1), describe the range of(1) expected return and(2) risk associated with all possible portfolio combinations.

b.If the returns of assets V and W are uncorrelated(correlation coefficient= 0), describe the approximate range of(1) expected return and(2) risk associated with all possible portfolio combinations.

c.If the returns of assets V and W are perfectly negatively correlated(correlation coefficient =minus

1), describe the range of(1) expected return and(2) risk associated with all possible portfolio combinations.

Please include excel (if applicable) so I can understand the functions within the program.