Use the rate$-$of$-$return data for the stock and bond funds presented inI Spreadsheet $6\mathrm{.}1,$ but now assume that the probability of each scenario is as follows: severe recession: $0\mathrm{.}10$; mild recession: $0\mathrm{.}20$; normal growth: $0\mathrm{.}35$; boom: $0\mathrm{.}35.(9$ LO $6-2)$a$.$ Would you expect the variance of the stock fund to be more than, less than, or equal to the values computed in L Spreadsheet $6\mathrm{.}2?$ Why?b$.$ Calculate the new value of variance for the stock fund using a format similar to l Spreadsheet $6\mathrm{.}2.$ Confirm your intuition from part $($a$).$c$.$ Calculate the new value of the covariance between the stock and bond funds using a format similar to Spreadsheet $6\mathrm{.}4.$ Explain intuitively why the absolute value of the covariance has changed.