Based on the following$$information$,$ calculate the expected return and standard deviation for Stock A and$$Stock B$.$

Input area:

State Probability Stock A Stock B $$

Recession $0\mathrm{.}150\mathrm{.}04(0\mathrm{.}17)$

Normal $0\mathrm{.}550\mathrm{.}090\mathrm{.}12$

Boom $0\mathrm{.}300\mathrm{.}170\mathrm{.}27$

$($Use cells A$6$ to D$9$ from the given information to complete this question.$)$

Output area:

Stock A Probability Return Product Return deviation Squared deviation Product $$

Recession $$

Normal $$

Boom $$

$$ E$($R$)$ Variance $$

Standard deviation $$

Stock B Probability Return Product Return deviation Squared deviation Product $$

Recession $$

Normal $$

Boom $$

$$ E$($R$)$ Variance $$

Standard Deviation