And a rolling correlation is a type of correlation between two different time series on a rolling window.Īdditionally, a rolling correlation is beneficial when we want to visualize the correlation between two different time series over time. However, we will focus on the rolling correlation. When we measure and relate the variance of each variable, the correlation will indicate the strength of the relationship between the two variables.įurthermore, there are many types of correlations. So a correlation measure the linear relationship between two variables. In this case, we will focus on performing a rolling correlation in Excel. For example, Excel is an excellent tool to use for correlation analysis. Since it has several built-in tools and functions, Excel is a popular tool for statistical calculations and data analysis. However, the function will support cells with zero values. The rules for using the CORREL function in Excel are the following:
A Real Example of Calculating Rolling Correlation in Excel.