New Feature: Playlist Center! Pick a topic and let our playlists guide the way.

Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Using the Multiple Response command

From: SPSS Statistics Essential Training (2011)

Video: Using the Multiple Response command

It's usually a good idea to enter your data in its least processed and most disaggregated form, that is, put the raw data in and any processing you need to do, do in SPSS. That way you can combine things if you want. On the other hand, if you bring the data into SPSS in an aggregated or combined or summary form, then you can't break it down later. Now one way of dealing with data that you want to aggregate, as long as you are dealing with nominal or categorical variables, is with the Multiple Response function.

Using the Multiple Response command

It's usually a good idea to enter your data in its least processed and most disaggregated form, that is, put the raw data in and any processing you need to do, do in SPSS. That way you can combine things if you want. On the other hand, if you bring the data into SPSS in an aggregated or combined or summary form, then you can't break it down later. Now one way of dealing with data that you want to aggregate, as long as you are dealing with nominal or categorical variables, is with the Multiple Response function.

It's one of the neat tricks in the SPSS. This function combines the responses from several variables and allows you to create frequency tables and cross tabulations as though they were a single variable. In many circumstances, this can make life much easier. The first thing to say here is that you can organize the data in a couple of different ways, and Multiple Response can deal with either one of them. In this data set, Tickets.sav, I have hypothetical data about the purchase of season tickets to seven different kinds of events.

I have Baseball and Basketball and Football as well as the Symphony, the Opera, the Theatre, and the Ballet. And the idea here is we might want to look at what kinds of season tickets people have, how many they have, and whether there is, for instance, a difference in the gender and the age and the overall preferences of the buyer. And again, this is hypothetical data. I have it set up first where I have each possible event, the three sports and the four cultural events, as indicator variables.

So you see here for Baseball we have Yeses and Nos for whether a person has season tickets to Baseball, and then to Basketball and Football. Then I have a column that adds up how many sports events they have season tickets to. The first person has season tickets to two sporting events, Baseball and Football. The second person has none. And then I have four cultural events. I am going to scroll over a little bit, so you can see all of it, and I do a similar thing. I add up how many cultural tickets people have. Then I also have another one, combining both the sports and the cultural, how many season tickets they have all together. I am being a little optimistic, but this is how that works.

So this is a series of what are called dichotomous indicator variables. Dichotomous means just two possible values, yes, no; male and female; and an indicator variable is a 0/1 variable, where 0 is no and 1 is yes. In fact, if I go up to the menu bar and click on this button for Value Labels, you'll see the 0s and the 1s that are underneath these. I put the Value Labels back on, you can see the Yeses and the Nos. So the indicator variables is one way I list every possible choice and I put down a Yes or No for each person.

The other way of organizing multiple response data is by simply having a variable for the maximum number of choices that a person can have. Now in this hypothetical data set nobody had more than four sets of season tickets, and so what I have is Tix1, 2, 3 and 4, by whether they have season tickets. There are seven options for each one of these, and I simply put down the first one, the second one, and if that's all they have, I put 0s for the rest. You can see actually I have some people who have no season tickets at all, down about case 16.

This is a way that people often do coding, especially if it's open ended, write down all of your feelings or your responses to a particular question, but I'll let you know right now, this kind right here, the Tix1 through 4 where we can have any of the categories in any of the columns, this can get extremely cumbersome. In my experience the indicator variables, even though we have to have more of them, is more amenable to adding things up and to doing other analyses. Now with that in mind let me show you how to set up a Multiple Response format.

The first thing you have to do is define what are called variable sets, the variables that should be treated as instances of a single category. You go up to Analyze and then you go down near the bottom to Multiple Response and define Variable Set. You'll see I have two other options beneath that, Frequencies and Crosstabs. They are not available yet, because I haven't defined any sets. I click on that, and I am going to do this twice. I am going to do once with the indicator variables--that's the 0, 1, yes, no variables--and another one with the multiple choice ones, the four columns for the four kinds of tickets people have.

So what I do is I first scroll down here and I'll pick the three sporting events and put those over here, and then I'll click the four cultural events, and I'll put those over. And then what it does is it asks me whether these are dichotomies--that's the 0, 1 for instance--or whether they are categories, where it's the 1 through 7. This part is the dichotomies. And it says, which one counts as a yes, because it might be 0, 1, but it might be 1, 2, or something else.

I just have to indicate that it's the 1 that counts as a yes. And then I have to give a name to the Multiple Response set, and what I am going to call it here is TixDichotomies, Dichotomous Variables for ticket purchases. And then I click on Add over on the right. And so what this does is it creates a Multiple Response Set. It's $TixDichotomies. This won't show up in the data set because this is more like a metadata.

It's information about the data set that the computer saves. So I have done this, and I can press Close now. You see the data set does not look different, but if I now come up to Analyze and back down to Multiple Response, I now have these two other options of Frequencies and Crosstabs available. What I can do for instance is I can click on Frequencies, and there is the Multiple Response Set that I just created. All I do is I move it over and I press OK.

And I get a table that says, how many people had purchased each kind of ticket? Now this is the same thing as the 0, 1 indicator. It's simply telling me how many people had basketball tickets, how many people had opera tickets. So this is one way of doing it. I can also do cross-tabulations. If I go back to Analyze, to Multiple Response, to Crosstabs, I can say that I want to look, for instance, at whether there are gender differences in these. And I can put the Multiple Response Variable in the Column(s) and gender up here.

However, I have to define the gender variable. I'll define the range and I simply tell it that I have 0s and 1s. Press Continue. Then I can click OK, and this is called a cross-tabulation. It lets me know the number of men and women who have season tickets of each kind. We'll go back to crosstabs in a later movie, but I just wanted you to see that there is an option with the Multiple Response Set. Now, I can also do multiple responses with the other kind where I have it open ended where people can put anything for the first set of tickets they have to second set. Let's look back at the data set.

