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 saved, Phi(0) = 50%, Phi(<0) = lower than 50% probability. Phi(0.75) = 0.7734
Looking at the excel help page,
=PHI(0.75) is” The value of the density function for a standard normal distribution. With a result on the help page of 0.301137432. This what I get when I enter it into Excel also.
Based on how it is traditionally taught Phi(0.75) should be greater than 50% (77.34%), not 30%.
I hope someone can explain what universe Excel is in and what units of X represent average, average +1 standard deviation, average - 1 standard deviation, etc.