Accessibility tab summary: Students please use the information below to complete the question completing the required cells. Given information for this question is presented in rows $6$ through $9.$ The required answers are in rows $16$ through $26.$

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