random assignment of subjects to treatment groupw

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

Guest

Is there any way to randomly assign experimental subjects to one of 4
treatment groups using Excel program? (I have the added software called
analyse-it, too.
Can't seem to figure out if this is possible with Excel.
 
Hi,

An example of what I'm trying to do is to take a group of experimental
subjects, which I have numbered from 1-20, and assign them randomly to one of
4 treatment groups. I can do this with SAS, but I want to be able to do this
within Excel, if it's possible, because I'd REALLY like to get away from SAS.
Do you know how to do this?
thanks!
 
assume the list is in A1 to A20

in B1 enter
=rand()
then drag fill down to B20, sort A1:B20 using column B as key 1.

take A1:A5 for group1, A6:A10 for group2 and so forth.
 

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

Randomly assigning Data 1
Chupacabra treatment 1
Auto-Assigning a (random) Name from list of values 2
How do I generate non-recurring random numbers to assign groups? 1
sum items in a column based on criteria located in other columns 1
Sewage treatment for teric benarma 3
Idea to use Excel for Random Assignment 2
Pivot Table Formats not maintained? 2

Back
Top