I am very, very new to SPSS -- and I'm sorry that this is probably an extremely basic question.
I have survey results in Excel. This gives seven questions with numeric scores and then text comments for each question. There are a 100 surveys.
The tasks I'd like to accomplish are:
1. Determine the number of comments per survey. For example, if there was one comment for each possible question would give a maximum of 7 for each survey. Some will have zero others will have a comment for each.
2. Count comments by Question. So, for Question 2 there were 80 comments (out of 100). For question 3, there were 50, etc.
3. Count comments by Question and by Score.
For question 2 there were 70 comments. Those that scored 10 had 6, score 9 had 12, score 8 had 23, score 7 had 14, score 6 had 18, etc.
Also -- on all of the above, I'd like to add the Percent of Total for each along with the count.
I can do this in Excel with some work. I would count cells where ISTEXT is true. Then perhaps do a COUNTIF for each score value.
But now, moving these tasks to SPSS -- would I start (after importing) by coding some new variables and then running Frequencies of some kind? Or perhaps a cross tab report would work?
Thanks for your help.