Hi
I would really appreciate some help as my knowledge in excel is basic.
I have created a questionnaire with 11 questions and this will be completed at 2 different times with each person, once pre and once post intervention.
The achieves for each question are 1 to 10. When I get the results, I am aiming to see if the scores have improved post intervention. Now, I can do graphs that show the scores for each question but what I really want to show is that how many people (in percentage) showed an increase in each question post intervention. Does that make sense? So rather than the total scores, say 80% of people show an improvement in family life post intervention (as question 1 in time 2 were greater scores than in time 1). I hope that makes sense
I would really appreciate some help as my knowledge in excel is basic.
I have created a questionnaire with 11 questions and this will be completed at 2 different times with each person, once pre and once post intervention.
The achieves for each question are 1 to 10. When I get the results, I am aiming to see if the scores have improved post intervention. Now, I can do graphs that show the scores for each question but what I really want to show is that how many people (in percentage) showed an increase in each question post intervention. Does that make sense? So rather than the total scores, say 80% of people show an improvement in family life post intervention (as question 1 in time 2 were greater scores than in time 1). I hope that makes sense