Is Excel's NORMSDIST function the Probability Density Function (PDF)?

75 Views Asked by At

I am trying to understand what is behind the NORMSDIST function and so far I have understood

https://www.tutorialspoint.com/advanced_excel_functions/advanced_excel_compatibility_normsdist_function

that it is the standard normal distribution where $\mu=0$ and $\sigma=1$ described by this Probability Density Function (PDF):

$$ \begin{equation} \label{eq:someequation} f_X(x) = \frac {1}{\sqrt {2\pi}} e^{-\frac 12 x^2} \end{equation} $$ However when I am trying to compare for instance NORMSDIST(1) it gives me the value of 0.84134474606854300000 while my actual implementation of the equation $(1)$ give me a value of 0.241970725. I would like to know if there is something wrong with the equation it self, is there any other implementation?