This macro calculates the pairwise correlations and p-values for a group of columns and stores them into columns of the worksheet.
will allow you to display the same results and store the correlations in a matrix. However, this macro will store them in the worksheet.
This macro calculates the pairwise correlations and p-values for a group of columns and stores them into columns of the worksheet.
will allow you to display the same results and store the correlations in a matrix. However, this macro will store them in the worksheet.Be sure that Minitab knows where to find your downloaded macro. Choose . 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.
Suppose you have numeric data stored in columns C1-C20 and you want to find the correlation and p-value between each pair of columns. You want to store the correlations and p-values in C22-C25. To run the macro, choose and type:
%CORRSTOR C1-C20 C22-C25
Click Run.