## Variable to count number of correct responses to a question?

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

MaxClyde
Posts: 3
Joined: Thu Mar 26, 2015 10:32 am

### Variable to count number of correct responses to a question?

I'm analysing a questionnaire about knowledge about diabetes.
One of the questions asks about the risk factors. Participants were allowed to identify and select whichever answers out of the ones listed applies.

There are 6 options, plus a 7th for "I don't know".

4 options are correct and 2 are incorrect.

I want to calculate for example, for each individual, how many correct answers out of 6 they got. I want to calculate that identifying an incorrect option as incorrect is a right answer, so I'll get the result out of 6.

In other words, I want to see the score each participant got out of 6.

To do this, I have already written 7 variables for the question, each for an option, like so:

Q11_riskfactors_overweight
Q11_riskfactors_sedentary_lifestyle

Etc.

For each, I defined the values to be 1 = yes and 2=no as in they agree or disagree with the risk factor written being correct or not.

I tried using "compute" to see how many answered each individual risk factor correctly (if 1= correct, otherwise wrong), but I want to see the combination of correct answers each individual got.

I was considering writing all possible combinations using "compute" manually, to find how many people got a score of 5/6 for example

If options 1,2,3,4,5 are correct but option 6 is wrong, count it as 5/6.

Then if options 1,2,3,4,6 are correct but 5 is wrong, count it as 5/6

And so on, until I write the remaining combinations for 5 correct answers out of 6 and adding them together, but I was hoping there'd be a better way of doing this.
GerineL
Moderator
Posts: 1477
Joined: Tue Jun 10, 2008 4:50 pm

### Re: Variable to count number of correct responses to a quest

maybe you can try the count function, and count the number of 1's for all 6?
MaxClyde
Posts: 3
Joined: Thu Mar 26, 2015 10:32 am

### Re: Variable to count number of correct responses to a quest

GerineL wrote:maybe you can try the count function, and count the number of 1's for all 6?
You mean using "compute" and write their sum?
GerineL
Moderator
Posts: 1477
Joined: Tue Jun 10, 2008 4:50 pm

### Re: Variable to count number of correct responses to a quest

NO I mean the count function, look here;
http://www.yac.com.pl/mt.texts.spss-count.en.html

there is also some youtube videos on it, the function is also under transform.

### Who is online

Users browsing this forum: No registered users and 2 guests