View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Normal distribution curve

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%