Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 837
Default Charting Distribution with Skewness

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
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
distribution curve (skewness) hendra Charts and Charting in Excel 3 July 21st 06 01:19 PM
skewness issue Embee Excel Discussion (Misc queries) 2 February 12th 06 03:33 AM
Random Distribution Rick via OfficeKB.com Excel Discussion (Misc queries) 3 April 29th 05 07:53 PM
Distribution Chart BL Charts and Charting in Excel 1 April 21st 05 02:33 AM
Custom charting - Stacked charting with a line Randy Lefferts Charts and Charting in Excel 3 March 3rd 05 03:10 AM


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

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"