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. 

 

I am not sure if correlation is the correct term but I am looking to do a statistical analysis between how one effects the other.

 

I already have the data analysis tool kit add in, 

Please find attached the data I am referring to.

 

Thank you in advance đŸ™‚ 

1 Reply

  • Savia's avatar
    Savia
    Iron Contributor

    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