NOTE: USE CELL REFERENCES FROM C45 THROUGH C49 TO ANSWER PROBLEMS 2 THROUGH 8!
2.For a mean of 7% and a standard deviation of 8%, there would be an approximate 68% chance of a return between what lower number and what higher number?
3. For a mean of 7% and a standard deviation of 8%, there would be an approximate 95% chance of a return between what lower number and what higher number?
4. For a mean of 7% and a standard deviation of 8%, there would be an approximate 99% chance of a return between what lower number and what higher number?
5. For a mean of 7% and a standard deviation of 8%, chance of return between 7% and 15%?
6. For a mean of 7% and a standard deviation of 8%, chance of return between 15% and 23%?
7. For a mean of 7% and a standard deviation of 8%, chance of a return between 23% and 31%?
8. For a mean of 7% and a standard deviation of 8%, chance of a return above 31%?
NOTE: The probabilities in this problem are approximate.
The corresponding precise probabilities are 68.26%, 95.44% and 99.74%.
APPROXIMATE AREAS UNDER THE CURVE ARE AS FOLLOWS
TOTAL AREA 100%
AREA BEWEEN +1 AND -1 σ 68%
AREA BEWEEN +2 AND -2 σ 95%
AREA BEWEEN +3 AND -3 σ 99%
MEAN 7.00%
σ 8.00%
PROBLEM 2 LOWER NUMBER -1.00%
PROBLEM 2 HIGHER NUMBER 15.00%
PROBLEM 3 LOWER NUMBER -9.00%
PROBLEM 3 HIGHER NUMBER 23.00%
PROBLEM 4 LOWER NUMBER -17.00%
PROBLEM 4 HIGHER NUMBER 31.00%
PROBLEM 5 CHANCE OF RETURN BETWEEN 7% AND 15%
PROBLEM 6 CHANCE OF RETURN BETWEEN 15% AND 23%
PROBLEM 7 CHANCE OF RETURN BETWEEN 23% AND 31%
PROBLEM 8 CHANCE OF RETURN ABOVE 31%