normal distribution chart
 

How do I chart a normal distribution curve using a scatter plot?

I plotted a bell curve using
http://www.tushar-tehta.com/excel/ch..._distribution/ but I can't
seem to figure out how to plot using my own data.

Using excel 2007

Thanks for your help

normal distribution chart
 

Well, the question is - is your data normally destributed? Show us a sample
of the data.

I think you will first need to sort on the x-axis data then use a formula
such as

=NORMDIST(A1,AVERAGE($B$1:$B$18),STDEVP($B$1:$B$18 ),FALSE)

depending on the data you would need to plot this on a secondary axis or
normalize it.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Rene" wrote:

How do I chart a normal distribution curve using a scatter plot?

I plotted a bell curve using
http://www.tushar-tehta.com/excel/ch..._distribution/ but I can't
seem to figure out how to plot using my own data.

Using excel 2007

Thanks for your help

normal distribution chart
 

My data looks like this
A1:A25 (Jan 1 - Jan 31)
B1:B25 (25, 75, 125, blank, 200, 10, etc)

mean 10, std dev 2 (bell curve from www.tushar-tehta.com)
-4 2 6.69151E-05
-3.75 2.5 0.000176298
-3.5 3 0.000436341

The average is 99 and standard deviation is 9.3. I would like to see it
visually on a chart (normal distribution) so when it is out of whack it will
jump out at me. When the standard deviation is more than 1/3 of the average.


Do I resign myself to the standard deviation formula and color code the
result to stand out?

Hopefully this is clearer than mud.

Thanks again.

"Shane Devenshire" wrote:

Well, the question is - is your data normally destributed? Show us a sample
of the data.

I think you will first need to sort on the x-axis data then use a formula
such as

=NORMDIST(A1,AVERAGE($B$1:$B$18),STDEVP($B$1:$B$18 ),FALSE)

depending on the data you would need to plot this on a secondary axis or
normalize it.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Rene" wrote:

How do I chart a normal distribution curve using a scatter plot?

I plotted a bell curve using
http://www.tushar-tehta.com/excel/ch..._distribution/ but I can't
seem to figure out how to plot using my own data.

Using excel 2007

Thanks for your help