Documentation/Calc Functions/NORM.S.DIST

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

NORM.S.DIST

Category:

Statistical Analysis

Summary:

Returns the standard normal cumulative distribution function. The distribution has a mean of zero and a standard deviation of one.

Syntax:

NORM.S.DIST(Number; Cumulative)

Returns:

Arguments:

Number is the value to which the standard normal cumulative distribution is calculated.

Cumulative 0 or FALSE calculates the probability density function. Any other value or TRUE calculates the cumulative distribution function.

Additional details:

Examples:

=NORM.S.DIST(1;0) returns 0.2419707245.

=NORM.S.DIST(1;1) returns 0.8413447461. The area below the standard normal distribution curve to the left of X value 1 is 84% of the total area.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: