Homework SoursePlease include Excel formulas A Probability of a Given Z Sco
**Please include Excel formula\'s**
A. Probability of a Given Z Score
| **Please include Excel formula\'s** A. Probability of a Given Z Score | ||
| Z Score | Probability of Obtaining A Smaller Z Score | Probability of Obtaining A Larger Z Score |
| 5.27 | ||
| 2.675 | ||
| 1 | ||
| -1 | ||
| -2.675 | ||
| -5.27 | ||
| Instructions: Use the NORMSDIST Function to provide the missing data in the above table, making sure that the appropriate formula is shown in each cell | ||
| B. Z Score with a Given Probabiliy | ||
| Instructions: Use the NORMSINV Function to provide the missing data in the above table, making sure that the appropriate formula is shown in each cell |
Solution
Z Score
Probability of Obtaining A Smaller Z Score
Probability of Obtaining A Larger Z Score
5.27
NORM.DIST(5.27,0,1,TRUE)
0.9999999318
1-NORM.DIST(5.27,0,1,TRUE)
0.0000000682
2.675
NORM.DIST(2.675,0,1,TRUE)
0.9962635375
1-NORM.DIST(2.675,0,1,TRUE)
0.0037364625
1
NORM.DIST(1,0,1,TRUE)
0.8413447461
1-NORM.DIST(1,0,1,TRUE)
0.1586552539
-1
NORM.DIST(-1,0,1,TRUE)
0.1586552539
1-NORM.DIST(-1,0,1,TRUE)
0.8413447461
-2.675
NORM.DIST(-2.675,0,1,TRUE)
0.0037364625
1-NORM.DIST(-2.675,0,1,TRUE)
0.9962635375
-5.27
NORM.DIST(-5.27,0,1,TRUE)
0.0000000682
1-NORM.DIST(-5.27,0,1,TRUE)
0.9999999318
| Z Score | Probability of Obtaining A Smaller Z Score | Probability of Obtaining A Larger Z Score | ||
| 5.27 | NORM.DIST(5.27,0,1,TRUE) | 0.9999999318 | 1-NORM.DIST(5.27,0,1,TRUE) | 0.0000000682 |
| 2.675 | NORM.DIST(2.675,0,1,TRUE) | 0.9962635375 | 1-NORM.DIST(2.675,0,1,TRUE) | 0.0037364625 |
| 1 | NORM.DIST(1,0,1,TRUE) | 0.8413447461 | 1-NORM.DIST(1,0,1,TRUE) | 0.1586552539 |
| -1 | NORM.DIST(-1,0,1,TRUE) | 0.1586552539 | 1-NORM.DIST(-1,0,1,TRUE) | 0.8413447461 |
| -2.675 | NORM.DIST(-2.675,0,1,TRUE) | 0.0037364625 | 1-NORM.DIST(-2.675,0,1,TRUE) | 0.9962635375 |
| -5.27 | NORM.DIST(-5.27,0,1,TRUE) | 0.0000000682 | 1-NORM.DIST(-5.27,0,1,TRUE) | 0.9999999318 |
