Statistical Functions

BND

Returns the bivariate normal distribution function.

=BND(x, y, rho)

CND

Returns the standard normal cumulative distribution (has a mean of zero and a standard deviation of one).

=CND(z)

' Returns 0.6915
=CND(0.5)
  • z is the value for which you want the distribution.

CNDEV

Returns the inverse cumulative normal distribution function.

=CNDEV(U)

' Returns 0
=CNDEV(0.5)
  • U is the value for which you want the distribution.

ND

Returns the normal distribution function.

=ND(x)

' Returns 0.3521
=ND(0.5)
  • x is the value for which you want the distribution.

PDF

Returns the probability density function.

=PDF(z)

' Returns 0.3521
=PDF(0.5)
  • z is the value for which you want the distribution.