# Yearly Returns for stocks is normally distributed  around a mean of 9% with a standard deviation of...

###### Question:

Yearly Returns for stocks is normally distributed  around a mean of 9% with a standard deviation of 12%. A random sample of 2000 stock returns is shown on the Stock Returns worksheet.

(6) (To three decimal places) what is the probability of a stock having a negative yearly return?

(7)(Tothree decimal places) what is the probability of a stock having a yearly return between 5% and 8%?

(8) (To three decimal places) What is the relative frequency of stocks, from the random sample on the Stock Returns worksheet, that had a negative yearly return?

(9) (To three decimal places) What is the relative frequency of stocks, from the random sample on the Stock Returns worksheet, that had between 5% and 8% for a yearly return?

(10) (To three decimal places) what yearly return is exceeded 80% of the time?

Can you tell me which excel function to use for each question and how to solve it?

#### Similar Solved Questions

##### Please solve, show work, and give detail explanation 11. The IRR decision rule is unreliable when...
Please solve, show work, and give detail explanation 11. The IRR decision rule is unreliable when comparing mutually exclusive projects. a. True b. False 12. Return on Assets (ROA) is an example of a profitability ratio. a. True b. False 13. For a given time period, the higher the interest rate, the...
##### If a 24.51 g sample of an unknown compound decomposes to produce 14.91 g KCl and...
If a 24.51 g sample of an unknown compound decomposes to produce 14.91 g KCl and 9.60 g O2, what is its empirical formula? [5 marks]...
##### Layout References A A Aay to x Avo Av Mailings Review View Tell me what you...
Layout References A A Aay to x Avo Av Mailings Review View Tell me what you want to do Eva A EE EE av AalbCcDdee Predict the major product of the following reaction. Br2, FeBrz English (United States)...
##### 3. Let n be an integer. Prove that 2 (n4 – 3) if and only if...
3. Let n be an integer. Prove that 2 (n4 – 3) if and only if 4| (n2+3)....
##### What is the main component of PAYG? 30–50 words
What is the main component of PAYG? 30–50 words...
##### A car is initially at rest on a straight road. The graph shows the acceleration of...
A car is initially at rest on a straight road. The graph shows the acceleration of the car along that road as a function of time. What distance does the car cover in the first 9 seconds? 4. 2 -1 -3 0 1 2 34 5 6 7 8 9 10 11 12 13 14 t (s)...
##### 6. (5 pts) To find molecular weight of an unknown compound, 0.112 g of the unknown...
6. (5 pts) To find molecular weight of an unknown compound, 0.112 g of the unknown is dissolved in 40.0 g of water. The resulting solution freezes at -0.049 °C. Find molar mass of the unknown....
##### Two corners of a triangle have angles of  (5 pi )/ 12  and  pi / 6 . If one side of the triangle has a length of 5, what is the longest possible perimeter of the triangle?
Two corners of a triangle have angles of  (5 pi )/ 12  and  pi / 6 . If one side of the triangle has a length of 5, what is the longest possible perimeter of the triangle?...