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
..
.
.:.
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
> >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,
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
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