#1   Report Post  
Todd Nelson
 
Posts: n/a
Default Bell Curve

Is there a formula that will calculate a bell curve?
  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

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

Jerry

"Todd Nelson" wrote:

Is there a formula that will calculate a bell curve?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Bell Curve

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
"Jerry W. Lewis" wrote:

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

Jerry

"Todd Nelson" wrote:

Is there a formula that will calculate a bell curve?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Bell Curve

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.
--
David Biddulph

"soon-to-retire-teacher"
wrote in message ...
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
"Jerry W. Lewis" wrote:

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

Jerry

"Todd Nelson" wrote:

Is there a formula that will calculate a bell curve?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating bell curve in excel Lukedug Charts and Charting in Excel 2 April 22nd 23 08:08 AM
Fit bell curve to histogram cwinters Charts and Charting in Excel 1 June 14th 05 02:03 AM
Can you plot individual numbers on a bell curve in excel, and how. RJC Excel Discussion (Misc queries) 1 February 28th 05 10:07 PM
HOW DO I SHADE AN AREA ON A BELL CURVE? jeanne Charts and Charting in Excel 2 January 30th 05 10:29 PM
Charting a skewed bell curve Remeez Charts and Charting in Excel 2 December 22nd 04 12:47 PM


All times are GMT +1. The time now is 11:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"