What is the probability that the return on the index in Example 5.8 will be below 15%?
Question:
What is the probability that the return on the index in Example 5.8 will be below −15%?
Transcribed Image Text:
Example 5.8 Normal Distribution Function in Excel Suppose the monthly rate of return on the S&P 500 is approximately normally distributed with a mean of 1% and standard deviation of 6%. What is the probability that the return on the index in any month will be negative? We can use Excel's built-in functions to quickly answer this question. The probability of observing an outcome less than some cutoff according to the normal distribution function is given as NORM.DIST(cutoff, mean, standard deviation, TRUE). In this case, we want to know the probability of an outcome below zero when the mean is 1% and the standard deviation is 6%, so we compute NORM.DIST(0, 1, 6, TRUE) = .4338. We could also use Excel's built-in standard normal function, NORM.S.DIST, which uses a mean of 0 and a standard deviation of 1, and ask for the probability of an outcome 1/6 of a standard deviation below the mean: NORM.S.DIST(-1/6, TRUE) = .4338.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 100% (1 review)
The probability of a more extreme bad month with re...View the full answer
Answered By
Aysha Ali
my name is ayesha ali. i have done my matriculation in science topics with a+ . then i got admission in the field of computer science and technology in punjab college, lahore. i have passed my final examination of college with a+ also. after that, i got admission in the biggest university of pakistan which is university of the punjab. i am studying business and information technology in my university. i always stand first in my class. i am very brilliant client. my experts always appreciate my work. my projects are very popular in my university because i always complete my work with extreme devotion. i have a great knowledge about all major science topics. science topics always remain my favorite topics. i am also a home expert. i teach many clients at my home ranging from pre-school level to university level. my clients always show excellent result. i am expert in writing essays, reports, speeches, researches and all type of projects. i also have a vast knowledge about business, marketing, cost accounting and finance. i am also expert in making presentations on powerpoint and microsoft word. if you need any sort of help in any topic, please dont hesitate to consult with me. i will provide you the best work at a very reasonable price. i am quality oriented and i have 5 year experience in the following field.
matriculation in science topics; inter in computer science; bachelors in business and information technology
_embed src=http://www.clocklink.com/clocks/0018-orange.swf?timezone=usa_albany& width=200 height=200 wmode=transparent type=application/x-shockwave-flash_
4.40+
11+ Reviews
14+ Question Solved
Related Book For
ISE Investments
ISBN: 9781260571158
12th International Edition
Authors: Zvi Bodie, Alex Kane, Alan Marcus
Question Posted:
Students also viewed these Business questions
-
Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...
-
Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...
-
re Regular Languages and Finite Automata (a) Let L be the set of all strings over the alphabet {a, b} that end in a and do not contain the substring bb. Describe a deterministic finite automaton...
-
Determine the force in members HI, FI, and EF of the truss, and state if the members are in tension orcompression. 3 m D. -2 m--2 m2 m--2 m--2 m--2 m- 4 kN 5 KN 6 kN 8 kN
-
(a) Find the kinetic energy (in eV) of an electron whose de Broglie wavelength is equal to 0.5 = 0.05 nm, a typical atomic size. (b) If the wavelength of the electron is reduced to 10 15 m, a...
-
The drag on a sphere moving in a fluid is known to be a function of the sphere diameter, the velocity, and the fluid viscosity and density. Laboratory tests on a 4-in.-diameter sphere were performed...
-
If the product is right and the sales presentation is right, there is no need to close the sale. Discuss.
-
Gonzalez Company produces one product, Olpe. Because of wide fluctuations in demand for Olpe, the Assembly Department experiences significant variations in monthly production levels. The annual...
-
2. (30 points) Here is an SML mergesort program: fun merge ([], ys) = ys | merge (xs, []) = xs merge (x::xs, y::ys) = if xy then x::merge (xs, y::ys) else y::merge (x::xs, ys) = ([], []) fun split []...
-
The Narnian stock market had a rate of return of 45% last year, but the inflation rate was 30%. What was the real rate of return to Narnian investors?
-
Using the annual returns for years 35 in Spreadsheet 5.2: a. Compute the arithmetic average return. b. Compute the geometric average return. c. Compute the standard deviation of returns. d. Compute...
-
*Visit a Facebook fan page, like Honda, for example. What types of information about the product can you find on the site? What types of topics are discussed on the site?
-
14. Under what condition do different asset classes typically become more correlated? 15. Why is it NOT always best to assess correlation between asset classes with the highest frequency of data?
-
Identify the inherent and control risks related to the financial instruments accounts for McNeil Co. b. Identify at least two audit procedures the auditor would perform to test the existence...
-
Laural Company paid USD 840,000 cash for real property consisting of a tract of land and a building. The company intended to remodel and use the old building. To allocate the cost of the property...
-
Multichained Stores Ltd., Delhi has its branches at Lucknow and Madras. It charges goods to its branches at cost plus 25%. Following information is available of the transactions of the Lucknow branch...
-
A company manufacturing two products furnishes the following data for a year. Product Annual Output [Units] Total machine hours Total number of purchase orders Total number of set ups A 5,000 20,000...
-
Consider the budget for any business. Requirement 1. List the three key benefits companies get from preparing the budget.
-
Describe a group you belong or have belonged discuss the stages of group development and suggest how to improve the group effectiveness by using the group development model.
-
What are the three principal forms of business organization? What are the advantages and disadvantages of each?
-
What are the three primary determinants of a firms cash flow?
-
What are financial intermediaries, and what economic functions do they perform?
-
A 7.0 C charge is moving to the right at a speed of 49m/s. A B-field is then induced with a strength of 3.7 T directed out the page. What is the magnitude of the force exerted on the wire? What...
-
Please help with at least three or more sources for a three to four page paper. Topic is soil compaction and stabilization. This is for soil mechanics for construction class.
-
In-Class Exercise Altitude Temperature | Pressure H, ft T, F P, 20/14= -5000 74.84 1755 57.00 14.70 Troposphere Enter the data from this table. 5000 4617 12.23 10000 23.30 10.11 15000 6.55 8.30...
Study smarter with the SolutionInn App