|
Gaussian Curve using Normdist?
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 |
Gaussian Curve using Normdist?
You've done the job, then. A normal distribution *IS* gaussian.
-- David Biddulph wrote in message ups.com... 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 |
Gaussian Curve using Normdist?
On Apr 17, 3:02 am, "David Biddulph" <groups [at] biddulph.org.uk
wrote: You've done the job, then. A normal distribution *IS* gaussian. -- David Biddulph wrote in message ups.com... 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- Hide quoted text - - Show quoted text - Looking for a gaussian curve that is skewed and not a uniformly shaped normdist curve. any takers? |
Gaussian Curve using Normdist?
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...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 " wrote: On Apr 17, 3:02 am, "David Biddulph" <groups [at] biddulph.org.uk wrote: You've done the job, then. A normal distribution *IS* gaussian. -- David Biddulph wrote in message ups.com... 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- Hide quoted text - - Show quoted text - Looking for a gaussian curve that is skewed and not a uniformly shaped normdist curve. any takers? |
| All times are GMT +1. The time now is 04:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com