I have 10 questions about vulnerability assessment. All these questions in a group and select one type. These questions ask about some vulnerability criteria like: female headed household, child headed household, disability, total household members, number of earning members, amount of income in a range, number of elderly persons etc. All these 10 questions have only two options: Yes and No. All these questions are mandatory. After asking these 10 questions, I need to define the vulnerability status of the respondents, like: Extremely vulnerable, vulnerable, moderate vulnerable. For example: If 8-10 questions out of 10 are answered ‘Yes’, then it is extremely vulnerable. If 5-7 questions answered ‘Yes’, then moderate vulnerable. At the end of this group, I have question: Define the vulnerability status of the respondent.
Are there any way to count the number of ‘Yes’ or ‘No’ answered out of those 10 questions?
If I want to link this vulnerability status with the range of ‘Yes’ answered, is it possible? I mean, if 8 ‘yes’ is answered, then there will be only options "Extremely Vulnerable’. If 5-7 ‘yes’ answered, then only ‘moderate vulnerable’ should appear as option. Its kind of cascade, I think.
Any suggestions? Thanks a lot in advance.