(adsbygoogle = window.adsbygoogle || []).push({}); Autocorrelation function in Excel (SOLVED)

Hi, I have tried reading through this forum looking for similar example but am unable to find one.

Basically, I have a large set of data that I intend to do autocorrelation.

=CORREL(A1:A10000,A2:A10001)

=CORREL(A1:A10000,A3:A10002)

=CORREL(A1:A10000,A4:A10003)

...

=CORREL(A1:A10000,A10000:A20000)

But when i try to extend the formula, it does not seem to work? Can anyone help me on this? Thanks.

Added the $ sign to make it a fixed variable.

Problem solved. Thanks for the help

**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 function in Excel

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