Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
chart normal distribution/standard deviation | Excel Worksheet Functions | |||
is there a normal distribution chart in XL? | Charts and Charting in Excel | |||
normal distribution chart | Charts and Charting in Excel | |||
Graph a normal distribution chart? | Charts and Charting in Excel | |||
Can I chart normal distribution in excel? | Charts and Charting in Excel |