Hi All.
I have a data set as below
Q1 Q2
WE1 4 4
WE1 4 5
WE1 3 4
WE2 4 3
WE2 3 2
WE2 2 1
WE3 1 4
WE3 4 5
WE3 5 4
I need to come up with a weekly chart that shows percentage of scores for each week regardless of the question.
that means , say for week 1, ill need to count how many scored 4, how many scored 5, etc. and then divide by total responses...
ex. week 1 has 4 scores = 4 divide by 6 (total response)
Hope i could get a head around what best formula to use to generate this.
Thanks
Bookmarks