Autocorrelation

Highlighted
New Contributor

Hi everybody

I have values in column B from B1 to B448 and I need to evaluate in column C the autocorrelation values with the value of log from 1 on.

I need to know:

1 what is the maximum value of the lag given the available number of data,

2 ho to configure properly the paramenters of the correlation excel function so to put it in cell C1 and replicate it on the other cells of the C column ssiply with a drag and drop operation.

Thank you a lot for any help/suggestion.

All the best.

Lorenzo

0 Replies