I'm running a questionnaire where respondents answer questions which are scored 1-5.
The below shows how many people answered each a question (left column) with the associated answer (5,4,3,2,1).
Is there any method by which I can reduce a single questions distribution of values (such as question 0's 11,12,1,0,1 answers) as a single value? For example between 0 and 1?
Answer 5. 4. 3. 2. 1.
Q 0 : 11 12 1 0 1
Q 1 : 12 12 0 1 0
Q 2 : 6 7 5 5 2
Q 3 : 3 3 5 11 3
Q 4 : 1 13 5 3 3
Q 5 : 4 3 4 10 4
Q 6 : 3 5 7 6 4
Q 7 : 0 3 7 7 8
Q 8 : 0 0 3 6 16
Q 9 : 6 12 2 4 1
Q 10 : 14 11 0 0 0
Q 11 : 8 12 3 1 1
Q 12 : 7 5 3 6 4
Q 13 : 5 10 5 3 2
Q 14 : 2 5 8 6 4
Q 15 : 7 10 8 0 0
Q 16 : 13 11 1 0 0
Q 17 : 4 14 6 0 1
Q 18 : 2 5 5 7 6
Q 19 : 0 4 4 11 6
Q 20 : 3 12 8 2 0