Stata function equivalent to Excel's Norm.dist (CDF?)

[Ece Kural]

Hi,
I'm trying to create a new variable which is the cumulative normal distribution of another variable. I tried normal(), and many other varieties, but I'm not getting the same results I'm getting from Excel's Norm Diet function (cumulative). Is there an equivalent or how can I do this?
Thanks so much!

[Clyde Schechter]

The Excel NORM.DIST function allows you to specify the mean and standard deviation. The cumulative normal distribution function in Stata uses only the standard normal distribution. So the expression analogous to NORM.DIST(x, mean, sd) in Excel is

normal((x-mean)/sd)

[Ece Kural]

Thank you very much! It solved it.

[Jorge L. Guzman]

Hi Clyde,
Thank you very much for your post. What if the function is not cumulative?
Thank you in advance,
Jorge

[Clyde Schechter]

So I take it you are referring to the density function of the normal distribution? That would be normalden((x-mean)/sd)

[Jorge L. Guzman]

Hi Clyde, Thank you for your answer. Yes, you were right, thank you, but I used this code:

gen dm2 =normalden(var1,mean,sd)

and I got exactly what I wanted.

Kind regards,
Jorge