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
The input to the standard normal distribution function.
This is a special case of the NORMDIST function, where mean is 0, standard deviation is 1, and ‘cumulative’ is false.
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.