I'm working to format a database in a specific way for creating automized reports. The database needs to have a column with the total number of each Likert-type response.
So, for example, for question 1, there needs to be a coulmn with the number of people who responded "Strongly Disagree", a column with the number who responded "Disagree", and so forth...
Right now the data is formatted with a categorical variable for each survey question.
Is there a way to basically unroll each question into separate variables that represent each possible response?
So, for example, for question 1, there needs to be a coulmn with the number of people who responded "Strongly Disagree", a column with the number who responded "Disagree", and so forth...
Right now the data is formatted with a categorical variable for each survey question.
Is there a way to basically unroll each question into separate variables that represent each possible response?
Comment