Please advise how to solve the following problem - I need to calculate correlation for two arrays. The problem is that each following correlation coefficient is calculated for different intervals i.e. first coefficient is calculated for previous 20 values, next - for 21 values and so on. I need to calculate correlation for past 20 cells.
I apologize for my English.
Welcome to the forum.
Post a workbook and explain in context.
Entia non sunt multiplicanda sine necessitate
Thanks, shg. Workbook enclosed. Thanks in advance for your attention.
Change the formula in C21 to =CORREL($A2:A21, $B2:B21)
See Help for About cell and range references
Oh My God... I`m dumb. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks