Cross correlations for multiple pairs of columns

This macro calculates cross correlations for two or more pairs of columns.

Download the Macro

Be sure that Minitab knows where to find your downloaded macro. Choose Tools > Options > General. Under Macro location browse to the location where you save macro files.


If you use an older web browser, when you click the Download button, the file may open in Quicktime, which shares the .mac file extension with Minitab macros. To save the macro, right-click the Download button and choose Save target as.

Required Inputs

You need two or more columns of data.

Running the Macro

Suppose the data are in C1, C2, ... C10 and you want the cross correlations for all the pairs of columns. To run the macro, choose Edit > Command Line Editor and type:


Click Submit Commands.


The dash in C1-C10 is a shortcut you could use if the variables are in consecutive columns. If the columns are not consecutive, list each variable with a space in between each (for example, %ccfloop C1 C4 C7 C9).

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy