Hi everyone, 

If I have a multiple response set where I have:

• Variables A to E (detailing an activity for each variable, for example, and they indicate presence or absence of participation)
• Separate A to E variables which asked participants to indicate if they participated in it within 3 categories (e.g., group = 1, with one other person = 2, or alone = 3; missing values indicating that this is not relevant for participants).
• Another set of questions asking about the frequency of these activities. What I would like to find out is the average for each participant, within the 3 separate categories. So, for example, what is the average frequency of participant 1 for activities that they participated in within a group, with one other person, and alone. 

I tried to compute a new variable for GROUP frequency and used the MEAN and IF case function (A = 1 OR B = 1 OR C = 1), but it ended up over-counting my variables.

On a separate note, I wonder if my understanding around this is right - So for example, if Participant 1 participated in activities A, C and K in a group; whereas they participated in B, D with one other - I assume that the frequencies for activities A, C, and K would be added together (A+C+K / 3); and for with one other, the frequencies would be (B+D/2) - am I getting this right? 

I would really appreciate your expertise and advice on this, thank you in advance for your help! 

Cheers, 

LL