can you assign random numbers to many different lines of row?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to assign random numbers to my population; one random number to
one sample. The population is recorded in rows in excel. Is there a function?
 
if I do that, some samples may have same random numbers assigned. How do I
make sure that each sample has a different random number assigned to it?
 
=RAND() generates a sequence of numbers that will not repeat for a very long
time. How long depends on your verson, but it is unlikely to impact what you
are doing unless you are rounding the random numbers, in which case you have
not provided enough information.

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random Numbers 2
How to make random numbers stay the same 4
RANDBETWEEN generating numbers outside range 5
Parameters for Random Numbers 1
Random Numbers and Me 4
eliminate negative value from normal random number distribution 4
random between function 8
Random sorting with restrictions 1

Back
Top