Sorted simple regressions

This macro performs simple regression for a single response versus each specified predictor, one predictor at a time. For each predictor, the R-squared and p-value are calculated. These values are then sorted from the smallest to the largest p-value and displayed in a table.

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

  • A column of response data
  • One or more columns of predictor data

Running the Macro

Suppose the response data are in C3, and the predictors are in columns C4, C6, and C9. To run the macro, choose Edit > Command Line Editor and type:


Click Submit Commands.

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