Home |
Search |
Today's Posts |
#1
|
|||
|
|||
charts & graphs
does anyone know how to create a normal curve graph in the chart wizard? i
know the mean and the standard deviation |
#2
|
|||
|
|||
charts & graphs
Hi,
Well, you have to calculate probabilities for a series of x values using the Gaussian probability distribution function. P = 1/(stdev*sqrt(2 pi))*exp(-0.5*((x-mean)/stdev)^2) For example, if mean is 1.2 and standard deviation is 0.3: Create in column A, x-values that are about 4 standard deviations plus/minus from the mean (in this example, 0 to 2.4) in small increments; So A2, A3, .... A26 could be 0, 0.1, 0.2, ............ 2.4. For convenience place the mean and standard deviation is two cells, say D2 and E2 respectively. Now you can calculate the probability for each x value as follows: In B2 enter the following formula: =1/($E$2*SQRT(2*PI()))*EXP(-0.5*((A2-$D$2)/$E$2)^2) and fill-in the formula down to B26. Now make an XY-Scatter plot of B2:B26 versus A2:A26. Regards, B. R. Ramachandran "graph" wrote: does anyone know how to create a normal curve graph in the chart wizard? i know the mean and the standard deviation |
#3
|
|||
|
|||
charts & graphs
Excel already gives you the formula NORMDIST in Data Analysis.
To match the amplitude of the normal curve to your histogram multiply by sample size and by increment. A macro on a CD that comes with Data Analysis with MS Excel by Berk and Carey does everything for you automatically. |
#4
|
|||
|
|||
charts & graphs
Thanks!
"Herbert Seidenberg" wrote: Excel already gives you the formula NORMDIST in Data Analysis. To match the amplitude of the normal curve to your histogram multiply by sample size and by increment. A macro on a CD that comes with Data Analysis with MS Excel by Berk and Carey does everything for you automatically. |
#5
|
|||
|
|||
charts & graphs
Thank you!
"B. R.Ramachandran" wrote: Hi, Well, you have to calculate probabilities for a series of x values using the Gaussian probability distribution function. P = 1/(stdev*sqrt(2 pi))*exp(-0.5*((x-mean)/stdev)^2) For example, if mean is 1.2 and standard deviation is 0.3: Create in column A, x-values that are about 4 standard deviations plus/minus from the mean (in this example, 0 to 2.4) in small increments; So A2, A3, .... A26 could be 0, 0.1, 0.2, ............ 2.4. For convenience place the mean and standard deviation is two cells, say D2 and E2 respectively. Now you can calculate the probability for each x value as follows: In B2 enter the following formula: =1/($E$2*SQRT(2*PI()))*EXP(-0.5*((A2-$D$2)/$E$2)^2) and fill-in the formula down to B26. Now make an XY-Scatter plot of B2:B26 versus A2:A26. Regards, B. R. Ramachandran "graph" wrote: does anyone know how to create a normal curve graph in the chart wizard? i know the mean and the standard deviation |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting worksheet with embedded charts | Charts and Charting in Excel | |||
charts and graphs | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
Charts/ Graphs information from more then one worksheet | New Users to Excel | |||
Refresh queries, graphs, and charts | Excel Discussion (Misc queries) |