Assume the returns on an asset are normally distributed. Suppose the historical average annual return for the asset was 7.5 percent and the standard deviation was 12.5 percent. What is the probability that your return on this asset will be less than -7.7 percent in a given year? Use the NORMDIST function in Excel® to answer this question. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Probability % What range of returns would you expect to see 95 percent of the time? (Enter your answers for the range from lowest to highest. A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) What range would you expect to see 99 percent of the time? (Enter your answers for the range from lowest to highest. A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) 95% level % to % 99% level % to %

Assume the returns on an asset are normally distributed. Suppose the historical average annual return for the asset was 7.5 percent and the standard deviation was 12.5 percent. What is the probability that your return on this asset will be less than -7.7 percent in a given year? Use the NORMDIST function in Excel® to answer this question. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Probability % What range of returns would you expect to see 95 percent of the time? (Enter your answers for the range from lowest to highest. A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) What range would you expect to see 99 percent of the time? (Enter your answers for the range from lowest to highest. A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) 95% level % to % 99% level % to %

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter10: Statistics

Section: Chapter Questions

Problem 22SGR

See similar textbooks

Related questions

Q: if a test is weighted at 25% and I make a 55 on the test with my current grade being a 82, would is…

Q: Shares originally worth $10.50 fall in a stock market crash to $2.10. Find the percentage decrease.…

A: Solve for percentage decrease

Q: In a recent year, the U.S. government took in $1.37542 trillion from taxpayers. The total amount of…

A: NOTE: Refresh your page if you can't see any equations. . the U.S. government took in $1.37542…

Q: %3D 3. "Evaluate E (-1) nt2

A: Just add by substituting different values on n ranging from 1 to 3.

Q: Complete the following statements. In general, % of the values in a data set lie at or below the…

Q: Imagine that some number, x, is increased by 40%. Then, that same original number, x, is increased…

Q: Calculate the markup and the markup percent on a Cornish pasty if the food cost is $7.21 and the…

Q: increase is what percent of the original number? (This is ge.) t in decimal form with three decimal…

Q: Suppose that an actuary for an insurance company found that the life expectancy of people (living in…

A: Given that, μ=78,σ=5 Let X denote the life expectancy of people Assume that X follows normal…

Q: For women in a recent triathlon, the average finishing time was 5261 seconds with an SD of 807…

A: It is require to find the value of cutoff time for fastest 5% women( Fastest means the smallest time…

Q: tanA= 6.3138

A: NOTE: Refresh your page if you can't see any equations. .

Question

What range of returns would you expect to see 95 percent of the time? (Enter your answers for the range from lowest to highest. A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) What range would you expect to see 99 percent of the time? (Enter your answers for the range from lowest to highest. A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

Assume the returns on an asset are normally distributed. Suppose the historical average
annual return for the asset was 7.5 percent and the standard deviation was 12.5 percent.
What is the probability that your return on this asset will be less than -7.7 percent in a
given year? Use the NORMDIST function in Excel® to answer this question. (Do not
round intermediate calculations and enter your answer as a percent rounded to 2
decimal places, e.g., 32.16.)
Probability
%
What range of returns would you expect to see 95 percent of the time? (Enter your
answers for the range from lowest to highest. A negative answer should be indicated
by a minus sign. Do not round intermediate calculations and enter your answers as a
percent rounded to 2 decimal places, e.g., 32.16.)
What range would you expect to see 99 percent of the time? (Enter your answers for
the range from lowest to highest. A negative answer should be indicated by a minus
sign. Do not round intermediate calculations and enter your answers as a percent
rounded to 2 decimal places, e.g., 32.16.)
95% level
% to
%
99% level
% to
%

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: State the given information.

VIEW

Step 2: Calculate the probability.

VIEW

Step 3: Evaluate the range of returns.

VIEW

Step 4: Compute the range of returns 99 percent of time.

VIEW

Solution

VIEW

Step by step

Solved in 5 steps with 11 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Oliver Queen is able to hit the bull's-eye (center of the target) 85% of the time. If he shoots 25 arrows, what is the probability that he hits the bull's-eye exactly 12 times? Assume each shot is independent of the others. Don't forget to identify the values of n, x, p, and q before computing. If the rate is given to you as a percent, remember to convert to decimal before using as your value for p. Use the binomial probability formula and write your answer as a decimal rounded to four places.
The time until failure of an electronic component has an exponential distribution and it is known that 10% of components have failed by 1000 hours. Find the mean and standard deviation of the time till failure
The distance between major cracks in a highway follows an exponential distribution with a mean of 15 miles. What is the probability that the first major crack occurs between 12 and 15 miles of the start of inspection? Please enter the answer to 3 decimal places.
Calculate Descriptive statistics of logarithmic returns such as Mean, Median, Minimum, Maximum, Standard deviation, Skewness, Kurtosis of AUD, USD, CNY, JPY and EUR. probability plot of USD, CNY, JPY and EUR returns. I have an excel sheet don't know how to upload it along with the question. As it is giving the option to upload images only. However, have emailed to bartebly email.
Round each z-score to the nearest hundredth.A data set has a mean of x = 4079 and a standard deviation of 113. Find the z-score for each of the following. (a) x = 3840(b) x = 4200(c) x = 4300(d) x = 4030
At the current rate of consumption, the current U.S. coal reserves will last approximately 258 years. What kind of statistics has been used here? Descriptive O Inferential
The time intervals between successive barges passing a certain point on a busy waterway have an exponential distribution with mean 8 minutes. find the 90th percentile.
The time to failure of a component in an electronic device has an exponential distribution with a median of 4 hours. Calculate the probability that the component will work for at least 5 hours without failing?
Calculate the mean if -2 standard deviation = 70 and +2 standard deviation = 100. The mean of the data set is
The chloride concentration in the blood (mmol / liter) averages 104 with a standard deviation of 5. If the chloride concentration is measured in 200 patients, what is the probability that the mean of the data is between 103 and 105? Write your answer to 3 decimal places.
The mean annual income of workers who are college graduates greater than 120,000.00 a year.
Energy consumption for single family comes is a mean of 1050kw and standard deviation of 218kw. Find probability it is between 1050 kw and 1250 kw per hour.