Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 9 Multiple Regression 381

To see whether females are paid about the same salary that would be pre-

dicted if they were males, create a scatter plot of residuals versus predicted

salary.

To create the scatter plot:

1 Using either the StatPlus Fast Scatterplot command or the Scatter-

plot button on the Insert tab, create a scatterplot of the Residuals

(H1:H38) versus Predicted Salary (G1:G38).

2 Give a chart title of Female Residual Plot, and label the x axis

Predicted Salaries and the y axis Residuals. Save the chart to a chart

sheet named Female Residual Plot.

3 Change the scale of the x axis from 0–45,000 to 20,000–40,000. Your

chart sheet should resemble that shown in Figure 9-18.

Figure 9-17

Predicted

salaries and

data for the
female
faculty