Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 49
Default graph a normal distribution with skew and kurtosis

Hi,
I know the mean, max, min, standard deviation, skew and kurtosis.

I need to plot a graph with this data and I have got as far as using
NORMDIST to create the normal distribution curve. How do I add in the skew
and kurtosis

Thanks
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: graph a normal distribution with skew and kurtosis

To plot a normal distribution with skew and kurtosis:
  1. Enter your data into a new Excel worksheet. Include the mean, max, min, standard deviation, skew, and kurtosis.
  2. Use the
    Code:
    NORMDIST
    function to create the normal distribution curve. For example, if your mean is in cell A1 and your standard deviation is in cell A2, you can use the formula
    Code:
    =NORMDIST(x,A1,A2,FALSE)
    to calculate the probability density function for a given value of x.
  3. To add skew to the distribution, use the SKEW function. If your skew is in cell A3, you can adjust the distribution curve by multiplying the
    Code:
    NORMDIST
    result by the SKEW value. For example, if your
    Code:
    NORMDIST
    formula is in cell B1, you can use the formula
    Code:
    =B1*(1+A3)
    to adjust for positive skew or
    Code:
    =B1*(1-A3)
    to adjust for negative skew.
  4. To add kurtosis to the distribution, use the KURT function. If your kurtosis is in cell A4, you can adjust the distribution curve by raising the
    Code:
    NORMDIST
    result to the power of the KURT value. For example, if your
    Code:
    NORMDIST
    formula is in cell B1, you can use the formula
    Code:
    =B1^A4
    to adjust for high kurtosis or
    Code:
    =B1^(1/A4)
    to adjust for low kurtosis.
  5. Plot the adjusted distribution curve on a graph. You can use Excel's charting tools to create a line chart or scatter plot of the data.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 620
Default graph a normal distribution with skew and kurtosis

Your subject line talks of a normal distribution, in which case presumably
your skew is zero and kurtosis is 3? If not, you presumably don't have a
normal distribution? Similarly if you have a normal distribution your max
and min are at plus and minus infinity?
--
David Biddulph

"MarkS" wrote in message
...
Hi,
I know the mean, max, min, standard deviation, skew and kurtosis.

I need to plot a graph with this data and I have got as far as using
NORMDIST to create the normal distribution curve. How do I add in the skew
and kurtosis

Thanks



  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 762
Default graph a normal distribution with skew and kurtosis

MarkS -

The normal curve (bell-shaped) is completely described by only two
parameters: the mean and standard deviaton.

For charting instructions, see

http://www.tushar-mehta.com/excel/ch...tion/index.htm

- Mike
http://www.mikemiddleton.com


"MarkS" wrote in message
...
Hi,
I know the mean, max, min, standard deviation, skew and kurtosis.

I need to plot a graph with this data and I have got as far as using
NORMDIST to create the normal distribution curve. How do I add in the skew
and kurtosis

Thanks



  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 49
Default graph a normal distribution with skew and kurtosis

This is what I know
Min -5.83% -5.83% -3.88%
Avg 0.10% -0.41% -0.17%
Max 5.84% 2.17% 1.92%
Std Dev 1.86% 1.45% 1.43%
Skew 0.2621 -2.4322 -0.8981
Kurt 3.0580 9.6449 0.8925


"David Biddulph" wrote:

Your subject line talks of a normal distribution, in which case presumably
your skew is zero and kurtosis is 3? If not, you presumably don't have a
normal distribution? Similarly if you have a normal distribution your max
and min are at plus and minus infinity?
--
David Biddulph

"MarkS" wrote in message
...
Hi,
I know the mean, max, min, standard deviation, skew and kurtosis.

I need to plot a graph with this data and I have got as far as using
NORMDIST to create the normal distribution curve. How do I add in the skew
and kurtosis

Thanks






  #6   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 49
Default graph a normal distribution with skew and kurtosis

this is what I know
Min -5.83% -5.83% -3.88%
Avg 0.10% -0.41% -0.17%
Max 5.84% 2.17% 1.92%
Std Dev 1.86% 1.45% 1.43%
Skew 0.2621 -2.4322 -0.8981
Kurt 3.0580 9.6449 0.8925


"David Biddulph" wrote:

Your subject line talks of a normal distribution, in which case presumably
your skew is zero and kurtosis is 3? If not, you presumably don't have a
normal distribution? Similarly if you have a normal distribution your max
and min are at plus and minus infinity?
--
David Biddulph

"MarkS" wrote in message
...
Hi,
I know the mean, max, min, standard deviation, skew and kurtosis.

I need to plot a graph with this data and I have got as far as using
NORMDIST to create the normal distribution curve. How do I add in the skew
and kurtosis

Thanks




  #7   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 837
Default graph a normal distribution with skew and kurtosis

"Kurtosis" may mean "excess kurtosis"
http://mathworld.wolfram.com/Kurtosis.html
which is 0 for the normal distribution and is estimated by the Excel KURT()
function.

Jerry

"David Biddulph" wrote:

Your subject line talks of a normal distribution, in which case presumably
your skew is zero and kurtosis is 3? If not, you presumably don't have a
normal distribution? Similarly if you have a normal distribution your max
and min are at plus and minus infinity?
--
David Biddulph

"MarkS" wrote in message
...
Hi,
I know the mean, max, min, standard deviation, skew and kurtosis.

I need to plot a graph with this data and I have got as far as using
NORMDIST to create the normal distribution curve. How do I add in the skew
and kurtosis

Thanks




  #8   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 837
Default graph a normal distribution with skew and kurtosis

Is this one data set with 18 observations (in which case Min, Max, etc are
not labeling estimates from the distribution), or are these summary
statistics for 3 data sets (what is the sample size?)

IF this is a complete enumeration of one data set, please clarify the
relationship between values that are and are not expressed as %.

Jerry

"MarkS" wrote:

This is what I know
Min -5.83% -5.83% -3.88%
Avg 0.10% -0.41% -0.17%
Max 5.84% 2.17% 1.92%
Std Dev 1.86% 1.45% 1.43%
Skew 0.2621 -2.4322 -0.8981
Kurt 3.0580 9.6449 0.8925


"David Biddulph" wrote:

Your subject line talks of a normal distribution, in which case presumably
your skew is zero and kurtosis is 3? If not, you presumably don't have a
normal distribution? Similarly if you have a normal distribution your max
and min are at plus and minus infinity?
--
David Biddulph

"MarkS" wrote in message
...
Hi,
I know the mean, max, min, standard deviation, skew and kurtosis.

I need to plot a graph with this data and I have got as far as using
NORMDIST to create the normal distribution curve. How do I add in the skew
and kurtosis

Thanks




  #9   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 182
Default graph a normal distribution with skew and kurtosis

Hello, Mike!
You wrote on Sun, 17 Dec 2006 22:12:15 -0800:

MM The normal curve (bell-shaped) is completely described by
MM only two parameters: the mean and standard deviaton.

MM For charting instructions, see

MM
http://www.tushar-mehta.com/excel/ch...tion/index.htm

MM - Mike
MM http://www.mikemiddleton.com

This is doubtless correct but I suppose you could modify the
values given by a normal curve to show kurtosis and skewness by
using a suitable non-linear scale. Still, I'm not sure how I
would achieve a given value of either.

MM "MarkS" wrote in message
MM ...
?? Hi,
?? I know the mean, max, min, standard deviation, skew and
?? kurtosis.
??
?? I need to plot a graph with this data and I have got as
?? far as using NORMDIST to create the normal distribution
?? curve. How do I add in the skew and kurtosis
??
?? Thanks


James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

  #10   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 837
Default graph a normal distribution with skew and kurtosis

A couple of approaches would be an Edgeworth expansion
http://www.math.sfu.ca/~cbm/aands/page_935.htm
or the so called "Skew Normal" distribution
http://tango.stat.unipd.it/SN/

Jerry

"James Silverton" wrote:

Hello, Mike!
You wrote on Sun, 17 Dec 2006 22:12:15 -0800:

MM The normal curve (bell-shaped) is completely described by
MM only two parameters: the mean and standard deviaton.

MM For charting instructions, see

MM
http://www.tushar-mehta.com/excel/ch...tion/index.htm

MM - Mike
MM http://www.mikemiddleton.com

This is doubtless correct but I suppose you could modify the
values given by a normal curve to show kurtosis and skewness by
using a suitable non-linear scale. Still, I'm not sure how I
would achieve a given value of either.

MM "MarkS" wrote in message
MM ...
?? Hi,
?? I know the mean, max, min, standard deviation, skew and
?? kurtosis.
??
?? I need to plot a graph with this data and I have got as
?? far as using NORMDIST to create the normal distribution
?? curve. How do I add in the skew and kurtosis
??
?? Thanks


James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not


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



All times are GMT +1. The time now is 10:39 PM.

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

About Us

"It's about Microsoft Excel"