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