I and my team collected questionnaire data on support for wind energy around a recreational lake. One question in the questionnaire identifies the different recreational activities of the respondents, for example, fishing, boating, swimming, scuba-diving, etc. For each activity, the respondent has highlighted how often the activity is undertaken, for instance, daily, weekly, monthly 6 times per year, etc. We would like to investigate whether the type of recreational activities could explain support or opposition to wind energy. However, the question was formulated as “multiple response variables”, allowing for multiple answers. As a result, several respondents indicated carrying out multiple recreational activities.
We would like to carry out some statistical tests like ANOVA to evaluate the support and opposition to wind energy according to the type of recreational activity. Ideally, each respondent could be identified by 1 recreational activity, and not by multiple. Is there a way to somehow convert the multiple responses into a single response? We also collected data on the frequency at which the recreational activities are carried out by the respondents, so that might also help. Please see the example format of the question in the questionnaire below. I would be extremely grateful to receive your thoughts on this.
How often do you undertake the following activities near or on the lake?
never 1 to 6 times per year 7 to 12 times per year Monthly Weekly Daily
Walking
Cycling
Swimming
Family activities
Sailing
Diving
Other
