Survey Monkey and SPSS?

[Lynn D. Disney]

Does anyone have experience with exporting Survey Monkey data into Excel and
then SPSS? There are some weird things happening and I don't know if it is a
matter of setting different options in Survey Monkey, or whether SM just
won't do what I want it to..in particular, I am trying to export questions
with Likert type answer categories and it keeps creating a variable for each
category, rather than a single variable with multiple categories.Another
option is to recode the variables into a single one in SPSS, which I also do
not know how to do..



Thanks



Lynn



Lynn D. Disney, Ph.D., J.D., M.P.H.

Data Specialist

Reading First-Ohio Center

John Carroll University

20700 North Park Boulevard

University Heights, Ohio 44118

Telephone: [phone]

Email:  <mailto:[hidden email]> [hidden email]

=====================
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

[msherman]

Lynn: We have had the same problem with survey monkey.  Make sure that you export it using the condensed version as opposed to the expanded. That will take care of most of the problems.  However, you will more than likely this has items that come across in the expanded version. From there you will simply have to combine the separate "variables" into one variable.  Contact me if you want to know ways of combining multiple or expanded variables into one.

Martin F. Sherman, Ph.D.
Professor of Psychology
Director of Masters Education: Thesis Track
Loyola College
Psychology Department
222 B Beatty Hall
4501 North Charles Street
Baltimore, MD 21210

410 617-2417 (office)
410 617-5341 (fax)

[hidden email]


>>> "Lynn D. Disney" <[hidden email]> 2/4/2008 12:30 PM >>>
Does anyone have experience with exporting Survey Monkey data into Excel and
then SPSS? There are some weird things happening and I don't know if it is a
matter of setting different options in Survey Monkey, or whether SM just
won't do what I want it to..in particular, I am trying to export questions
with Likert type answer categories and it keeps creating a variable for each
category, rather than a single variable with multiple categories.Another
option is to recode the variables into a single one in SPSS, which I also do
not know how to do..



Thanks



Lynn



Lynn D. Disney, Ph.D., J.D., M.P.H.

Data Specialist

Reading First-Ohio Center

John Carroll University

20700 North Park Boulevard

University Heights, Ohio 44118

Telephone: [phone]

Email:  <mailto:[hidden email]> [hidden email]

=====================
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

=====================
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

[msherman]

Lynn: Here is a simply syntax that will demonstrate one way of combining the expanded variable.  mfs

data list / var1 1 var2 2 var3 3 var4 4 var5 5.
begin data
1
  3
 2
    5
1
   4
end data.
recode var1 var2 var3 var4 var5 (sysmis=0)(else=copy) into rvar1 to rvar5.
compute item1=sum.1(rvar1 to rvar5).

mfs

>>> "Lynn D. Disney" <[hidden email]> 2/4/2008 12:30 PM >>>
Does anyone have experience with exporting Survey Monkey data into Excel and
then SPSS? There are some weird things happening and I don't know if it is a
matter of setting different options in Survey Monkey, or whether SM just
won't do what I want it to..in particular, I am trying to export questions
with Likert type answer categories and it keeps creating a variable for each
category, rather than a single variable with multiple categories.Another
option is to recode the variables into a single one in SPSS, which I also do
not know how to do..



Thanks



Lynn



Lynn D. Disney, Ph.D., J.D., M.P.H.

Data Specialist

Reading First-Ohio Center

John Carroll University

20700 North Park Boulevard

University Heights, Ohio 44118

Telephone: [phone]

Email:  <mailto:[hidden email]> [hidden email]

=====================
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

=====================
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

[Haase, Heino, Springer DE]

Dear Lynn,
If you have a Likert scale you should choose 'multiple choice -one answer only' or 'rating scale' in surveymonkey and not 'multiple choice -multiple answers' as you did apparently.

In SPSS you don't have to recode. You could make use of the 'mult response' function instead. See help/command syntax reference or use the same procedure from the 'analyse' drop down menu.

Best regards,
Heino

---
Heino Haase
Springer
Market Research
---
Tiergartenstr. 17 | 69121 Heidelberg | Germany
tel     [phone] / 487 - 8273
fax     [phone] / 487 - 8711
[hidden email]
---
http://www.springer.com




-----Ursprüngliche Nachricht-----
Von: SPSSX(r) Discussion [mailto:[hidden email]] Im Auftrag von Lynn D. Disney
Gesendet: Monday, February 04, 2008 6:30 PM
An: [hidden email]
Betreff: Survey Monkey and SPSS?

Does anyone have experience with exporting Survey Monkey data into Excel and
then SPSS? There are some weird things happening and I don't know if it is a
matter of setting different options in Survey Monkey, or whether SM just
won't do what I want it to..in particular, I am trying to export questions
with Likert type answer categories and it keeps creating a variable for each
category, rather than a single variable with multiple categories.Another
option is to recode the variables into a single one in SPSS, which I also do
not know how to do..



Thanks



Lynn



Lynn D. Disney, Ph.D., J.D., M.P.H.

Data Specialist

Reading First-Ohio Center

John Carroll University

20700 North Park Boulevard

University Heights, Ohio 44118

Telephone: [phone]

Email:  <mailto:[hidden email]> [hidden email]

=====================
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

=====================
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