NormDist - script and chart function
NormDist() returns the cumulative normal distribution for the specified mean and standard deviation. If mean = 0 and standard_dev = 1, the function returns the standard normal distribution.
Syntax:
NormDist(value, mean, standard_dev)
Return data type: number
Arguments:
Argument | Description |
---|---|
value | The value at which you want to evaluate the distribution. |
mean | A value stating the arithmetic mean for the distribution. |
standard_dev | A positive value stating the standard deviation of the distribution. |
This function is related to the NormInv function in
the following way:
If prob = NormDist(value, m,
sd), then NormInv(prob, m, sd) = value
Limitations:
All arguments must be numeric, else NULL will be returned.
Examples and results:
Example | Result |
---|---|
NormDist( 0.5, 0, 1) | Returns 0.6915 |