Use Excel's function options to find the following z values for the standard normal variable Z.

a. P(Z z) = 0.1020

b. P(z Z 0) = 0.1772

c. P(Z > z) = 0.9929

d. P(0.40 Z z) = 0.3368

P(Z<0.40) =a Determine the probability of the z score being less then 0.40

a + 0.3368 Determine the probability of Z being less than z. The answer to this is C16

P(Z z)= a+0.3368 Determine the z score that will produce the Z score where the probability to the left of the value is C16