Question

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!

Homework Answers

Answer #1

EXCEL FORMULA:

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: 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!
.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%
Question 1 a. Calculate the expected return on stock of Gamma Inc.: State of the economy...
Question 1 a. Calculate the expected return on stock of Gamma Inc.: State of the economy Probability of the states Percentage returns Economic recession 28% -7.4% Steady economic growth     35% 2.2% Boom Please calculate it 14.6% Round the answers to two decimal places in percentage form. b. Calculate the expected standard deviation on stock: State of the economy Probability of the states Percentage returns Economic recession              18% 2% Steady economic growth 22% 8% Boom Please calculate it 14%
Based on the following information, calculate the expected return and standard deviation and variance for two...
Based on the following information, calculate the expected return and standard deviation and variance for two stocks: This is what i have so far and i am stuck if someone can check my work so far and help me fill in the rest thanks 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 .34 Stock A Probability Return Product Return Deviation Squared Deviation...
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%
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%