# Documentation/Calc Functions/PHI

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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:

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) | 0.398942280401433 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

PHI