Home |
Search |
Today's Posts |
#1
|
|||
|
|||
autocorrelation function
Hi
Does anyone know how to calculate an autocorrelation function in Excel?! Thanks! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
Thanks Jerry.
To calculate higher lags can you just move the second range downwards, eg lag 2 =CORREL(A1:A9,A3:A11) ? "Jerry W. Lewis" wrote: 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! |
#4
|
|||
|
|||
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 MOO wrote: Thanks Jerry. To calculate higher lags can you just move the second range downwards, eg lag 2 =CORREL(A1:A9,A3:A11) ? "Jerry W. Lewis" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |