Survey Money Data and SPSS

[underpressure]

Hey all, I am a master's student about to send out a survey via Survey Money. However after I did a few trial runs, I've run into a few problems when I exported it to excel/spss. For instance, one of my questions uses a likert sale and I have 10 statements within this question, where a respondent can answer between 1 and 5 (1=strongly disagree, 5=strongly agree). These are all created as new variables in Excel/SPSS and I have no idea how to combine them. I've searched google far and wide and even old posts here, but I cannot follow the intructions.

Equally I have another question or two that lets users tick multiple choices e.g. "have you heard of the following organisations? (Tick all that apply)", so one user might select 3, another 5, etc. The same thing happens here, all new variables.

What should I do?I'm really caught for time and need to figure this out. Any help appreciated!

[John F Hall]

Have a look at http://surveyresearch.weebly.com/51-introduction-to-count-and-compute.html

----- Original Message -----

From: [hidden email]

To: [hidden email]

Sent: Saturday, April 10, 2010 3:25 PM

Subject: Survey Money Data and SPSS

Hey all, I am a master's student about to send out a survey via Survey Money.
However after I did a few trial runs, I've run into a few problems when I
exported it to excel/spss. For instance, one of my questions uses a likert
sale and I have 10 statements within this question, where a respondent can
answer between 1 and 5 (1=strongly disagree, 5=strongly agree). These are
all created as new variables in Excel/SPSS and I have no idea how to combine
them. I've searched google far and wide and even old posts here, but I
cannot follow the intructions.

Equally I have another question or two that lets users tick multiple choices
e.g. "have you heard of the following organisations? (Tick all that apply)",
so one user might select 3, another 5, etc. The same thing happens here, all
new variables.

What should I do?I'm really caught for time and need to figure this out. Any
help appreciated!
--
View this message in context: http://old.nabble.com/Survey-Money-Data-and-SPSS-tp28201969p28201969.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[John F Hall]

Tom

 

I presume you mean Survey Monkey?

 

Following my previous reply (far too short, I was a bit pushed for time) your first query about Likert scale items can be answered if you follow my step-by-step tutorial The COMPUTE command 1 - Attachment to status quo which deals with creating a score for fifth-formers' "attachment to status quo" from a 4-item Likert scale.  The score is generated using syntax, followed by the same example using drop-dwn menus.  There are screenshots at each step, warnings about what you (and SPSS) are doing clearly demonstrates the superiority of syntax over point-and-click. 

 

If your 10 items are supposed to measure the same thing, you can do a quick check by using:

 

corr v1 to v10 .

 

On multiple response see my page:

 

5.10:  Multiple response  Explanation of multiple response questions, examples from real surveys, and exercises in analysis using SPSS command MULT RESPONSE.  It has links to three entries:

1:     Multiple response and SPSS: an introduction

Many questions permit more than one answer.(eg tick as mant as apply).  This document explains different practices in coding such questions and how the data can be analysed using SPSS command MULT RESPONSE to analyse the data.
(Posted 28 Jan 2010)

2:    Multiple response: British Social Attitudes 1986

Examples of multiple response questions in the 1986 British Social Attitudes survey and the different ways in which they have been coded and entered in the raw data.  See also the sample data to get an idea of the content and layout.
(Posted 28 Feb 2010)

3:    First exercise in multiple response

Worked example from the pre-course self-completion questionnaire analysing the multiple response question on previous training in or experience of typing, word-processing, social statistics or other computing.

 

