Question

Calculate mean and standard deviation for the following: Economic state.        Return.        Probability Recession.           &

Calculate mean and standard deviation for the following:

Economic state.        Return.        Probability

Recession.                   -20%              25%

Normal.                          15%              50%

Boom.                            30%               25%

Please use Excel and show formulas used. Thank you!

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Calculate mean and standard deviation for the following asset. Economic State                           Return    &
Calculate mean and standard deviation for the following asset. Economic State                           Return                        Probability Recession                                      -8%                             27% Normal                                          15%                             45% Boom                                            25%                             28% PLEASE SHOW WORK AND FORMULAS- EXCEL THANK YOU!
.Calculate mean and standard deviation for the following asset. Please show all work. Economic State                          ...
.Calculate mean and standard deviation for the following asset. Please show all work. Economic State                           Return                        Probability Recession                                      -20%                           20% Normal                                          18%                             50% Boom                                            35%                             30%
Calculate mean and standard deviation for the following asset. Economic State                           Return    &
Calculate mean and standard deviation for the following asset. Economic State                           Return                        Probability Recession                                      -10%                           30% Normal                                          10%                             40% Boom                                            30%                             30%
Calculate the expected return and standard deviation for a portfolio consisting of 30% in Ant Ltd...
Calculate the expected return and standard deviation for a portfolio consisting of 30% in Ant Ltd and the remainder in Bell Ltd. Please explain your calculations thoroughly, showing all the formulas and calculations themselves. Please do not use excel. State of economy Probability of state Rate of return Ant Ltd Rate of return Bell Ltd Recession 15% 2% -30% Normal 55% 10% 18% Boom ??? 15% 31%
Based on the following information, calculate the expected return and standard deviation for two stocks: State...
Based on the following information, calculate the expected return and standard deviation for two stocks: State of the Economy Probability Rate of Return Stock A Rate of Return Stock B Recession .25 .05 -.19 Normal .50 .06 .14 Boom .25 .10
Calculate the standard deviation of returns of Stock Q, given the following information. State Stock return...
Calculate the standard deviation of returns of Stock Q, given the following information. State Stock return Probability of state Recession –5% 25% Normal 10% 50% Boom 25% 25% Select one: a. 10.61% b. 9.53% c. 8.96% d. 7.33% e. 6.30%
Calculate the standard deviation of returns for Stock A and Stock B. State of Economy: (Recession...
Calculate the standard deviation of returns for Stock A and Stock B. State of Economy: (Recession 20%) (Normal 55%) (Boom 25%) Stock A Return: (Recession 5%) (Normal 8%) (Boom 13%) Stock B Return: (Recession -17%) (Normal 12%) (Boom 29%) Possible Answers: a. 23.26% b. 15.43% c. 14.94% d. 4.04% e. 2.76%
Consider the following information:    Rate of Return if State Occurs   State of Economy Probability of...
Consider the following information:    Rate of Return if State Occurs   State of Economy Probability of State of Economy Stock A Stock B   Recession .10 .04 –.20   Normal .60 .09 .13   Boom .30 .15 .36    Calculate the expected return for Stock A.    Calculate the expected return for Stock B.    Calculate the standard deviation for Stock A.    Calculate the standard deviation for Stock B.
Calculate the expected standard deviation on stock: State of the economy Probability of the states Percentage...
Calculate the expected standard deviation on stock: State of the economy Probability of the states Percentage returns Economic recession 23% -5% Steady economic growth 25% 10% Boom Please calculate it 14%
Consider the following information:    Rate of Return if State Occurs   State of Economy Probability of...
Consider the following information:    Rate of Return if State Occurs   State of Economy Probability of State of Economy Stock A Stock B   Recession .10 .04 –.21   Normal .50 .09 .15   Boom .40 .15 .35    Calculate the expected return for Stock A. Calculate the expected return for Stock B. Calculate the standard deviation for Stock A.    Calculate the standard deviation for Stock B.