For a distribution with a mean of 350000 and a standard deviation of 1.5,
your value of 84000 is 177333 standard deviations below the mean, so what
would you expect the cumulative probability to be? Zero sounds a good
approximation to me.
When you get down your table to 378000, you switch from a large number of
standard deviations below the mean to 18667 standard deviations above the
mean, and then the cumulative probability steps up to 1. Isn't that what
you'd expect?

Have you looked again at Excel help for the NORMDIST function to remind
yourself what it does and what the syntax is? What were you expecting the
function to tell you?
--
David Biddulph

"A little stuck" wrote in message
...
Thanks to all of you.
I am trying to use the NORMDIST function to create my bell curve, and am
putting the following values into a table:
84000
126000
210000
252000
294000
336000
378000
420000
462000
504000
546000
588000
However, the function is returning '0' for all of them. Eg. for the first
value I entered: =NORMDIST(B79, 350000, 1.5, TRUE), then: =NORMDIST(B80,
350000, 1.5, TRUE) for the second value etc. What am I doing wrong?

"Herbert Seidenberg" wrote:

Excel 2007
Skewed Normal Distribution
http://www.mediafire.com/file/nmdmvyyvndj/09_14_09.xlsx