View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Barbara
 
Posts: n/a
Default Graph a normal distribution chart?

David,
I am not sure about the formula. I try almost every sample formula but
still can't curve the bell shape. What I want to do is have the mean as a
percentage and the numbers are as followed: Do I use those formula you gave
me as well? Thanks.

74% = 34/46 times
30% = 14/46 times
44% = 20/26 times
26% = 12/46 times

how do i graph this?

"David Biddulph" wrote:

"Barbara" wrote in message
...
I am having trouble graphing the percentage to the bell curve shape. Can
anyone help? Thanks.


If you're looking for the density function for the normal distribution, try
=(EXP(-POWER(A2,2)/2))/SQRT(2*PI())
and scale appropriately.

If you're looking for the cumulative, try
=NORMSDIST(A2)
--
David Biddulph