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 - The Fusion of Science and Community**

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

Loading...

Similar Threads - Autocorrelation Excel | Date |
---|---|

Ratio of Fields from Different Sheets in Excel Pivot | Jan 23, 2018 |

Equivalent to Joining tables (SQL) in Excel? | Jan 22, 2018 |

Excel: Inserting many Horizontal rows in same Cell | Nov 24, 2017 |

Help with Annoying Stuff on Excel | Jan 13, 2017 |

Autocorrelation function in Excel | Oct 4, 2012 |

**Physics Forums - The Fusion of Science and Community**