D
Dream
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
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