For a standard normal distribution, find the probability of obtaining a value less than z=1.5

Question

For a standard normal distribution, find the probability of obtaining a value less than z=1.5

Answer 1

Use "=NORMSDIST(1.5)" and you should have it.

The "Help" for this function says:

NORMSDIST

Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas.

Syntax

NORMSDIST(z)

Z is the value for which you want the distribution.