Looking for some advice on running simple statistics on some survey data I have.
Part 1. I have two surveys, one from 2009 and one from 2013, with the exact same question but different respondents. How might I compare this question between years to see if they are significantly different or not? The survey was conducted anonymously from a pool of about 4000 people. Several hundred responses were collected for each year (~500 for 2009 & 700 for 2013).
Part 2. What is the best way to test for significance among groups of people based on their characteristics within one survey? T-Test?
I unfortunately only have access to Excel to do my stats. Any help would be appreciated!
Thanks.