I am trying to calculate answers in a Risk assessment survey. If the person is Male and answers YES to a particular question then the question is given a specific pre-assigned numeric value for that question (0-5). If the person is Female and answers YES then they are given a pre-assigned numeric value which may or may not be the same as the male value. Each question has different numeric values attached to the M/F fields. In all cases if the answer is NO then it is given a numeric value of 0.
At the end of the 5 questions, I am trying to total the numeric values based upon the answer to the questions. If the final numeric value totals are 0-3 then the person is given a Risk score of Low. If the results are 4-9 then they are Medium Risk. 10+ gives the respondent a value of High Risk.
Any ideas on how I would set up the table(s).
Example:
Male Q1 Yes 4
Female Q1 Yes 3
Male Q2 Yes 3
Female Q2 Yes 3
And so on. . .
Thanks in advance for your help.
At the end of the 5 questions, I am trying to total the numeric values based upon the answer to the questions. If the final numeric value totals are 0-3 then the person is given a Risk score of Low. If the results are 4-9 then they are Medium Risk. 10+ gives the respondent a value of High Risk.
Any ideas on how I would set up the table(s).
Example:
Male Q1 Yes 4
Female Q1 Yes 3
Male Q2 Yes 3
Female Q2 Yes 3
And so on. . .
Thanks in advance for your help.