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:
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.