I want to test if there is a statistically significant connection between two metric variables. One is the average sherd size and the other is an abrasion index. The other variable actually has a predefine ranged from 1 to 3.
Not specific to SPSS, but if you want to get an idea about the correlation between the two variables then plot them against each other (in a scatter plot).
Not specific to SPSS, but if you want to get an idea about the correlation between the two variables then plot them against each other (in a scatter plot).
Please define "statistically significant connection." Plotting, as Jochen Wilhelm says, is the first (and best) technique to apply. Without knowing what you mean by this phrase though it is not appropriate to speculate on additional techniques.
If we suppose average sherd size is response (dependent) variable and abrasion index is independent variable then by using one-way ANOVA you can test relation between to variables. A significant F statistic lead to accepting significant relation between to variables.
Daniel Wright I would like to know if the contexts with larger average sherd size have lower abrasion index. I work with the assumption that the smaller the average sherd size the the higher the abrasion index.