Conditional Formatting of Large Residuals and Unusual Combinations of Predictors

Cody Steele | 18 July, 2016

Topics: Project Tools, Data Analysis, Statistics

If you've used our software, you’re probably used to many of the things you can do in Minitab once you’ve fit a model. For example, after you fit a response to a given model for some predictors with Stat > DOE > Response Surface > Analyze Response Surface Design, you can do the following:

  • Predict the mean value of the response variable for new combinations of settings of the predictors.
  • Draw factorial plots, surface plots, contour plots, and overlaid contour plots.
  • Use the model to find combinations of predictor settings that optimize the predicted mean of the response variable.

In the Response Surface Menu, you can see tools that you can use with a fitte model: Predict, Factorial Plots, Contour Plot, Surface Plot, Overlaid Contour Plot, Response Optimizer

But once your response has that little green check box that says you have a valid model, there’s even more that you can do. For example, you can also use conditional formatting to highlight two kinds of rows:

  • Unusual combinations of predictor values
  • Values of the response variable that the model does not explain well

Want to try it out? You can follow along using this data set about how deep a stream is and how fast the water flows. Open the data set in Minitab, then:

  1. Choose Stat > Regression > Regression > Fit Regression Model.
  2. In Response, enter Flow.
  3. In Continuous Predictors, enter Depth.
  4. In Categorical Predictors, enter Location. Click OK.

Once you’ve clicked OK, the green checkbox will appear in your worksheet to show that you have a valid model.

The green square with a white checkmark shows that the column is a response variable for a current model.

To show unusual combinations of predictors, follow these steps:

  1. Choose Data > Conditional Formatting > Statistical > Unusual X.
  2. In Response, enter Flow. Click OK.

The text and background color for the response value in row 7 changes so that you can see that it’s unusual to have a depth of 0.76 in the first stream.

The value of the response in the row with the unusual X value has red shading and red letters.

You can indicate values that aren’t fit well by the model in a similar fashion.

  1. Choose Data > Conditional Formatting > Statistical > Large Residual.
  2. In Response, enter Flow.
  3. In Style, select Yellow. Click OK.

Now, in the worksheet, the unusual combinations of predictors are red and the values that aren’t fit well by the model are yellow:

The unusual cell with the response value for the row with an unusual X value has a red theme. The cell with the response value for a row that the model does not fit well has a yellow theme.

Not all of the ways that Minitab can conditionally format depend on the model. If you’re ready for more, take a look at the online support center to see examples of these other uses of conditional formats: