FW: Repeated Measures data in spreadsheets

[Darinka Andjelkovic]

Dear Kevin,

I am fully aware that this might not be needed by other researchers too.
This is why I addressed this question to chibolts and not only to Brian and
Leonid. I wanted to see how many people face with this problem and how they
handle it.

Thanks for reminding me about R. I had used it for one project couple of
years ago, but I must admit I did not find it user-friendly, I spent much
time in learning. But I might try my luck on it again... Or, just edit data
as you suggested.

Thanks for help in sorting things out.

Warm regards,

Darinka Andjelkovic




-----Original Message-----
From: chibolts at googlegroups.com [mailto:chibolts at googlegroups.com] On Behalf
Of Kevin Donnelly
Sent: Sunday, May 06, 2012 1:41 PM
To: chibolts at googlegroups.com
Subject: Re: FW: Repeated Measures data in spreadsheets

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.


-- 
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.