Dear smart people,
I have a problem with Excel. I'm doing a bachelor thesis on Entrepreneurial Attitudes and handed out questionaires. I'm now trying to work with them and I am a bit stuck. Help is highly appreciated. My goal is to compare the answers of students from my home university with those of my abroad university. I have a row with the university (translated into number 1 or 2), and I have a row with the answers ranging form 1 to 7.
Strongly disagree= 1
Moderatly disagree= 2
Slightly disagree = 3
neither agree or disagree= 4
Slightly agree= 5
Moderatly agree= 6
Strongly agree= 7
I now want to count for each of the 7 answers, how many answered form my home university and how many answered from my abroad university.
So if I want to do that for "Neither agree or disagree" for my home university I have two conditions: In the row of the "question" it needs to be a 4 and in the row of the "university" it needs to be a 1. And both need to be in the same column as well if I'm not mistaken.
With Kind Regards,
Why are you doing this to me Excel whyyyy?!
Bookmarks