State of Economy	Probability of State of Economy(Pi)	Rate of Return
		Stock A	Stock B	Stock C	Stock D
Boom	10%	30%	45%	33%	-20%
Good	60%	12%	10%	15%	-5%
Poor	20%	1%	-15%	-5%	15%
Bust	10%	-20%	-30%	-9%	35%
weight		20%	10%	40%	30%
Dollar invested		20000	10000	40000	30000

According to the information given above, answer the following questions:

1. What is the portfolios expected return?
2. What is the variance of the portfolio and standard deviation?
3. If you have to choose only one type of securities (stock A, B, C or D) which one will you choose and why? To answer this question, you need to calculate the expected return for each stock and the standard deviation, and compare their values.
4. What is the expected return and variance of a portfolio invested 25% each in A, B, C and D? Will the resulting portfolio structure bring you a higher expected return?
5. How should you change the shares of securities A, B, C and D in your portfolio in order to minimize risk and maximize expected returns? Explain your answers.

You should describe each step in detail and provide intermediate calculations. The questions has to be solved using excel and formulas.

* Write your answers after each question.

* Be careful when rounding. Leave two decimal places.

these are the only information. i forgot to add the dollar investment before nothing more is left