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

Loading...

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

Positive-only sigmoid function | Oct 20, 2017 |

Plotting Implicit function of 1 variable | Jun 29, 2017 |

Calculators TI-84 Plus stats as function | Dec 27, 2016 |

Excel: Entering empty cells with function | Oct 8, 2015 |

Autocorrelation in Excel | Jun 27, 2011 |

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