Data Analysis with Microsoft Excel: Updated for Office 2007

364 Statistical Methods

Now create a scatter plot of the data in the range H1:I81.

To create the scatter plot of the observed scores versus the predicted

scores:

1 Click Single Variable Charts from the StatPlus menu and then click

Fast Scatterplot.

2 Click the x-axis button and then click the Use Range References

option button and select the range H1:H81 from the worksheet. Click

the OK button.

Figure 9-6
Predicted
and observed
calculus
scores

To copy the observed scores:

1 Select the range B29:B109 and click the Copy button from the

Clipboard group on the Home tab.

2 Click the Calculus Data sheet tab.

3 Select the range H1:H81; right-click the selection and click Insert

Copied Cells from the popup menu to paste the predicted values

into column H.

4 Click the Shift Cells Right option button to move the observed cal-

culus scores into column I; then click OK.

The predicted calculus scores appear in column H, as shown in

Figure 9-6 (formatted to show the column labels).