Originally posted by: CycloWizard
It's been quite a while since I took a statistics course and I'm having a hard time recalling the correct way to test whether two sets of data are statistically independent. The two sets of data are (x1,y1) and (x2,y2). In this case, "x" is simply a distance and "y" is a property that depends on distance. The 1 and 2 are the direction in which I'm testing, since there may be anisotropy in the property y. y1 and y2 are nonlinearly related to x1 and x2.
So, my question is: what statistical method do I need to determine whether y1 and y2 come from the same population or are statistically different?
Okay, re-reading this, it actually looks like you're trying to see if a change in x has an effect on y. Is that what you're trying to figure out? If so, I might pose the question differently.
Tim, I just looked through excel, if I was doing this to answer the OP's question I'd probably first do an ANOVA test on the Ys to see if the variances are significantly different. If false, I'd use the two sample t-test with equal variances or vice versa if true, it should give you the probability you're looking for. The tests I've done have always been two-sided with the t-distribution. You can get the answer either way though, because two sided just means that you are using the same t-value on both sides of the distribution to get your confidence interval. So, if you get a value like 2.74 for a 90% CI (alpha=.10), the t-values corresponding to that are (-2.74,2.74).
This was all done with the analysis toolpak, I just clicked on it and it gave me the option of picking the test. I'm sure you could find the excel function for it too, but this was easier for me.