# Two sample T test frequency table

I am struggling with a data analysis. I have made a survey and got the following answers in the first turn, I put them in a frequency table

• Don't agree at all: 8
• Don't agree: 6
• I don't know: 16
• Agree: 14
• Totally agree: 6

In the second turn:

• Don't agree at all: 8
• Don't agree: 13
• I don't know: 9
• Agree: 12
• Totally agree: 8 I added weights to the answers: 2 for Don't agree at all, 1 for Don't agree, 0 for Don't know, -1 to agree and -2 for totally agree. I need to know whether their opinion is significantly different or not. I have 50 people who wrote these answers. I know firstly I need to know if the data is Normally distributed or not, then I have to test the variance with the two sample F test and only after this I can turn to the T test. My only problem is, that I have to idea how to solve this in Excel (or SPSS), I have only found examples for data in row and not for frequency tables. Could someone please help me?
• Are the people in the first turn the same as the people in the second turn? If so, can you identify, for any given person, their answer in each turn? – Sal Mangiafico Apr 14 at 13:15
• Yes, they are the same people. Unfortunately, no, because they filled it out anonymously. How bad is that? – TMoci Apr 14 at 16:04
• I edited by answer below. – Sal Mangiafico Apr 14 at 18:50