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 14.00

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	14.00	%	21.00	%
0.4	8.00		5.00
0.3	20.00		11.00

Calculate the expected rate of return for the market. Do not round intermediate calculations. Round your answer to two decimal places = 13.4%

Calculate the expected rate of return for Stock J. Do not round intermediate calculations. Round your answer to two decimal places. = 11.6%

Calculate the standard deviation for the market. Do not round intermediate calculations. Round your answer to two decimal places.

Calculate the standard deviation for Stock J. Do not round intermediate calculations. Round your answer to two decimal places.

I was able to figure out the expected rate of return ... but not really confident on how to find the standard deviation for the market and Stock J. Please help me understand :) Thanks!

Excel Online Structured Activity: Expected Returns: Discrete Distribution The market and Stock

D E F B Expected Returns: Discrete Distribution 5 6 7 8 Probability Distributions: Probability 0.3 14.00% 0.4 8.00% 0.3 20.00% 21.00% 5.00% 11.00% 9 10 Expected return IM 13.40% Formulas #N/A 11.60% #N/A Standard deviation =A5*(B5-B10^2)+A6(B6-B10 #N/A #N/A 12 13

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Excel Online Structured Activity: Expected Returns: Discrete Distribution The market and Stock J have the following probability distributions: Probability rM rJ 0.3 16.00 % 18.00 % 0.4 8.00 5.00 0.3...

Excel Online Structured Activity: Expected Returns: Discrete Distribution The market and Stock J have the following probability distributions: Probability j 0.3 14.00 % 21.00 % 0.4 8.00 3.00 0.3...

please answer correctly, will rate b. What is the beta of Fund P? Do not round intermediate calculations. Round your answer to two decimal places. c. What is the required return of Fund P? Do not...

Video Excel Online Structured Activity: Expected Returns: Discrete Distribution The market and Stock J have the following probability distributions: Probability 0.3 0.4 0.3 14.00 % 21.00 % 9.00 5.00...

Excel Online Structured Activity: Expected Returns: Discrete Distribution The market and Stock I have the following probability distributions: Probability ty 0.3 12.00% 20.00% 0.4 9.00 3.00 0.3 20.00...

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 % 21.00 % 0.4 9.00 5.00...

Excel Online Structured Activity: Expected Returns: Discrete Distribution The market and Stock J have the following probability distributions: Probability M r 0.3 15.00 % 22.00 % 0.4 10.00 3.00 0.3...

Excel Online Structured Activity: Expected Returns: Discrete Distribution The market and Stock J have the following probability distributions: Probability rm rj 0.3 16.00% 18.00% 0.4 8.00 5.00 0.3...

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 % 18.00 % 0.4 8.00 4.00...

Excel Online Structured Activity: Expected Returns: Discrete Distribution The market and Stock J have the following probability distributions: Probability rm rj 0.3 16.00% 18.00% 0.4 8.00 5.00 0.3...

The Department of Transportation has found that a proposed highway project is not going to be completed before the end of the summer. They have asked the contractor to prepare cost figures to shorten...

What are the benefits and costs associated with dividends?

16. The number of major hurricanes, which strike the Atlantic coast each year over a period of 50 years, was recorded. (i) If the mean of the distribution is 2.18, find the value of x and of y. (ii)...

A company issues 1,050 shares of its common stock for $33,600 cash. Prepare journal entries to record this event under each of the following separate situations.