Question
For questions 6 through 10, use the following information to answer the question: Yearly Returns for stocks is normally distributedaround a mean of 9% with
For questions 6 through 10, use the following information to answer the question:
Yearly Returns for stocks is normally distributedaround 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?
Hint: Think of question 6 in terms of lower/upper limits.
(7) (To three decimal places) what is the probability of a stock having a yearly return between 5% and 8%?
For questions 8 & 9, see question "b" from the histogram page of the demo. Note that questions 8 & 9 ask for the relative frequency, and the countif formula only gives you the frequency.
(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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started