STANDARD_NORMAL_DISTRIBUTION function

  • 4 April 2024
  • 0 replies
  • 60 views

Userlevel 5
Badge +8

Description

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

 

Syntax

STANDARD_NORMAL_DISTRIBUTION(Value)

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

The equation for standard normal distribution is provided below.

 

 

If you need more information on 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(0)

0.39894228040143

Standard Normal probability distribution function at 0

Number

STANDARD_NORMAL_DISTRIBUTION(Blank)

blank 

Number

 

Excel equivalent: NORM.S.DIST

See also: STANDARD_NORMAL_DISTRIBUTION_CUMULATIVE


This topic has been closed for comments