Question: Excel Online Structured Activity: Expected Returns: Discrete Distribution The market and Stock J have the following probability distributions: Probability r M r J 0.3 15.00
Excel Online Structured Activity: Expected Returns: Discrete Distribution
The market and Stock J have the following probability distributions:
| Probability | rM | rJ | ||
| 0.3 | 15.00 | % | 21.00 | % |
| 0.4 | 9.00 | 5.00 | ||
| 0.3 | 17.00 | 11.00 | ||
The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
Open spreadsheet
- Calculate the expected rate of return for the market. Do not round intermediate calculations. Round your answer to two decimal places. fill in the blank 2 % Calculate the expected rate of return for Stock J. Do not round intermediate calculations. Round your answer to two decimal places. fill in the blank 3 %
- Calculate the standard deviation for the market. Do not round intermediate calculations. Round your answer to two decimal places. fill in the blank 4 % Calculate the standard deviation for Stock J. Do not round intermediate calculations. Round your answer to two decimal places. fill in the blank 5 %
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help