FW: Repeated Measures data in spreadsheets

[Darinka Andjelkovic]

Yes, here it is.
Thank you.

Darinka



-----Original Message-----
From: chib...@googlegroups.com [mailto:chib...@googlegroups.com] On Behalf
Of Kevin Donnelly
Sent: Sunday, May 06, 2012 12:15 PM
To: chib...@googlegroups.com
Subject: Re: Repeated Measures data in spreadsheets

Hi Darinka

::::On Sunday 06 May 2012 Darinka Andjelkovic said::::
> I send to Brian one of my output files as an example.

Could you maybe post this to the list? I'd be interested in seeing it.

--
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 chib...@googlegroups.com.
To unsubscribe from this group, send email to
chibolts+u...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/chibolts?hl=en.

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

[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: chib...@googlegroups.com [mailto:chib...@googlegroups.com] On Behalf
Of Kevin Donnelly
Sent: Sunday, May 06, 2012 1:41 PM
To: chib...@googlegroups.com