That's these four at the end. I only need four, because four is the most that anybody purchased. To do this one I come back to Analyze, back down to Multiple Response, and I am going to define a new variable set. This time I scroll down and I select these last four, First Season Ticket through Fourth Season Ticket, and then move those over to Variables in Set. In this case, they are not dichotomies; they are categories. And I need to tell it the range. There were seven possible choices, so I need to say it goes from 1 to 7. Then I need to give it a name.

Now the last one was TixDichotomies. I might as well call this one TixCategories. Ticket Categories, this would be my label, and then I click Add. So that shows up as another response set. I click Close and I can do the frequencies and the crosstabs again using it this way. So I come back up to Analyze, to Multiple Response, to Frequencies. Now I used the dichotomies the last time. I'll just double-click and get that out of there.

I'll use the Categories this time and hit OK, and you see I get the same kind of information. It's just the data was organized differently. I can also do the crosstabs the same way. Going up to Analyze, to Multiple Response, to Crosstabs, so this time I take out the Dichotomies and I put in the Categories. Now I get the same output either way, which will make it seem that these two methods of creating multiple response sets or equivalent; however, I'll let you know there is a trade-off.

The Multiple Response set that's created on the categories, that is, with these multiple choice ones, where people could put any of the answers, about the only way to use these variables is with Multiple Response sets, and they are very limited in their application. On the other hand, if you do the indicator variables, which I had over to the left, these are much more flexible, and they can be used in other procedures like getting correlations and regression that we'll do later, which is why I almost always use the indicator variables, the 0, 1 variables for each choice.

The only trouble is if you had, for instance, a lot of possible responses. You could end up with a huge number of indicator variables where you could only have a smaller number of these category columns. On the other hand, if you really have that many choices, you might be wise to your collapse categories and combine them. Anyhow, the Multiple Response function in SPSS can be a nice way of dealing with situations where people can choose or write in more than one answer to a question. The procedure is flexible because it can used dichotomous indicator variables, that's the 0, 1, for each possible choice, or a smaller number of categorical variables with several choices for each.

However, the procedure does limit you to doing just frequencies or crosstabs for other nominal, ordinal variables. For these reasons I generally recommend that you use the dichotomous indicator variables. But for now the Multiple Response function is an important tool in your collection for data-analysis strategies.

Show transcript

This video is part of

Image for SPSS Statistics Essential Training (2011)
SPSS Statistics Essential Training (2011)

52 video lessons · 18810 viewers

Barton Poulson
Author

 
Expand all | Collapse all
  1. 2m 58s
    1. Welcome
      1m 5s
    2. Using the exercise files
      40s
    3. Using a different version of the software
      1m 13s
  2. 19m 0s
    1. Taking a first look at the interface
      11m 49s
    2. Reading data from a spreadsheet
      7m 11s
  3. 21m 54s
    1. Creating bar charts for categorical variables
      7m 18s
    2. Creating pie charts for categorical variables
      2m 54s
    3. Creating histograms for quantitative variables
      5m 45s
    4. Creating box plots for quantitative variables
      5m 57s
  4. 33m 10s
    1. Recoding variables
      5m 33s
    2. Recoding with visual binning
      5m 33s
    3. Recoding by ranking cases
      5m 26s
    4. Computing new variables
      5m 37s
    5. Combining or excluding outliers
      5m 21s
    6. Transforming outliers
      5m 40s
  5. 28m 12s
    1. Selecting cases
      6m 44s
    2. Using the Split File command
      5m 12s
    3. Merging files
      5m 33s
    4. Using the Multiple Response command
      10m 43s
  6. 22m 14s
    1. Calculating frequencies
      8m 43s
    2. Calculating descriptives
      5m 31s
    3. Using the Explore command
      8m 0s
  7. 16m 3s
    1. Calculating inferential statistics for a single proportion
      6m 6s
    2. Calculating inferential statistics for a single mean
      5m 39s
    3. Calculating inferential statistics for a single categorical variable
      4m 18s
  8. 30m 43s
    1. Creating clustered bar charts
      7m 10s
    2. Creating scatterplots
      5m 8s
    3. Creating time series
      3m 24s
    4. Creating simple bar charts of group means
      4m 17s
    5. Creating population pyramids
      3m 0s
    6. Creating simple boxplots for groups
      3m 3s
    7. Creating side-by-side boxplots
      4m 41s
  9. 45m 28s
    1. Calculating correlations
      8m 17s
    2. Computing a bivariate regression
      6m 27s
    3. Creating crosstabs for categorical variables
      6m 34s
    4. Comparing means with the Means procedure
      6m 33s
    5. Comparing means with the t-test
      6m 4s
    6. Comparing means with a one-way ANOVA
      6m 30s
    7. Comparing paired means
      5m 3s
  10. 24m 30s
    1. Creating clustered bar charts for frequencies
      6m 34s
    2. Creating clustered bar charts for means
      3m 45s
    3. Creating scatterplots by group
      4m 13s
    4. Creating 3-D scatterplots
      4m 25s
    5. Creating scatterplot matrices
      5m 33s
  11. 30m 57s
    1. Using Automatic Linear Models
      11m 52s
    2. Calculating multiple regression
      9m 3s
    3. Comparing means with a two-factor ANOVA
      10m 2s
  12. 29m 29s
    1. Formatting descriptive statistics
      6m 1s
    2. Formatting correlations
      7m 49s
    3. Formatting regression
      10m 19s
    4. Exporting charts and tables
      5m 20s
  13. 51s
    1. What's next
      51s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold

Are you sure you want to delete this note?

No

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.