Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Many distributions may have the same low order cumulants. GAMMADIST (which
is closely related to CHIDIST) is the most general skewed continuous distribution natively provided in Excel. http://en.wikipedia.org/wiki/Gamma_distribution gives the mean, variance, skewness, and kurtosis in terms of the parameters of the distribution. In particular, alpha=4 with beta=2.5 would have the population mean=10 and population SD=5, but its population skewnss is 1. Jerry " wrote: I have some sales data that I am looking to chart based on it's distribution. Using the NORMDIST function I was able to construct a normal distribution chart for the mean and StDev of the data - however how can I chart the data if it has a positive skew? ie: Mean of 10, StDev of 5, and a Skewness of 1.28. I would like to create a distribution curve based on those parameters. Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
distribution curve (skewness) | Charts and Charting in Excel | |||
skewness issue | Excel Discussion (Misc queries) | |||
Random Distribution | Excel Discussion (Misc queries) | |||
Distribution Chart | Charts and Charting in Excel | |||
Custom charting - Stacked charting with a line | Charts and Charting in Excel |