Re: Excel for simulating normal distribution

2001-08-28 Thread Dennis Roberts
plus ... many good REAL stat packages do this so easily MTB > rand 5000 c1; SUBC> norm 100 10. < mean and sigma MTB > dotp c1 Dotplot: C1 .. . .:.

Re: Excel for simulating normal distribution

2001-08-28 Thread DELOMBA
Please do NOT rely on Excel random number generator. It is an old one and is not powerful at all (1 000 000 numbers). Efficient routines can be found at the Cern. Y. There are "David Winsemius" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I quite agree wit

Re: Excel for simulating normal distribution

2001-07-30 Thread B. D. McCullough
> >package. However, if you want a start, and feel that Excel is familiar > >ground, here goes. The rand() function will generate random numbers from a > >uniform distribution on the interval [0,1]. You can convert that to a > >randomly distributed set of numbers using the inverse normal function,

Re: Excel for simulating normal distribution

2001-07-29 Thread dennis roberts
again ... in something like minitab ... MTB > rand 1 c1; command is random ... say how many ... and where to put them SUBC> norm 50 10. ... the subc just tells minitab what distribution to sample from ... from dozens that's all there is to it THEN ... you can do what you want with the

Re: Excel for simulating normal distribution

2001-07-29 Thread David Winsemius
I quite agree with those who said it would be easier in a real stats package. However, if you want a start, and feel that Excel is familiar ground, here goes. The rand() function will generate random numbers from a uniform distribution on the interval [0,1]. You can convert that to a randomly dist