Skip to main content

Description

Returns the cumulative standard normal distribution, which has a mean of zero and a standard deviation of one.

 

Syntax

STANDARD_NORMAL_DISTRIBUTION_CUMULATIVE(Value)

  • Value  This is the value for which you want the cumulative distribution. This can be an Integer or a Number. 

The equation for cumulative standard normal distribution is provided below.

 

If you need more information on cumulative standard normal distribution, click here to read about it on Wikipedia. 

 

Returns

Type Dimensions
Number Dimensions of argument Number

 

Examples

Case

Results

Return Type

STANDARD_NORMAL_DISTRIBUTION_CUMULATIVE(0)

0.5

Cumulated value of Standard Normal probability distribution function at 0

Number

STANDARD_NORMAL_DISTRIBUTION_CUMULATIVE(Blank)

blank 

Number

 

Excel equivalentNORM.S.DIST

See also: STANDARD_NORMAL_DISTRIBUTION

Be the first to reply!