Using the below data set
Kindly help with the codes and how to
question matrix, which is the proportion of question to which the respondent gave a YES out of the 5 total question
Question 1 to 5 | QS1CD | QS2CD | QS3CD | QS4CD | QS5CD | Question contribution weight (1=GOOD ANSWER, 2=BAD | QScw1CD | QScw2CD | QScw3CD | QScw4CD | QScw5CD |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | 3 | 2 | NA | 2 | 2 | 1 | 2 | 2 | 1 | ||
3 | 3 | 2 | NA | 2 | 1 | 1 | 2 | 2 | 1 | ||
1 | 3 | 2 | NA | 2 | 2 | 1 | 2 | 2 | 1 | ||
2 | 3 | 2 | NA | 2 | 2 | 1 | 2 | 2 | 1 | ||
2 | 5 | 2 | NA | 2 | 2 | 2 | 2 | 2 | 1 | ||
3 | 3 | 1 | 1 | 2 | 1 | 1 | 1 | 2 | 1 | ||
6 | 3 | 1 | 1 | 2 | 2 | 1 | 1 | 2 | 1 | ||
6 | 5 | 1 | 1 | 5 | 2 | 2 | 1 | 2 | 2 | ||
1 | 5 | 1 | 1 | 2 | 2 | 2 | 1 | 2 | 1 |