Roy,

For a normal distribution,

=NORMINV(RAND(),mean,standard deviation)

Copy this down for 100 cells.

Eric


"roy" wrote:

I need to sample 100 numbers out of a specified distribution (normal or
other). So basically I know the parameters, and I need Execl to sample 100
numbers. How do I do it?