How do I create a bell curve?

  • Thread starter Thread starter A little stuck
  • Start date Start date
A

A little stuck

I'd like to create a bell curve with certain values to be distributed over a
certain period of time. How do I do this?

Any help would be much appreciated.
 
A wrote on Thu, 10 Sep 2009 20:48:01 -0700:
I'd like to create a bell curve with certain values to be
distributed over a certain period of time. How do I do this?
Click to expand...
Any help would be much appreciated.
Click to expand...

Was it not suggested a week ago that you formulate the same question
more precisely, tho' David Bidduph's suggestion on NORMDIST should be
checked

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not
 
Thank you guys.

To be more precise:
Say I have a budget of 4,200,000 to distribute over one financial year. I'd
like to create a bell curve, which would split this value relatively evenly
over the 12 months (using whichever formula the bell curve needs so that the
distribution is slightly skewed towrds the positive x values). The purpose is
to have a nice graphical representation of the approximate distribution - the
values do not need to be exact).
 
Thanks guys.

To be more precise:
Say I had a budget of 4,200,000 to be distributed over the 12 months of a
financial year. I'd like to create a bell curve as a graphical representation
of the financial distribution over this time, using whatever formula needed
to create a normal looking bell curve (but slightly skewed towards the
positive values on the x axis). Thus, the values don't have to be exact, so
long as the overall budget amount is correct, and the bell curve appears as
described above.

I'm not sure how to do create this bell curve.

Any ideas?

Thanks!
 
A wrote on Sun, 13 Sep 2009 19:15:01 -0700:
To be more precise:
Say I have a budget of 4,200,000 to distribute over one
financial year. I'd like to create a bell curve, which would
split this value relatively evenly over the 12 months (using
whichever formula the bell curve needs so that the
distribution is slightly skewed towrds the positive x values).
The purpose is to have a nice graphical representation of the
approximate distribution - the values do not need to be
exact).
Click to expand...
"James Silverton" wrote:
Click to expand...

If you don't want an exact normal curve, why don't you just hand sketch
a curve, read off the numbers and draw a smooth curve thro' them.

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not
 
Thanks to all of you.
I am trying to use the NORMDIST function to create my bell curve, and am
putting the following values into a table:
84000
126000
210000
252000
294000
336000
378000
420000
462000
504000
546000
588000
However, the function is returning '0' for all of them. Eg. for the first
value I entered: =NORMDIST(B79, 350000, 1.5, TRUE), then: =NORMDIST(B80,
350000, 1.5, TRUE) for the second value etc. What am I doing wrong?
 
Back
Top