Probably easiest to plug your data into a preexisting template/model:
http://www.vertex42.com/ExcelArticle...ion-Excel.html

Else, see this:
http://www.exceluser.com/explore/statsnormal.htm
http://www.tushar-mehta.com/excel/ch..._distribution/

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Dave" wrote:

How do I create a normal distribution curve in excel. I have the following
data:

In R2 TO R69 I have cost as a percentage of value for different projects. I
want to create a normal distribution curve for the values in R2 TO R69 to see
how these % line up on a normal distribution curve. I calculated the average
and stdev for these percentages and then I used bn range but my calculations
do not work out . Thanks.

The values in R2 TO R69 unsorted are and there are some blanks:
6%
79%
45%
122%

22%
120%
6%
57%
25%
17%
83%
50%
32%
12%
76%
18%
2%
64%
5%
2%
23%

62%
58%
13%
23%
35%
22%


100%
13%
79%
8%
31%
18%
65%
61%
12%

72%
85%

26%


60%
62%
63%
94%
104%
91%
91%
58%
38%
31%
86%

43%
78%

74%
16%
70%
94%
40%
5%