I have a data set that has a total score from an assessment and gender. I need to create a new category of, 'risk level' that will use gender and a total score range to give me a risk level. How would I set this up? Example: if 'gender' = M (options here are M or F) and 'total score' = 8 (I need this to be able to use a range, i.e. 0-7, 8-10,11-15, 16+) then 'risk level' (the newly created category) = Med-Low (options here are Low, Med-Low, Med-High, High) Any help is appreciated.
... View more