Draw normal curve with excel.avi

Channel:

Mr Lim

Subscribers:

7,980

Published on February 28, 2011 4:43:50 AM ● Video Link: https://www.youtube.com/watch?v=_v5fBCrGLV8

Duration: 3:39

89,524 views

52

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/