PHI function

The PHI function returns the value of the density function for a normal distribution with mean 0 and standard deviation 1, calculated with the formula .

Parts of a PHI function

PHI(x)

Parts Description
x The input to the standard normal distribution function.

Sample formula

PHI(0.25)

Notes

This is a special case of the NORMDIST function, where mean is 0, standard deviation is 1, and 'cumulative' is false.

Examples

  A B
1 Formula Result
2 =PHI(0.5) 0.3520653268
3 =PHI(1) 0.2419707245
4 =PHI(1.5) 0.1295175957

Related functions

  • STDEV: The STDEV function calculates the standard deviation based on a sample.
  • NORMDIST: The NORMDIST function returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.
Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false
true
true
35
false
false