Answer:
a)
"=NORM.DIST(0.23,0,1,TRUE)"
b)
"=NORM.DIST(1.33,0,1,TRUE)"
c)
"=NORM.DIST(-0.95,0,1,TRUE)"
d)
"=NORM.DIST(-1.14,0,1,TRUE)"
Step-by-step explanation:
Previous concepts
Normal distribution, is a "probability distribution that is symmetric about the mean, showing that data near the mean are more frequent in occurrence than data far from the mean".
The Z-score is "a numerical measurement used in statistics of a value's relationship to the mean (average) of a group of values, measured in terms of standard deviations from the mean".
Solution to the problem
For this case we can find the areas using the standard normal table or Excel, for this case we will use excel command NORM.DIST who gives the area on the left area of a given value, and we provide the code for each case:
a)
"=NORM.DIST(0.23,0,1,TRUE)"
b)
"=NORM.DIST(1.33,0,1,TRUE)"
c)
"=NORM.DIST(-0.95,0,1,TRUE)"
d)
"=NORM.DIST(-1.14,0,1,TRUE)"