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)

PartsDescription
xThe 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

AB
1Formula
2=PHI(0.5)
3=PHI(1)
4=PHI(1.5)
  • 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.