Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 837
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I add a Gaussian curve to a histogram on Excel? JC1379 Charts and Charting in Excel 6 April 3rd 23 04:20 PM
how do I create a histogram with gaussian curve iornbear78 Charts and Charting in Excel 1 December 19th 06 11:47 PM
NORMDIST Tschuß Excel Worksheet Functions 2 November 27th 06 01:14 PM
NORMDIST function [email protected] Excel Worksheet Functions 2 March 30th 06 02:07 AM
How to draw a gaussian curve with Excel? BigRu Charts and Charting in Excel 3 February 6th 05 04:41 PM


All times are GMT +1. The time now is 06:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"