Date: Wed, 22 Sep 2010 08:37:29 -0600
Reply-To: ViAnn Beadle <vab88011@gmail.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: ViAnn Beadle <vab88011@gmail.com>
Subject: Re: Proper way to combining 2 rating variables into 1
In-Reply-To: <E65C1D74FC814B219584E50FC91111AD@yourg2asvv4l2m>
Content-Type: multipart/alternative;
This syntax will not run because the compute is wrong.
But I'm not sure what you mean by 2 questions are supposed to be 1. Can you
be more specific as to what the two variables, var1 and var2, represent.
Various ways of combining could be adding, taking the max, or taking the
min. Also, how do you want missing values for either variable to be handled
in the computation.
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
John F Hall
Sent: Wednesday, September 22, 2010 7:04 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: Proper way to combining 2 rating variables into 1
Probably, but will this do?
compute (newvar + var1 + var2) /2) .
freq var1 var2 newvar / sta mea .
----- Original Message -----
From: DorraJ Oet <mailto:love_u_endlessly@hotmail.com>
To: SPSSX-L@LISTSERV.UGA.EDU
Sent: Wednesday, September 22, 2010 11:50 AM
Subject: Proper way to combining 2 rating variables into 1
Hi,
Currently I am having an issue with 2 of my rating variables.
I am having 2 rating variables of value 1-6 however, these 2 questions are
supposed to be 1 question due to wrong questionnaire design by my colleague.
Is there a way to combine these 2 rating variables because ultimately, I
will like to find the mean. The following is the mockup of my data file.
var1 var2
1 1
2 4
3 5
1 6
5 6
5 1
These 2 variables have to be combined into 1 so that I can find the mean of
this final variable.
My personal idea was to sum these 2 variables up, divided by 2, and
calculate the mean based on this newly created variable. Is this a wrong
approach?
Thanks for any advice on this matter.
Regards
Dorraj Oet
[text/html]
