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 $11.$ The required answers are in rows $18$ through $23.$

Consider the following information.$$Your portfolio is invested $30$ percent each in A and C$,$ and $40$ percent in B$.$ What$$is the expected return of the portfolio?$$What is the variance of this portfolio? The standard deviation?

Input area:

State Probability Stock A Stock B Stock C $$

Boom $0\mathrm{.}150\mathrm{.}350\mathrm{.}400\mathrm{.}28$

Good $0\mathrm{.}450\mathrm{.}160\mathrm{.}170\mathrm{.}09$

Poor $0\mathrm{.}30(0\mathrm{.}01)(0\mathrm{.}03)0\mathrm{.}01$

Bust $0\mathrm{.}10(0\mathrm{.}10)(0\mathrm{.}12)(0\mathrm{.}09)$

weights $0\mathrm{.}300\mathrm{.}400\mathrm{.}30$

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

Output area:

State Probability Portfolio return Product Return deviation Squared deviation Product $$

Boom $0\mathrm{.}15$

Good $0\mathrm{.}45$

Poor $0\mathrm{.}30$

Bust $0\mathrm{.}10$

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

Standard deviation $$

Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work.

Nothing in this area will be graded, but it will be submitted with your assignment.