autocorrelation function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

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

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

Jerry
 
Thanks Jerry.

To calculate higher lags can you just move the second range downwards, eg
lag 2 =CORREL(A1:A9,A3:A11) ?
 
Yes, provided that A11 is empty. Otherwise use =CORREL(A1:A8,A3:A10).
Note that the two offset arrays must be the same size.

Jerry
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Verizon outgoing email 1
autocorrelation function (ACF) 4
How to drag so part of a formula counts up and another down. 2
Excel Functions 2
Precentile calculation 2
Adding functions to filters 2
Offset vs vlookup functions 1
Number of Functions in Excel 2007 2

Back
Top