Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
random assignment of subjects to treatment groupw
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
random assignment of subjects to treatment groupw
heya,
Can you please be more specific to what you are actually intending? -- Jeroen van Nieuwkerk "ctm59" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
random assignment of subjects to treatment groupw
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! "Jeroen" wrote: heya, Can you please be more specific to what you are actually intending? -- Jeroen van Nieuwkerk "ctm59" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
random assignment of subjects to treatment groupw
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. -- Regards, Tom Ogilvy "ctm59" wrote in message ... 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! "Jeroen" wrote: heya, Can you please be more specific to what you are actually intending? -- Jeroen van Nieuwkerk "ctm59" wrote: 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
random assignment of subjects to treatment groupw
Thank you so much, Tom! That worked perfectly.
Fantastic! C "Tom Ogilvy" wrote: 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. -- Regards, Tom Ogilvy "ctm59" wrote in message ... 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! "Jeroen" wrote: heya, Can you please be more specific to what you are actually intending? -- Jeroen van Nieuwkerk "ctm59" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Random Sampling | Excel Discussion (Misc queries) | |||
VBA "Rnd" Function: Truly Random? | Excel Discussion (Misc queries) | |||
Random Assignment of Numbers | Excel Worksheet Functions |