<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 2.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=SR link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US>Dear colleagues,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>I have tried the command that Leonid </span>recently <span lang=EN-US>made for </span>Joyce Marzan for the purpose of rotating CLAN spreadsheet output on its side, turning columns into row and vice versa:<o:p></o:p></p><p class=MsoNormal>spreadsheet stat.frq.xls<o:p></o:p></p><p class=MsoNormal>and it works perfectly.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> But my question is about possibility to use this device for the preparation of data file for further statistical analysis.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>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.<o:p></o:p></p><p class=MsoNormal>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:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> utter18m utter19m utter20m morph18m morph19m morphs20m <o:p></o:p></p><p class=MsoNormal>Peter<o:p></o:p></p><p class=MsoNormal>Mary<o:p></o:p></p><p class=MsoNormal>John<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>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.<o:p></o:p></p><p class=MsoNormal>It is rather slow, and very susseptable for making errors, especialy for a large quantity of data. <span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>How do you handle this? <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Maybe a Macro would work, but I do not know how to make it. Is there any available around, that I could use?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Any suggestion would be most appreciated.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Best wishes,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Darinka Andjelkovic<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p></div></body></html>
<p></p>
-- <br />
You received this message because you are subscribed to the Google Groups "chibolts" group.<br />
To post to this group, send email to chibolts@googlegroups.com.<br />
To unsubscribe from this group, send email to chibolts+unsubscribe@googlegroups.com.<br />
For more options, visit this group at http://groups.google.com/group/chibolts?hl=en.<br />