Gaussian Curve using Normdist?

[velocityinc]

How does one come up with a gaussian formula using normdist and mean
and sigma provided?
I know how to create a normal distrib but dont know how to move
forward on a gaussian.....thanks, v

 

[David Biddulph]

You've done the job, then. A normal distribution *IS* gaussian.

 

[velocityinc]

You've done the job, then. A normal distribution *IS* gaussian.
--
David Biddulph






- Show quoted text -

Looking for a gaussian curve that is skewed and not a uniformly shaped
normdist curve. any takers?

 

[Jerry W. Lewis]

The gaussian distribution is not skewed.
http://en.wikipedia.org/wiki/Gaussian_curve
http://en.wikipedia.org/wiki/Gaussian_distribution

If you mean the so-called "shew-normal" distribution
http://azzalini.stat.unipd.it/SN/
The pdf, can be calculatated as a product of two NORMDIST calls, as shown in
http://azzalini.stat.unipd.it/SN/Intro/intro.html
The cdf cannot be easily calculated using solely native Excel functions

If you are up for translating from Fortran to VBA, you would find
http://www.jstatsoft.org/counter.php?id=28&url=v05/i05/t.pdf&ct=1
to be helpful in implementing Azzalini's formulas. I would also recommend
using the Smith library of probability functions
http://members.aol.com/iandjmsmith/iansNApage.htm
instead of native Excel functions

Jerry