Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
|
|||
|
|||
Answer: graph a normal distribution with skew and kurtosis
To plot a normal distribution with skew and kurtosis:
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|