Home 
Search 
Today's Posts 
#1




How to plot a normal distribution  Bell curve
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?  Thanks Sebastien 
#2




How to plot a normal distribution  Bell curve
Have a look he
http://www.statsoft.com/textbook/std...tml#lognormal 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 
#3




How to plot a normal distribution  Bell curve
This is good theory, but I would like to have a formula in Excel. Is there a
function or a n easy way ot generate the normal distribution chart?  Thanks Sebastien "edvwvw via OfficeKB.com" wrote: Have a look he http://www.statsoft.com/textbook/std...tml#lognormal 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 
#4




How to plot a normal distribution  Bell curve
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#lognormal 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 
#5




How to plot a normal distribution  Bell curve
It will take more than a formula to generate the curve. The link below takes
you to a Microsoft guide which should be helpful http://support.microsoft.com/kb/213930 edvwvw Sebastien wrote: This is good theory, but I would like to have a formula in Excel. Is there a function or a n easy way ot generate the normal distribution chart? Have a look he [quoted text clipped  8 lines] "Bell curve" shape. How can I do this?  Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200806/1 
#6




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#lognormal 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 
#7




How to plot a normal distribution  Bell curve
Sebastien 
You mention "300 datapoints" and "Bell curve." Usually, you first determine a frequency distribution and histogram (column chart of the frequency distribution, with value ranges on the horizontal axis and frequency "count" on the vertical axis). Second, you might want to see if the frequency distribution is approximately like a normal distribution. For the frequecy distribution and histogram, you can use the Histogram tool of Excel's Analysis ToolPak (check Excel's builtin Help). Or, you could use my free Better Histogram addin, available from the Histogram page at www.treeplan.com. It's also possible to add a normal curve to a histogram. An example workbook (but without stepbystep instructions) is available in the Excel Examples section of the home page at www.MikeMiddleton.com.  Mike Middleton http://www.DecisionToolworks.com Decision Analysis Addins for Excel "Sebastien" wrote in message ... 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?  Thanks Sebastien 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
How to graph normal distribution curve  Charts and Charting in Excel  
Chart, draw Normal Distribution curve  Setting up and Configuration of Excel  
normal distribution curve  Charts and Charting in Excel  
Plotting normal distribution curve  Charts and Charting in Excel  
bellshape normal distribution curve  Charts and Charting in Excel 