How to discount participants and cross tabulate it?

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

Posts: 1
Joined: Sat Jun 27, 2015 9:44 pm

How to discount participants and cross tabulate it?

Postby johanismi » Sat Jun 27, 2015 11:20 pm

Greetings. I'm still new with the SPSS software.

I am doing a study on campaign awareness. I've done the data collection process, and i have trouble in analyzing it.

I'm using likert scale. The data indicated to a frequency of 44% (not aware), 2% (not sure) and 54% (aware). It is adequate for me to only tabulate the 54% who are aware of the campaign, and leave out the remaining % as they are not relevant to be analyzed in my study. After 'filtering' the 54%, i have to cross tabulate it by gender.

Can anyone please point me to the right direction on how to configure such analysis in SPSS?
Posts: 100
Joined: Mon May 19, 2014 6:06 am

Re: How to discount participants and cross tabulate it?

Postby RubenGeert » Sun Jun 28, 2015 8:09 am

Welcome to SPSS!

Disregarding your question for a second, I strongly recommend getting into the habit of working from syntax. This may not seem obvious at first, but take a look at ... ld-use-it/ if you're not sure whether this is the way to go.

If you're confident you're not going to use a subset of cases in any way, delete them with SELECT IF. See

If you're not 100% sure you won't need them anymore, use FILTER. See

For examples of running crosstabulations, take a look at and/or ... variables/. The latter tutorial shows some pretty charts for this situation as well. Styling the charts with SPSS Chart Templates is rather challenging but it can create a "WOW!" effect among your colleagues, clients and supervisors!



Who is online

Users browsing this forum: No registered users and 4 guests