Help with analysing of qualitative data in Excel

[IvanaP]

I have a bunch of qualitative data to analyse across different geographical regions and most questions asked require an either agree, strongly agree, disagree, strongly disagree and undecided answers. Can someone please advise how best to count each of the responses for each region and each question...I am doing it manually by filtering each response and this is taking forever. Any help much appreciated. Thanks, Ivana

[shg]

The typical approach for Likert-scale response is to just average them, considering the leftmost value as -2 and the rightmost as +2.

[Shijesh Kumar]

Create a pivot table...