In: Statistics and Probability
I think I'm suppose to use ANOVA in excel to test this but I am not sure.
This is my data:
400 people were surveyed.
1. Household Earning< $15,000 26 people
2. Household Earning $15,000-$24,999 34 people
3. Household Earning $25,000-$49,999 82 people
4. Household Earning $50,000-$74,999 133 people
5. Household Earning $75,000-$99,999 16 people
6. Household Earning $100,000-$149,999 43 people
7. Household Earning $150,000+ 66 people
The one-way analysis of variance (ANOVA) is used to determine whether there are any statistically significant differences between the means of three or more independent (unrelated) groups.
The one-way ANOVA compares the means between the groups you are interested in and determines whether any of those means are statistically significantly different from each other. Specifically, it tests the null hypothesis:
where µ = group mean and k = number of groups. If, however, the one-way ANOVA returns a statistically significant result, we accept the alternative hypothesis (HA), which is that there are at least two group means that are statistically significantly different from each other.
Hence, the ANOVA test only allows you to check whether the means of two or more independent samples are equal or not. But it doesn't help to establish a relationship between variables. You may use the 2-test of a contingency table to Analyze relationship between two variables.