Returns the normal distribution for the specified mean and standard deviation. This function has a very wide range of applications in statistics, including hypothesis testing.

NORM.DIST takes 4 required arguments and no optional arguments:

Syntax: NORM.DIST(x, mean, standard_dev, cumulative)

The arguments for the NORM.DIST function are:
Argument Required? Description
x Required The value for which you want the distribution.
mean Required The arithmetic mean of the distribution.
standard_dev Required The standard deviation of the distribution.
cumulative Required A logical value that determines the form of the function. If cumulative is TRUE, NORM.DIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.
comments powered by Disqus