How to calculate a z score decimal value

[Garras Porgratix]

Can anyone shed light on this problem: How to obtain the 4 digit number of a z-score on excel (do not want to waste time lookin up z values)
Does anyone know what the formula is to do so? I tried this:


The Normsdist(x) turns the z value into a 4 decimal value (ie. z=1.54 =.4382), subtracts this from .5 and then gives the probability of .0618. How does it calculate the .4382 ?

 

[gsistek]

I just used the Normsdist function on 1.54. It returns .9382, which is the probability z <= 1.54 based on a mean of 0 and a Standard Deviation of 1.
The .0618 is the probability z>1.54 or 1-.9382.
.4382 is the area under the normal curve between 0 and 1.54, in other words it is the probabilty 0<=z<=1.54.

I hope this helps.

 

[Garras Porgratix]

Thank you. This helps a lot. It just became clear what I an not doing right here.

 

[Garras Porgratix]

I think I got it now...