**Please include Excel formula\'s** A. Probability of a Given Z Score **Please i
ID: 3388739 • Letter: #
Question
**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 cellExplanation / Answer
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
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.