Projecting a standard distribution

[hmeen]

Fro a model I'm building, I need to take a target sum (in dollars) and
project receipts over a 12-month period, assuming at first that the
rate of receipt will look something like a bell curve.

I'm hoping Excel has a function that would work like this:

=FUNCTION(n, x), where n is the number of units (along the horizonatal
axis, in this case months) and x is the number (to be distributed in
the curve, in this case dollars). For =FUNCTION (12, 400), it would
ideally return an answer like:

1 10
2 20
3 30
4 35
5 45
6 60
7 60
8 45
9 35
10 30
11 20
12 10

I'm hoping that I can then use a function (either a different one or
the same one with other parameters) to skew the cure either left or
right.

I can't be the only one who needs to do this kind of thing.

Thanks for your advice.

Bob

 

[CyberTaz]

I'm no statistician, but have you taken a look at the Statistical Function
category? If not, click the Paste Function (fx) button, select Statistical,
& go through the list. If you still can't find what you need, go to
Tools>Add-Ins, select Analysis ToolPack. Once you click OK, go back to
Tools>Data Analysis and examine the new features available to you.

HTH |:>)