StatisticsFilter: Correlation over time?
December 11, 2007 12:40 AM Subscribe
If I'm looking at existing statistical data, how do I try to find a correlation between two variables over time? Scatterplots have confused me, because they don't seem to reflect the passage of time, but just where x and y meet. Pearson's r
doesn't seem to do it either w/r/t time.
posted by trondant to Science & Nature (13 answers total) 4 users marked this as a favorite
So, what statistical method should I use? I'm not sure if the variables are independent or not, so that's another stew. At a series of given points in time I have an x and a y, but I need to understand how to know whether or not any correlation exists.
So data might look like this:
date x y
1/1 5 32
1/8 7 15
3/9 2 26
Am I underthinking this, or just ignorant? Does Excel already know how to do this and I just don't know it? No correlation is fine too, I'd just like to know I'm doing it properly.