Repeated Measures data in spreadsheets

[Darinka Andjelkovic]

Dear colleagues,

 

I have tried the command that Leonid recently made for Joyce Marzan for the
purpose of rotating CLAN spreadsheet output on its side, turning columns
into row and vice versa:

spreadsheet stat.frq.xls

and it works perfectly.

 

But my question is about  possibility to use this device for the preparation
of data file for further statistical analysis.

 

In most studies of language development one would look for one or more
measures (let's say number of utterances or morphemes) at different age
samples for the same child.

And, for the statistical reasons we have to treat this as a Repeated
Measures design for different age levels. So, working for example in SPSS,
we have to sort age samples into different columns like all other variables
(utterances, morphemes, etc.), while participants should be sorted in rows
like this:

 

                utter18m    utter19m   utter20m  morph18m   morph19m
morphs20m 

Peter

Mary

John

 

I do not see any other way of preparation of Excel data into that kind of
sort,  except for manual cutting rows and pasting them into collumns by
means of PasteSpecial/Transpose.

It is rather slow, and very susseptable for making errors, especialy for a
large quantity of data. 

 

How do you handle this? 

Maybe a Macro would work, but I do not know how to make it. Is there any
available around, that I could use?

 

Any suggestion would be most appreciated.

 

Best wishes,

 

Darinka Andjelkovic

 

 

 

 

 

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listserv.linguistlist.org/pipermail/chibolts/attachments/20120505/76c924cb/attachment.htm>