Charting Distribution with Skewness
Hi,
The NORMDIST function does not support a skewness option. Excel has a SKEW
function but it only calculates the skew of your data, it doesn't apply the
skew to a distribution. So in other words there is nothing built into Excel
to do this.
--
Thanks,
Shane Devenshire
" 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!
|