Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 9 Multiple Regression 369

The plots are shown in a cascading format, in which the plot title is often

the only visible element of a chart. When you click a chart title, the chart

goes to the front of the stack. The charts are small and hard to read, how-

ever. You can better view each chart by placing it on a chart sheet of its own.

Try doing this with the plot of the residuals versus Alg Place.

To view the chart:

1 Click the chart Alg Place Residual Plot (located in the range L5:Q14).

2 Click the Move Chart button from the Location group on the Design

tab of the Chart Tools ribbon.

3 Click the As new sheet option button and type Alg Place Residual

Plot in the accompanying text box. Click OK.

The scatter plot is moved to a chart sheet shown in Figure 9-10.

Figure 9-10
Alg Place
residual plot

Does the spread of the residual values appear constant for differing

values of the algebra placement score? It appears that the spread of the re-

siduals is wider for lower values of Alg Place. This might indicate that you

have to transform the data, perhaps using the arcsine transformation just

discussed.