Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > NORMSDIST
 

NORMSDIST(z)

 
 Returns the standard normal cumulative distribution function.

 zThe value for which you want the distribution.

 REMARKS
 
  		• If "z" is not numeric, then #VALUE! is returned.
     
  		• The distribution has a mean of 0 (zero) and a standard deviation of one.
     
  		• This function should be used in place of a table of standard normal curve areas.
     
  		• A z-score indicates how many standard deviations it is from the mean.
     
  		• Example 1 - All normal distributions are perfectly symmetrical, there is no skewness.
     
  		• Example 2 - If you are one standard deviation above the mean, then you have a percentile rank of 84%.

     EXAMPLES
     
     A
    1=NORMSDIST(0) = 0.5
    2=NORMSDIST(1) = 0.841
    3=1-NORMSDIST(-1) = 0.841
    4=1-NORMSDIST(1) = 0.159
    5=NORMSDIST(-1) = 0.159
    6=NORMSDIST(2) = 0.977
    7=NORMSINV(NORMSDIST(-1)) = -1
    8=NORMSDIST(-10) = 0
    9=NORMSDIST(-20) = 0
    10=NORMSDIST(20) = 1
    11=NORMSDIST("some text") = #VALUE!
    		 
     Functions - N | Index - N | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top