I am trying to create two types of sum variables (within the StatsiQ workspace).

First, I am not sure if StatsiQ is the best way to try to do these functions.

(1) I want to create a variable that sums all the selections of a “select all that apply variable.”

For example, if the participant selected 4 of the options, the new variable would =4.

(2) This may require two steps/two new variables, but I have a matrix question where respondents answered on a scale of 1 to 5 for a series of items. I want to create a variable that reduces this to a binary response (if 1-4 is selected = 1, if 5 is selected = 0), then I want to sum across all the items in the matrix.

So if they answered on the scale from 1-4 for 10 of the items, and responded on the scale with 5 for 10 more items, the new variable would be = 10.

I did not have the foresight to try to create these as an embedded data field before collecting the data.