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 |