- #1
MichalXC
- 41
- 0
I have a set of 9,999 equi-spaced data points, and I would like to calculate the autocorrelations for ALL lags up to 5,000.
In Excel, I want to have this code:
=CORREL(B1:B9998,B2:B9999)
=CORREL(B1:B9997,B3:B9999)
=CORREL(B1:B9996,B4:B9999)
...
=CORREL(B1:B5000,B5000:B9999)
Unfortunately, the formula does not "translate" nicely when I extend it downwards.
Also I have Excel 2008 for Mac, which does not handle VB Macros.
Can anyone direct me? Or suggest a better way of doing it? I don't have MatLab, but I do have Mathematica.
Thanks in advance.
In Excel, I want to have this code:
=CORREL(B1:B9998,B2:B9999)
=CORREL(B1:B9997,B3:B9999)
=CORREL(B1:B9996,B4:B9999)
...
=CORREL(B1:B5000,B5000:B9999)
Unfortunately, the formula does not "translate" nicely when I extend it downwards.
Also I have Excel 2008 for Mac, which does not handle VB Macros.
Can anyone direct me? Or suggest a better way of doing it? I don't have MatLab, but I do have Mathematica.
Thanks in advance.