PHI functionThe 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.