Documentation/Calc Functions/PHI

From The Document Foundation Wiki
Jump to: navigation, search

Function name:

PHI

Category:

Statistical Analysis

Summary:

Calculates values of the probability density function for the standard normal distribution. The standard normal distribution has a mean of zero and a standard deviation of one, and its probability density function is often referred to by the Greek letter phi.

Syntax:

PHI(Number)

Returns:

Returns a real number which is the value of the probability density function for a standard normal distribution. It ranges from 0 to 1, i.e. [0,1].

Arguments:

Number is a real number or a reference to the cell containing that number which is the value for which the standard normal distribution is to be calculated.

Additional details:

  • The PHI function calculates the same value as NORM.DIST(Number;0;1;FALSE()) or NORMDIST(Number;0;1;FALSE()) or NORM.S.DIST(Number;FALSE())
  • The formula for PHI is:
Normsdistp.png

where x is the Number.

  • For more details on the standard normal distribution, visit Wikipedia

Examples:

Formula Description Returns
=PHI(1) The function calculates the probability density function of the standard normal distribution for the given value. 0.241970724519143
=PHI(2.25) The function calculates the probability density function of the standard normal distribution for the given value. 0.031739651835668
=PHI(-2.25) The function calculates the probability density function of the standard normal distribution for the given value. 0.031739651835668
=PHI(0) The function calculates the probability density function of the standard normal distribution for the given value. 0.398942280401433

Related LibreOffice functions:

NORM.S.DIST

NORMSDIST

NORM.S.INV

NORMDIST

NORM.DIST

NORMSINV

ODF standard:

Section 6.18.61, part 2

Equivalent Excel functions:

PHI