NORMDIST

Owned by Juliane Wetzel
Feb 07, 2020
1 min read

Syntax

NORMDIST( <number>, <number>, <number>; <boolean>)

Description

Returns the normal distribution for a certain value with given mean and standard deviation.

or

Returns the normal density function or the cumulative distribution function for the normal distribution. This function is frequently used used to measure the degree of diversity between two data sets.

The function arguments are:

  • x: The value for which the distribution should be computed (NUMERIC)
  • Mean: The mean of the distribution (NUMERIC)
  • Standard deviation: The standard deviation of the distribution (NUMERIC) 
  • Cumulative: Constant indicating the form of the function. If "true" then the cumulative distribution function is used. If "false" then the probability density function is used. (BOOLEAN)
Cumulative/BooleanLogical argument which defines the type of distribution to be calculated
TrueUses the cumulative distribution function
FalseUses the probability density function

Examples

NORMDIST(#input!Value;#input!Mean;#input!Standard_deviation;cumulative value)

Value
Mean
Standard_deviation
Cumulative valueNORMDIST returns
42401.5false0.10934005
42401.5true0.908789

Common Errors

#NUM!-

Occurs if either:

  • The x value is less than 0
  • The numerator or denominator is less than 1
#VALUE!-Occurs if the argument type isn't numeric