In This Topic

NORMDIST

In This Topic

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

NORMDIST(*x*,*mean*,*stdev*,*cumulative*)

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. |

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

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

NORMDIST(10,A3,B17,FALSE)

NORMDIST(10,R3C1,R17C2,FALSE)

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

This function is available in product version 1.0 or later.

NORMINV | NORMSDIST | Statistical Functions