View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Sebastien Sebastien is offline
external usenet poster
 
Posts: 22
Default How to plot a normal distribution - Bell curve

Thanks, that works fine for the Bell shape curve, the X axis shows my
volatility data. The only problem is that the Y axis in the chart is the
Normdist() function number (so always less than zero). I would like to have
the number of occurence "N" of the data. Is this easy to get?
--
Thanks
Sebastien


"Joel" wrote:

1) Get the mean using the average function of your data
2) Get the standard deviation of your data using stdev function
3) Add new column with normal() function
a) column B will be the first parameter X.
b) Average will be the mean
c) Standard Dev is from 2 above
d) cumulative will be FALSE.

4) Plot columns b and c as a scatter plot.

NORMDIST(x,mean,standard_dev,cumulative)



"edvwvw via OfficeKB.com" wrote:

Have a look he

http://www.statsoft.com/textbook/std...tml#log-normal

edvwvw





Sebastien wrote:
I have the daily volatility of Brent crude over the last year. So my column
A is the date, and column B is the volatility. I have around 300 datapoints.

I want to fit these datapoints in a normal distribution plot to see the
"Bell curve" shape.
How can I do this?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200806/1