Spread.NET 17 Formula Reference
Formula Functions / Functions M to Q / NORMDIST
In This Topic
    NORMDIST
    In This Topic

    This function returns the normal cumulative distribution for the specified mean and standard deviation.

    Syntax

    NORMDIST(x,mean,stdev,cumulative)

    Arguments

    This function has these arguments:

    Argument Description
    x Value for which to find the distribution
    mean Arithmetic mean of the distribution
    stdev Standard deviation of the distribution Must be greater than zero.
    cumulative Set to TRUE to return the cumulative distribution function. Set to FALSE to return the probability mass function.

    Remarks

    If mean = 0 and stdev = 1, this function returns the standard normal distribution, NORMSDIST.

    Data Types

    The x, mean, and stdev arguments accept numeric data. The cumulative argument accepts logical data. Returns numeric data.

    Examples

    NORMDIST(10,A3,B17,FALSE)

    NORMDIST(10,R3C1,R17C2,FALSE)

    NORMDIST(37,41.125,9.86,TRUE) gives the result 0.3378810361

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    NORMINV | NORMSDIST | Statistical Functions