Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Autocorrelation function in Excel

  1. Oct 4, 2012 #1
    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.


    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
    Last edited: Oct 4, 2012
  2. jcsd
  3. Oct 17, 2012 #2
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

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