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.(adsbygoogle = window.adsbygoogle || []).push({});

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.

**Physics Forums | Science Articles, Homework Help, Discussion**

Dismiss Notice

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Autocorrelation in Excel

**Physics Forums | Science Articles, Homework Help, Discussion**