>Peter:
>
>Looks like you've got it "sussed".
Thank you! I also had to sus out what 'sussed' means :).
>I see that Excel's "Descriptive Statistics"can generate a normal distribution of numbers over a given output range of cells.
I hope that this thread will be helpful to others too, at some point in the future.
It was nice 'talking' to you.
BTW. Here's the formula that will generate 1000 somewhat normally distributed values between 4 and S*4.
S = 6
for n = 1 to 1000
V = CEIL( S * RAND() ) + CEIL( S * RAND() ) + CEIL( S * RAND() ) + CEIL( S * RAND() )
insert into (sometable) value ( V )
next
Each CEIL( S * RAND() ) produces an integer 1-6, like when throwing a dice.
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.