LOGINV

Syntax:

LOGINV ( probability , mean , standard-dev )

Description: Calculates the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard-dev.

Mathematical Formula:

Arguments:

Name

Type

Description

probability

number

A probability associated with the lognormal distribution.

mean

number

The mean of ln(x).

standard-dev

number

The standard deviation of ln(x).

Return Type and Value: number – The inverse of the lognormal cumulative distribution function of x.

However, if

  • probability < 0 or probability > 1, #NUM! is returned.

  • standard-dev ≤ 0, #NUM! is returned.

example: