View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default 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!