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.

    =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
     
    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 Discussions: Autocorrelation function in Excel
  1. MS Excel Function (Replies: 3)

  2. Excel + Calculations (Replies: 9)

Loading...