Draw normal curve with excel.avi

In this video I will show how to draw a normal curve with Microsoft excel 2007. And then I paste the curve draw in excel to paint and edit it there.

The example used to illustrate the process plots a graph with a mean of 10 and a standard deviation of 2.

Start by setting up the x-values for a standard normal curve. Start with -4 and end with 4 with step size = 0.1 .

Then use formula =A2*(std. dev.)+mean. (with $ sign to lock the cell.) in cell B2
This converts the standard normal distribution to the distribution of interest.
Copy B2 down to cover all the rows that contain data in column A.

Then use formula =NORMDIST(B2,mean,std dev,FALSE) in cell C2.
This provides y-values for the distribution of interest.
Copy C2 down to cover all the rows that contain data in column A.

Plot columns A and C in a XY Scatter chart (smoothed lines without markers)

The curve is plot, remove the scale and everything.

Copy and paste in paint to edit it.

reference:
http://www.tushar-mehta.com/excel/charts/normal_distribution/

Category:

Education

Tags:

• Normal curve
• educational
• statistics

[jenessa1018]

I cannot figure out what you're doing at 0:50. Do I copy the formula? and then highlight those boxes in row B and... then what? I tried pressing enter but nothing happens

[limkianboon]

@jenessa1018

You just copy (Ctrl + C) the formula, then highlight those boxes in row B then paste it (Ctrl + V).

[limkianboon]

@jenessa1018

You need to draw the normal curve? Try to use graphmatica, it's much more easier. See the graphmatica video that I had post.I found that software after I plot it with Excel.

[jenessa1018]

@jenessa1018 Got it, nevermind