Autocorrelation function in Excel

[dinky]

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

 

[Greg Bernhardt]

I'm sorry we could not help you. You might want to try http://www.excelforum.com for this specific question.