Forum Discussion

Papps's avatar
Papps
Copper Contributor
Feb 03, 2020

How can I do a monthly time-series correlation across a 5 year period in excel

Hi,    Is anyone able to help with the following..   I am trying to conduct an analysis on the correlation between participants and Duties in £Million on a monthly basis over the last 5 years.  ...
excel
office 365
Savia's avatar
Savia
Iron Contributor
Feb 04, 2020

Papps This is perhaps more of a statistics question than an Excel one.  But you could use e.g. =CORREL(C14:H14,J14:O14) to calculate the correlation coefficient between those two sets of data - 1.0 is perfect positive correlation and 0.0 is none, so that will give you an idea.

Resources