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

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.

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

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

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

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

"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

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

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

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