Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please formulas in excel Based on the following information, calculate the expected return and standard deviation for two stocks: State of the Economy Recession Normal
Please formulas in excel
Based on the following information, calculate the expected return and standard deviation for two stocks: State of the Economy Recession Normal Boom Probability Rate of Return Stock A .25 .05 .06 Rate of Return Stock B -.19 .14 .34 .50 .25 .10 Fill in the value in the spreadsheet. Input area: Stock A 0.05 State Recession Normal Boom Probability 0.25 0.50 0.25 Stock B (0.19) 0.14 0.34 0.06 0.10 Output area: Return Deviation Squared Deviation Probability Return Product Product Stock A Recession Normal Boom 0.0000 Variance = E(R) = 0 Standard Deviation C .00% Return Deviation Squared Deviation Probability Return Product Product Stock B Recession Normal Boom E(R) = 0.0000 Variance = Standard Deviation 0.00%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started