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.