Forum Discussion
Correlation of every n rows
I have data in two columns, and I need to calculate correlations of first 12 rows and the last 12 rows. In this example, I need to calculate the correlations between B4:B15 and H4:H15, and B16:B27 an...
In K5:
=CORREL(INDEX(B:B,12*(ROW(K5)-ROW($K$5))+4):INDEX(B:B,12*(ROW(K5)-ROW($K$5))+15),INDEX(H:H,12*(ROW(K5)-ROW($K$5))+4):INDEX(H:H,12*(ROW(K5)-ROW($K$5))+15))