Data Analysis with Microsoft Excel: Updated for Office 2007

88 Excel

By observing the placement of the points on the scatter plot, you can get

a general impression of the relationship between the two sets of values. For

example, the scatter plot of Figure 3-5 shows that high values of Variable 1

are associated with low values of Variable 2. This is not a perfect associa-

tion; rather, there is some scatter in the points.

point corresponds to an

observation with the pair

of values (3, 5)

y axis

x axis

Figure 3-4

The

rectangular

coordinate

system of a

scatter plot

high y values are

associated with

low x values

Figure 3-5

Scatter plot

displays a

general

relation

between

two sets of

values

The scatter plot you’ll create will have the graduation rate for each uni-

versity on the y axis and the university’s average SAT score on the x axis.

To create a chart, you insert a chart object on the worksheet using the Excel

Insert tab.