Let’s say we have a large dataset with several samples over time. I’m looking for an automated way to find correlations over a specific time period. For example, in cycles, we might observe that when one set increases, the other decreases. This is a rough observation made by “eye”. I’m wondering if there is any method, program, or formula in Excel that can calculate correlation such as between June and July there is x% positive correlation, on November 22 the correlation is x% etc?. I appreciate any hints you can provide.