Forum Discussion
Can anyone explain how the phi(x) works?
Can anyone explain in what alternate universe or notation the Phi(x) function in Excel 2019 (probability based on the standard normal density function) works? In my education and in the textbook I sa...
The function PHI(x), which I had never come across, appears to be the probability density function
= NORM.DIST( x, 0, 1, FALSE )
[with zero mean and unit standard deviation] which shows a peak at x=0 and tails off in both directions. It is not the cumulative value
= NORM.DIST( x, 0, 1, TRUE )
which has a value of 50% at x=0, rising to 100% as x increases and dropping to 0% as it decreases
