FW: Repeated Measures data in spreadsheets

[Kevin Donnelly]

Hi Darinka

::::On Sunday 06 May 2012 Darinka Andjelkovic said::::
> Yes, here it is.

As Brian said, "It all depends on the details of how your data is coded, how 
subjects appear across files, and so on."   The output you want may not be one 
that CLAN should be expected to include, since other researchers may have 
different ways of ordering their data, and it's impossible to handle all use-
cases.

However, if your own files are using consistent naming conventions throughout, 
this is a relatively simple transformation to do programmatically.  Myself, I 
would read the file into a database table, and then use a script to split the 
name into person and month components, and write out the person-month figures 
per person per month into a new csv file.  But there are other ways of doing 
this transformation - for instance, the popular stats language R 
(http://www.r-project.org), and it would do your analysis too.

Whether this is worthwhile for you depends on how much analysis you have to 
do.  If you're working with a lot of data and/or files, or repeating analyses 
periodically, it would probably save time to install and use some additional 
software, but you may not want the additional learning curve associated with 
that.

So the first thing is to wait for Brian's decision on whether this 
transformation should fall within the ambit of CLAN or not.

-- 
Pob hwyl / Best wishes

Kevin Donnelly
kevindonnelly.org.uk

-- 
You received this message because you are subscribed to the Google Groups "chibolts" group.
To post to this group, send email to chibolts at googlegroups.com.
To unsubscribe from this group, send email to chibolts+unsubscribe at googlegroups.com.
For more options, visit this group at http://groups.google.com/group/chibolts?hl=en.