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

NORMDIST(x, mean, standard_dev, cumulative)

 
 Returns the normal cumulative distribution for the specified mean and standard deviation.

 xThe value for which you want the distribution.
 meanThe arithmetic mean of the distribution.
 standard_devThe standard deviation of the distribution.
 cumulativeTrue or False to specify the form of the function.

 REMARKS
 
  		• If "mean" is not numeric, then #VALUE! is returned.
     
  		• If "mean" = 0 and "standard_dev" = 1, then the standard normal distribution is used.
     
  		• If "standard_dev" is nonnumeric, then #VALUE! is returned.
     
  		• If "standard_dev" = 0, then #NUM! is returned.
     
  		• If "cumulative" = True, then the cumulative distribution function is used.
     
  		• If "cumulative" = False, then the probability mass function is used.
     
  		• This function has a very wide range of applications in statistics, including hypothesis testing.

     EXAMPLES
     
     A
    1=NORMDIST(42,40,1.5,TRUE) = 0.909
    2=NORMDIST(42,40,10,TRUE) = 0.579
    3=NORMDIST(42,40,1.5,) = 0.109
    4=NORMDIST("42",40,1.5,) = 0.109
    5=NORMDIST(42,40,,) = #NUM!
    6=NORMDIST(42,"some text",1.5,) = #VALUE!
    		 
     Functions - N | Index - N | Office Online 

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