the numbers you have psted are not consistent with any distribution. check
your souce for the numbers.

I think you havve polynomial distribution. Which is representative of

a(0)x^0 + a(1)x^1 + a(2)x^2

where the coifficents arre reprresented as
N!/(R!-R)!

Normally you wll see a table like this where x = 1

1
1 1
1 2 1
1 3 3 1
1 4 6 4 1
1 5 10 10 5 1

You can get this table in excel by using the following formula in cell A1

=FACT(ROW())/(FACT(COLUMN()-1)*FACT(ROW()-COLUMN()+1))

Then copy the formula to

A2 and B2
A3, B3, and C3
A4, B4, C4, and D4

Now instead of using x = 1 use x = .5. Put the following in cell A1 and
copy to the same cells as above

=(0.5^ROW())*FACT(ROW())/(FACT(COLUMN()-1)*FACT(ROW()-COLUMN()+1))

You can change x to any value you want.

"Dream" wrote:

Hi all,
I have ratios that i got from a reference for the normal distribution, where
they can be used to generate the normal distribution....depending on the
duration...for example..please note that the sum of the ratios always equals
to 1...and that the ratios are symmetrical when the duration is odd number,,
and has 2 middle identical values when the duration if even number...

duration ratios
3 0.30 0.40 0.30
4 0.20 0.30 0.30 0.20
5 0.15 0.20 0.30 0.20 0.15
6 0.05 0.15 0.30 0.30 0.15 0.05
7 0.05 0.10 0.20 0.30 0.20 0.10 0.05
8 0.05 0.10 0.15 0.20 0.20 0.15 0.10 0.05
9 0.04 0.07 0.12 0.16 0.22 0.16 0.12 0.07 0.04
..and so forth...i have it until 24
24 0.01 0.01 0.02 0.02 0.03 0.04 0.05 0.06 0.06 0.07 0.08
0.08 0.07 0.06 0.06 0.05 0.0.5 0.04 0.03 0.02 0.02 0.01 0.01

now my questions, is i want to extend this..to durations longer than
24..such as 25, 26, all the way until...50....how can i do that in excel to
make it generate the ratios for me?

thank you in advacne