Want to know how to create a scatter plot in Excel? Here's a guide on how we created a simple chart based on performance numbers.

A residual-by-predicted plot, as illustrated by the plot on the left in Figure 39.25, is a plot of residuals versus predicted response for each observation. See the "Predicted Values" and "Residuals" ...

Click the "Insert" tab, choose "Insert Scatter (X,Y) or Bubble Chart" from the Charts group and select the first "Scatter" option to create a residual plot.