"DSpec" wrote:
"Myrna Larson" wrote:
The occurrence of duplicates does NOT mean the numbers are not selected
randomly. If you are drawing *with replacement*, duplicates are possible.

What does drawing "with repalcement" mean? What should I be looking for?

Based on the decription of your problem, the comment about
"with replacement" seems to be irrelevant. You are talking
about the entire sequence of random numbers (or values
derived from them) being repeatable each time you enter the
worksheet, not merely a repeat appearance of some values in
the sequence.

But to answer your remedial question, in order to understand with
and without replacement, image drawing from a deck of cards.
If you close your eyes and draw from somewhere in the middle of
the deck, that is a "random selection". If you draw multiple cards
and put them aside, that is "random selection without replacement".
If instead you return the card to the deck after each selection, that
is "random selection with replacement", assuming that you return
the card to a "random" location in the deck or you shuffle the deck
between each draw.

If you still do not understand, don't worry about it -- or move this
digression to another thread. It seems to have nothing to do with
your problem.