Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2006

Tip: Looking for answers? Try searching our database.

Evenly, yet randomly, distributing cells

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
laurenatlas@gmail.com - 05 Dec 2006 20:36 GMT
Hi,

I'm trying to design a neuroimaging task in which I have 6 runs of 8
trials (2 presentations of 4 stimuli: A,B,C,D) each. I'm setting up my
design matrix using excel, with runs in six columns and trials in eight
rows.

In my first column, I need to constrain the first two rows to either A
or B.  Other than this, I'd like to randomly present two of each item
in each column.  I was going to stop here, and just use a RAND function
to pair with and sort each of the 6 columns.  However, I just learned
that I need to also take into account possible order effects, and make
sure that across the columns, I make sure each condition appears at
least once. I have NO idea how to set up a function in excel that can
ensure both of these parameters... Does anyone have any idea how to do
this?  I've tried to search across this forum, but I'm having a hard
time finding it with proper search terms.

Thank you for any help you can offer!

Lauren

PS. I also have access to matlab, if that would help me at all...
laurenatlas@gmail.com - 05 Dec 2006 21:29 GMT
Sorry, I should clarify... I mean that within each row, I need to make
sure all 4 conditions appear. Within each column, I need to make sure 2
of each condition appears. Does that make it clearer?

Thanks!
Lauren

> Hi,
>
[quoted text clipped - 19 lines]
>
> PS. I also have access to matlab, if that would help me at all...
Jim Cone - 06 Dec 2006 04:12 GMT
Lauren,
Your problem got my interest.
I am not sure how the first two rows fit in with
your minimum occurrence requirement.
In any case I put together a single sheet workbook using
VBA and formulas that puts random pairs on the
8 row x 6 column grid that meets the minimums.
If you would like a copy let me know.
Remove XXX from my email address.
jim.coneXXX@rcn.comXXX
Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

<laurenatlas@gmail.com>
wrote in message
Sorry, I should clarify... I mean that within each row, I need to make
sure all 4 conditions appear. Within each column, I need to make sure 2
of each condition appears. Does that make it clearer?
Thanks!
Lauren

> Hi,
> I'm trying to design a neuroimaging task in which I have 6 runs of 8
[quoted text clipped - 16 lines]
> Lauren
> PS. I also have access to matlab, if that would help me at all...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.