Page 1 of 1

correlation with different sample range

Posted: Wed Dec 19, 2012 11:18 am
by vytama
Hello,
I am new to Eviews. (using 7). I have two series (x and y) with sample range 1990m1 to 1991m12. I want to find the highest correlation between two series by keeping y fixed with range of 1991m1 to 1991m12 and moving series x 1 month back: range 1990m12 to 1991m11, and so on untill 12 months back. My question is how can set these separate ranges for each series? thanks

Re: correlation with different sample range

Posted: Wed Dec 19, 2012 11:33 am
by EViews Gareth
Rather than changing the sample, just lag X.

So first do the correlation between Y and X(-1). Next do the correlation between Y and X(-2), and so on...

Re: correlation with different sample range

Posted: Wed Dec 19, 2012 12:04 pm
by vytama
Thank you for quick response. I tried using lags, however I get different result in excel. Just to confirm, my sample range is1990m1 to 1991m12. For lag(-1), in excel I have x(1990m12 to 1991m11) and y stays fixed at (1991m1 to 1991m12). for lag (-2) x is (1990m11 to 1991m10) and y stays fixed at (1991m1 to 1991m12). Is eviews using the same logic?

Re: correlation with different sample range

Posted: Wed Dec 19, 2012 12:28 pm
by EViews Gareth
Yes.