Thread
:
autocorrelation function
View Single Post
#
2
Jerry W. Lewis
Posts: n/a
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!
Reply With Quote