You should also have a look at  Old Dog, Old Tricks (abstract page on my 2006 paper to ASSESS (European SPSS users)  The full paper is on Old Dog, Old Tricks: Using SPSS Syntax to Avoid the Mouse Trap and well worth reading if you're a beginner (or even an experienced SPSS-er). 

 

Section 3 of the paper has a detailed critique of SPSS usage in the 2002 European Social Survey (pp 23 ff) and also has my various mult response solutions (pp 31 - 35) for analysing data from a question on grounds of perceived discrimination.  There's also an accompanying slide-show  SPSS usage in major surveys  for this section.  This was the first time I'd ever used PowerPoint, but it's not too bad the gist is clear.  The screenshots are all from exercises done with SPSS11 (much simpler to read) but the output formats for 15 and 18 have since changed to accommodate pivot tables., so it's more fiddly to get something presentable.

 

Hope this helps

 

Jon Hall

 

----- Original Message -----

From: [hidden email]

To: [hidden email]

Sent: Saturday, April 10, 2010 3:25 PM

Subject: Survey Money Data and SPSS

Hey all, I am a master's student about to send out a survey via Survey Money.
However after I did a few trial runs, I've run into a few problems when I
exported it to excel/spss. For instance, one of my questions uses a likert
sale and I have 10 statements within this question, where a respondent can
answer between 1 and 5 (1=strongly disagree, 5=strongly agree). These are
all created as new variables in Excel/SPSS and I have no idea how to combine
them. I've searched google far and wide and even old posts here, but I
cannot follow the intructions.

Equally I have another question or two that lets users tick multiple choices
e.g. "have you heard of the following organisations? (Tick all that apply)",
so one user might select 3, another 5, etc. The same thing happens here, all
new variables.

What should I do?I'm really caught for time and need to figure this out. Any
help appreciated!
--
View this message in context: http://old.nabble.com/Survey-Money-Data-and-SPSS-tp28201969p28201969.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[John F Hall]

Tom
 
I presume you mean Survey Monkey?
 
Following my previous reply (far too short, I was a bit pushed for time) your first query about Likert scale items can be answered if you follow my step-by-step tutorial The COMPUTE command 1 - Attachment to status quo which deals with creating a score for fifth-formers' "attachment to status quo" from a 4-item Likert scale.  The score is generated using syntax, followed by the same example using drop-dwn menus.  There are screenshots at each step, warnings about what you (and SPSS) are doing clearly demonstrates the superiority of syntax over point-and-click.  
 
If your 10 items are supposed to measure the same thing, you can do a quick check by using:
 
corr v1 to v10 .
 
On multiple response see my page:
 
5.10:  Multiple response  Explanation of multiple response questions, examples from real surveys, and exercises in analysis using SPSS command MULT RESPONSE.  It has links to three entries:
1:     Multiple response and SPSS: an introduction
Many questions permit more than one answer.(eg tick as mant as apply).  This document explains different practices in coding such questions and how the data can be analysed using SPSS command MULT RESPONSE to analyse the data.
(Posted 28 Jan 2010)
2:    Multiple response: British Social Attitudes 1986
Examples of multiple response questions in the 1986 British Social Attitudes survey and the different ways in which they have been coded and entered in the raw data.  See also the sample data to get an idea of the content and layout.
(Posted 28 Feb 2010)

3:    First exercise in multiple response
Worked example from the pre-course self-completion questionnaire analysing the multiple response question on previous training in or experience of typing, word-processing, social statistics or other computing.
 
You should also have a look at  Old Dog, Old Tricks (abstract page on my 2006 paper to ASSESS (European SPSS users)  The full paper is on Old Dog, Old Tricks: Using SPSS Syntax to Avoid the Mouse Trap and well worth reading if you're a beginner (or even an experienced SPSS-er).  
 
Section 3 of the paper has a detailed critique of SPSS usage in the 2002 European Social Survey (pp 23 ff) and also has my various mult response solutions (pp 31 - 35) for analysing data from a question on grounds of perceived discrimination.  There's also an accompanying slide-show  SPSS usage in major surveys  for this section.  This was the first time I'd ever used PowerPoint, but it's not too bad the gist is clear.  The screenshots are all from exercises done with SPSS11 (much simpler to read) but the output formats for 15 and 18 have since changed to accommodate pivot tables., so it's more fiddly to get something presentable.
 
Hope this helps
 
John Hall