show work in excel

Variance and standard deviation (expected). Hull Consultants, a famous think tank in the Midwest, has provided probability estimates for the four potential economic states for the coming year in the following table: The probability of a boom economy is 10%, the probability of a stable growth economy is 18%, the probability of a stagnant economy is 48%, and the probability of a recession is 26%. Calculate the variance and the standard deviation of the three investments: stock, corporate bond, and goverment bond. If the estimates for both the probabilities of the economy and the returns in each state of the economy are correct, which investment would you choose, considering both risk and return? Hint. Make sure to round all intermediate calculations to at least seven (7) decimal places. The input instructions, phrases in parenthesis after each answer box What is the variance of the stock Investment? Ll% (Round to six decimal places) Investment Stock Corporate bond Government bond Boom 30% 10% 9% Forecasted Returns for Each Economy Stable Growth Stagnant 14% 5% 8% 6% 7% 5% Recession 14% 3% 2%