Hi everyone, I need some help with batch processing. Sorry for the long post with huge figures.
I have a datafile with multiple Y columns, which looks like this:
Now I want to calculate the autocorrelation (lag=1) value and significance for each Y column, and export those two values into a new summary sheet.
First I selected the first Y column, and performed analysis using the "Simple Time Series Analysis" app, and managed to get the report:
Then I copied those two values and pasted the corresponding link to a new sheet (sheet 2):
Then I went to use the "Repeat this for all Y columns" command
But instead of getting a nice table containing the useful values for all the Y columns, each Y column generated its individual ACF result sheet and nothing is happening to the table in sheet 2.
Please, could someone teach me how to do this properly?