Excel functions / Statistics

PHI function

The height of the standard normal bell curve at x.

Syntax

=PHI(x)

Arguments

When to use it

PHI gives the height of the standard normal curve at a z-score. For the share of values below a z-score, use NORM.S.DIST with TRUE.

Examples

  1. At z = 0.75

    ABC
    1z
    20.750.3011

    In C2: =PHI(A2) → 0.3011

    Try this example

Common mistakes

PHI in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try PHI in the playground

Related functions