```Date: Wed, 22 Sep 2010 08:37:29 -0600 Reply-To: ViAnn Beadle Sender: "SPSSX(r) Discussion" From: ViAnn Beadle Subject: Re: Proper way to combining 2 rating variables into 1 Comments: To: John F Hall In-Reply-To: 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 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] ```

Back to: Top of message | Previous page | Main SPSSX-L page