Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Bell Curve
Is there a formula that will calculate a bell curve?
|
#2
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating bell curve in excel | Charts and Charting in Excel | |||
Fit bell curve to histogram | Charts and Charting in Excel | |||
Can you plot individual numbers on a bell curve in excel, and how. | Excel Discussion (Misc queries) | |||
HOW DO I SHADE AN AREA ON A BELL CURVE? | Charts and Charting in Excel | |||
Charting a skewed bell curve | Charts and Charting in Excel |