software

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.

heya,

Can you please be more specific to what you are actually intending?
--
Jeroen van Nieuwkerk

quot;ctm59quot; wrote:

gt; Is there any way to randomly assign experimental subjects to one of 4
gt; treatment groups using Excel program? (I have the added software called
gt; analyse-it, too.
gt; 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!

quot;Jeroenquot; wrote:

gt; heya,
gt;
gt; Can you please be more specific to what you are actually intending?
gt; --
gt; Jeroen van Nieuwkerk
gt;
gt;
gt;
gt;
gt; quot;ctm59quot; wrote:
gt;
gt; gt; Is there any way to randomly assign experimental subjects to one of 4
gt; gt; treatment groups using Excel program? (I have the added software called
gt; gt; analyse-it, too.
gt; gt; Can't seem to figure out if this is possible with Excel.

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 Ogilvyquot;ctm59quot; gt; wrote in message
...
gt; Hi,
gt;
gt; An example of what I'm trying to do is to take a group of experimental
gt; subjects, which I have numbered from 1-20, and assign them randomly to one
of
gt; 4 treatment groups. I can do this with SAS, but I want to be able to do
this
gt; within Excel, if it's possible, because I'd REALLY like to get away from
SAS.
gt; Do you know how to do this?
gt; thanks!
gt;
gt; quot;Jeroenquot; wrote:
gt;
gt; gt; heya,
gt; gt;
gt; gt; Can you please be more specific to what you are actually intending?
gt; gt; --
gt; gt; Jeroen van Nieuwkerk
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;ctm59quot; wrote:
gt; gt;
gt; gt; gt; Is there any way to randomly assign experimental subjects to one of 4
gt; gt; gt; treatment groups using Excel program? (I have the added software
called
gt; gt; gt; analyse-it, too.
gt; gt; gt; Can't seem to figure out if this is possible with Excel.
Thank you so much, Tom! That worked perfectly.
Fantastic!
C

quot;Tom Ogilvyquot; wrote:

gt; assume the list is in A1 to A20
gt;
gt; in B1 enter
gt; =rand()
gt; then drag fill down to B20, sort A1:B20 using column B as key 1.
gt;
gt; take A1:A5 for group1, A6:A10 for group2 and so forth.
gt;
gt; --
gt; Regards,
gt; Tom Ogilvy
gt;
gt;
gt; quot;ctm59quot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt;
gt; gt; An example of what I'm trying to do is to take a group of experimental
gt; gt; subjects, which I have numbered from 1-20, and assign them randomly to one
gt; of
gt; gt; 4 treatment groups. I can do this with SAS, but I want to be able to do
gt; this
gt; gt; within Excel, if it's possible, because I'd REALLY like to get away from
gt; SAS.
gt; gt; Do you know how to do this?
gt; gt; thanks!
gt; gt;
gt; gt; quot;Jeroenquot; wrote:
gt; gt;
gt; gt; gt; heya,
gt; gt; gt;
gt; gt; gt; Can you please be more specific to what you are actually intending?
gt; gt; gt; --
gt; gt; gt; Jeroen van Nieuwkerk
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;ctm59quot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Is there any way to randomly assign experimental subjects to one of 4
gt; gt; gt; gt; treatment groups using Excel program? (I have the added software
gt; called
gt; gt; gt; gt; analyse-it, too.
gt; gt; gt; gt; Can't seem to figure out if this is possible with Excel.
gt;
gt;
gt;