Jump to content
We've recently updated our Privacy Statement, available here. ×

Moving Average Correlation Coefficient

Kevin Morgan

Recommended Posts

I have a time series dataset whereI'm trying to calculate discrete correlation coefficientsas a moving average. Essentially I want a running correl function between two columns of the previous 10 samples to know when the two variables are strongly correlated and weakly correlated.

Working in Spotfire X, I'm not seeing any statistical functions available to compute correlation coefficients as a calculated channel (but there is a Covariance function!).

I've included an image of what the function would look like in Excel, in case that helps.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...