View Single Post
  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

If your data is in A1:A10, then =CORREL(A1:A9,A2:A10) is the lag 1
autocorrelation.

Jerry

MOO wrote:

Hi

Does anyone know how to calculate an autocorrelation function in Excel?!

Thanks!