Hi Rosie
You are best off using Excel to calculate the means you want, transposing
it there, and then moving it into SPSS. The SPSS restructure command is
useful to reorganize values that you already have, but to my knowledge it
can't compute new variables at the same time. (The other way to do it
would be to use restructure to transpose your data set in SPSS and then
compute new variables in SPSS, but Excel seems better suited to me for
performing these sort of functions.)
Hope that helps.
Nick
Today 12:09am, Automatic digest processor wrote:
> There is one message totalling 323 lines in this issue.
>
> Topics of the day:
>
> 1. SPSS question: restructuring data
>
> ----------------------------------------------------------------------
>
> Date: Tue, 12 Apr 2005 11:00:15 +0100
> From: Rosie McEachan <[log in to unmask]>
> Subject: SPSS question: restructuring data
>
> This is a multi-part message in MIME format.
>
> ------_=_NextPart_001_01C53F46.6C7E4718
> Content-Type: text/plain;
> charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
>
> Hi there,
> =20
> I was wondering if anyone could help me save some time! I have recently
> distributed a questionnaire that asked respondents to rate a particular
> health behaviour on 27 items. I varied the health behaviour that
> respondents were rating randomly, so some people would rate physical
> activity, some binge drinking etc. I have a coding variable in my
> dataset that tells me which behaviour people were rating. In total I
> have 305 replies, and these are spread out amongst 24 health behaviours.
> I now need to create a new 'matrix' dataset to calculate proximities and
> perform cluster analyses etc. My new dataset would have the 24
> behaviours down the side (e.g. as 'cases'), and the items across the
> top. Thus each cell would need to contain the mean score for all
> respondents replying to a particular item on the same behaviour (e.g.
> the mean for the 15 respondents who rated physical activity, the mean
> for the 11 respondents who rated binge drinking etc).
> =20
> Is there any quick way I can restructure this data without have to
> manually input all the mean scores? I have already tried messing about
> with the restructure wizard in SPSS but I could not get it to
> restructure with the mean scores. Any advice would be gratefully
> appreciated!
> =20
> Thanks
> Rosie
> =20
> Rosie McEachan
> Research Student
> Institute of Psychological Sciences
> University of Leeds
> Tel: 0113 343 6692
> (internal ext 36692)
> Fax: 0113 343 5749
> =20
>
> ------_=_NextPart_001_01C53F46.6C7E4718
> Content-Type: text/html;
> charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
>
> <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
> xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
> xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
> xmlns=3D"http://www.w3.org/TR/REC-html40">
>
> <head>
> <meta http-equiv=3DContent-Type content=3D"text/html; =
> charset=3Dus-ascii">
> <meta name=3DProgId content=3DWord.Document>
> <meta name=3DGenerator content=3D"Microsoft Word 10">
> <meta name=3DOriginator content=3D"Microsoft Word 10">
> <link rel=3DFile-List href=3D"cid:filelist.xml@01C53F4E.CE47AD10">
> <o:SmartTagType =
> namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
> name=3D"PlaceName"/>
> <o:SmartTagType =
> namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
> name=3D"PlaceType"/>
> <o:SmartTagType =
> namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
> name=3D"place"/>
> <o:SmartTagType =
> namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
> name=3D"PersonName"/>
> <!--[if gte mso 9]><xml>
> <o:OfficeDocumentSettings>
> <o:DoNotRelyOnCSS/>
> </o:OfficeDocumentSettings>
> </xml><![endif]--><!--[if gte mso 9]><xml>
> <w:WordDocument>
> <w:SpellingState>Clean</w:SpellingState>
> <w:GrammarState>Clean</w:GrammarState>
> <w:DocumentKind>DocumentEmail</w:DocumentKind>
> <w:EnvelopeVis/>
> <w:DrawingGridHorizontalSpacing>6 pt</w:DrawingGridHorizontalSpacing>
> <w:DrawingGridVerticalSpacing>8.15 pt</w:DrawingGridVerticalSpacing>
> =
> <w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEve=
> ry>
> =
> <w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery>
> <w:Compatibility>
> <w:BreakWrappedTables/>
> <w:SnapToGridInCell/>
> <w:WrapTextWithPunct/>
> <w:UseAsianBreakRules/>
> </w:Compatibility>
> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
> </w:WordDocument>
> </xml><![endif]--><!--[if !mso]>
> <style>
> st1\:*{behavior:url(#default#ieooui) }
> </style>
> <![endif]-->
> <style>
> <!--
> /* Font Definitions */
> @font-face
> {font-family:"Century Gothic";
> panose-1:2 11 5 2 2 2 2 2 2 4;
> mso-font-charset:0;
> mso-generic-font-family:swiss;
> mso-font-pitch:variable;
> mso-font-signature:647 0 0 0 159 0;}
> /* Style Definitions */
> p.MsoNormal, li.MsoNormal, div.MsoNormal
> {mso-style-parent:"";
> margin:0cm;
> margin-bottom:.0001pt;
> mso-pagination:widow-orphan;
> font-size:12.0pt;
> font-family:"Times New Roman";
> mso-fareast-font-family:"Times New Roman";
> mso-ansi-language:EN-GB;}
> a:link, span.MsoHyperlink
> {color:blue;
> text-decoration:underline;
> text-underline:single;}
> a:visited, span.MsoHyperlinkFollowed
> {color:purple;
> text-decoration:underline;
> text-underline:single;}
> span.EmailStyle17
> {mso-style-type:personal-compose;
> mso-style-noshow:yes;
> mso-ansi-font-size:10.0pt;
> mso-bidi-font-size:10.0pt;
> font-family:Arial;
> mso-ascii-font-family:Arial;
> mso-hansi-font-family:Arial;
> mso-bidi-font-family:Arial;
> color:windowtext;}
> span.SpellE
> {mso-style-name:"";
> mso-spl-e:yes;}
> @page Section1
> {size:612.0pt 792.0pt;
> margin:72.0pt 89.85pt 72.0pt 89.85pt;
> mso-header-margin:36.0pt;
> mso-footer-margin:36.0pt;
> mso-title-page:yes;
> mso-paper-source:0;}
> div.Section1
> {page:Section1;}
> -->
> </style>
> <!--[if gte mso 10]>
> <style>
> /* Style Definitions */=20
> table.MsoNormalTable
> {mso-style-name:"Table Normal";
> mso-tstyle-rowband-size:0;
> mso-tstyle-colband-size:0;
> mso-style-noshow:yes;
> mso-style-parent:"";
> mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
> mso-para-margin:0cm;
> mso-para-margin-bottom:.0001pt;
> mso-pagination:widow-orphan;
> font-size:10.0pt;
> font-family:"Times New Roman";}
> </style>
> <![endif]-->
> </head>
>
> <body lang=3DEN-US link=3Dblue vlink=3Dpurple =
> style=3D'tab-interval:36.0pt'>
>
> <div class=3DSection1>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
> style=3D'font-size:
> 10.0pt;font-family:Arial'>Hi there,<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
> style=3D'font-size:
> 10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
> style=3D'font-size:
> 10.0pt;font-family:Arial'>I was wondering if anyone could help me save =
> some
> time! I have recently distributed a questionnaire that asked respondents =
> to
> rate a particular health behaviour on 27 items. I varied the health =
> behaviour
> that respondents were rating randomly, so some people would rate =
> physical
> activity, some binge drinking etc. I have a coding variable in my =
> dataset that tells
> me which behaviour people were rating. In total I have 305 replies, and =
> these
> are spread out amongst 24 health behaviours. I now need to create a new =
> ‘matrix’
> dataset to calculate proximities and perform cluster analyses etc. My =
> new
> dataset would have the 24 behaviours down the side (e.g. as =
> ‘cases’),
> and the items across the top. Thus each cell would need to contain the =
> mean
> score for all respondents replying to a particular item on the same =
> behaviour
> (e.g. the mean for the 15 respondents who rated physical activity, the =
> mean for
> the 11 respondents who rated binge drinking =
> etc).<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
> style=3D'font-size:
> 10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
> style=3D'font-size:
> 10.0pt;font-family:Arial'>Is there any quick way I can restructure this =
> data
> without have to manually input all the mean scores? I have already tried
> messing about with the restructure wizard in SPSS but I could not get it =
> to
> restructure with the mean scores. Any advice would be gratefully =
> appreciated!<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
> style=3D'font-size:
> 10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
> style=3D'font-size:
> 10.0pt;font-family:Arial'>Thanks<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
> style=3D'font-size:
> 10.0pt;font-family:Arial'>Rosie<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
> style=3D'font-size:
> 10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
>
> <p class=3DMsoNormal><st1:PersonName><font size=3D2 color=3Dpurple
> face=3D"Century Gothic"><span lang=3DEN-GB =
> style=3D'font-size:10.0pt;font-family:
> "Century Gothic";color:purple;mso-no-proof:yes'>Rosie =
> McEachan</span></font></st1:PersonName><span
> lang=3DEN-GB style=3D'mso-no-proof:yes'><o:p></o:p></span></p>
>
> <p class=3DMsoNormal><font size=3D2 color=3Dpurple face=3D"Century =
> Gothic"><span
> lang=3DEN-GB style=3D'font-size:10.0pt;font-family:"Century =
> Gothic";color:purple;
> mso-no-proof:yes'>Research Student</span></font><span lang=3DEN-GB
> style=3D'mso-no-proof:yes'><o:p></o:p></span></p>
>
> <p class=3DMsoNormal><font size=3D2 color=3Dpurple face=3D"Century =
> Gothic"><span
> lang=3DEN-GB style=3D'font-size:10.0pt;font-family:"Century =
> Gothic";color:purple;
> mso-no-proof:yes'>Institute of Psychological Sciences</span></font><span
> lang=3DEN-GB style=3D'mso-no-proof:yes'><o:p></o:p></span></p>
>
> <p class=3DMsoNormal><st1:place><st1:PlaceType><font size=3D2 =
> color=3Dpurple
> face=3D"Century Gothic"><span lang=3DEN-GB =
> style=3D'font-size:10.0pt;font-family:
> "Century =
> Gothic";color:purple;mso-no-proof:yes'>University</span></font></st1:Plac=
> eType><font
> size=3D2 color=3Dpurple face=3D"Century Gothic"><span lang=3DEN-GB =
> style=3D'font-size:
> 10.0pt;font-family:"Century Gothic";color:purple;mso-no-proof:yes'> of =
> </span></font><st1:PlaceName><font
> size=3D2 color=3Dpurple face=3D"Century Gothic"><span lang=3DEN-GB =
> style=3D'font-size:
> 10.0pt;font-family:"Century =
> Gothic";color:purple;mso-no-proof:yes'>Leeds</span></font></st1:PlaceName=
> ></st1:place><span
> lang=3DEN-GB style=3D'mso-no-proof:yes'><o:p></o:p></span></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3D"Century Gothic"><span =
> lang=3DEN-GB
> style=3D'font-size:10.0pt;font-family:"Century =
> Gothic";mso-no-proof:yes'>Tel:
> 0113 343 6692</span></font><span lang=3DEN-GB =
> style=3D'mso-no-proof:yes'><o:p></o:p></span></p>
>
> <p class=3DMsoNormal><em><i><font size=3D2 face=3D"Century Gothic"><span =
> lang=3DEN-GB
> style=3D'font-size:10.0pt;font-family:"Century =
> Gothic";mso-no-proof:yes'>(internal
> ext 36692)</span></font></i></em><span lang=3DEN-GB =
> style=3D'mso-no-proof:yes'><o:p></o:p></span></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3D"Century Gothic"><span =
> lang=3DEN-GB
> style=3D'font-size:10.0pt;font-family:"Century =
> Gothic";mso-no-proof:yes'>Fax:
> 0113 343 5749</span></font><span lang=3DEN-GB><o:p></o:p></span></p>
>
> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
> lang=3DEN-GB
> style=3D'font-size:12.0pt'><o:p> </o:p></span></font></p>
>
> </div>
>
> </body>
>
> </html>
> =00
> ------_=_NextPart_001_01C53F46.6C7E4718--
>
> ------------------------------
>
> End of PSYCH-POSTGRADS Digest - 9 Apr 2005 to 12 Apr 2005 (#2005-32)
> ********************************************************************
>
--
http://www.nicholasgibson.com/
|