Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I add a Gaussian curve to a histogram on Excel? | Charts and Charting in Excel | |||
how do I create a histogram with gaussian curve | Charts and Charting in Excel | |||
NORMDIST | Excel Worksheet Functions | |||
NORMDIST function | Excel Worksheet Functions | |||
How to draw a gaussian curve with Excel? | Charts and Charting in Excel |