Chapter 9 Multiple Regression 3653 Click the y-axis button and select Calc from the list of range names
and click the OK button.
4 Click the Chart Options button and enter Calculus Scores for the
chart title, Predicted for the x axis title, and Observed for the y axis
title. Click the OK button.
5 Click the Output button and save the chart to the Observed vs.
Predicted chart sheet. Click OK.
6 Click the OK button to generate the scatter plot.
7 Rescale the x axis and y axis in the plot so that the ranges go from 40
to 100 rather than from 0 to 100 or 0 to 120.
The fi nal form of the scatter plot should look like Figure 9-7.Figure 9-7
Scatter plot
of observed
and predicted
scores
How good is the prediction shown here? Is there a narrow range of ob-
served values for a given predicted value? This plot is a slight improvement
on the plot of Calc versus Alg Place from the scatter plot matrix in Chapter 8.
Figure 9-7 should be better because Alg Place and fi ve other predictors are
being used here.