View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.charting
A little stuck[_2_] A little stuck[_2_] is offline
external usenet poster
 
Posts: 21
Default How do I create a bell curve?

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