Use STANDARD_NORMAL_DISTRIBUTION_CUMULATIVE for Cumulative Data

Description

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

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.

Type	Dimensions
Number	Dimensions of argument Number

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 equivalent: NORM.S.DIST

See also: STANDARD_NORMAL_DISTRIBUTION