***PLEASE SOLVE USING EXCEL AND SHOW THE COMMANDS USED***

Consider the following two funds and their estimated returns under different states of the economy:

State of economy	Probability	Estimated Return (Fund A)	Estimated Return (Fund B)
Great	30%	10%	25%
Average	30%	15%	11%
Poor	40%	20%	15%

If you invest $2,000 in Fund A and $8,000 in Fund B, Calculate the following:

1. Portfolios Expected Return

2. Portfolios Standard Deviation