Bell Curve

[Guest]

Is there a formula that will calculate a bell curve?

 

[Guest]

NORMDIST with the cumulative parameter set to FALSE will calculate points on
the bell curve. See
http://www.tushar-mehta.com/excel/charts/normal_distribution/index.htm
for details.

Jerry

 

[soon-to-retire-teacher]

I went to the Web Site and printed out the 10 pages of instructions but got
hung up on page 2. I enter'd formula =A2*$H$1+$F$1 in B2 and
=NORMDIST(B2,$F$1,$H$1,FALSE) in C2. Instructions said to copy the B2:C2
range down to cover all rows with data in column A. So I selected B2 and
dragged to C2 and then copied down to the last row containing numbers in
Column A. After copying the range down and releasing my mouse, I see 0's in
column B and '#NAME!' in column C. What might I have done wrong? Should
"Mean" be in E1 and Std.Dev be in G1 now?
NOTE: If I select cell C2 with =NORMDIST(B2,$F$1,$H$1,FALSE) in it, a
caution sign appears in B2 with the zero.
Seems I can't even get to first base on this.

I welcome your help.


Trying to get in on

 

[David Biddulph]

Firstly, what values do you have for F1 and H1?
Secondly, what values do you have for A2, A3, and so on?
Thirdly, you say you got 0 and #NAME! in columns B and C respectively after
copying down; what results did you have in B2 and C2 *before* you copied
down the column?
Fourthly, are you sure that column C is returning #NAME! and not #NUM! ?
If it's giving #NAME! then it sounds as if you've mistyped something. In
general it's safest not to retype, but instead it's better to copy the
formula from where it's been given to you, and paste into the formula bar of
the cell you're using.
The words Mean in E1 and Std.Dev in G1 are merely labels for presentation,
and to tell the user what to put into F1 and H1, so they shouldn't afect the
functioning of the formulae.