106 Excel
percentage? One way to fi nd out is to compare the values given in the pop-
up label with the values in the worksheet. For example, you could return to
the Grad Percents worksheet to see that the point identifi ed in Figure 3-20
is from the University of Minnesota (MINN), whose freshman class had an
SAT average of 1140 and an eventual graduation rate of 58%. In this fashion
you could continue to compare values between the chart and the worksheet,
fi nding out which university is associated with which data point. Of course,
this is time consuming and impractical, especially for larger data sets. Excel
doesn’t provide any other method of identifying specifi c points, but the Stat-
Plus add-in that comes with this book does provide some additional com-
mands for this purpose (if you haven’t installed StatPlus, please read the
material in Chapter 1 about StatPlus and installing add-ins).Selecting a Data Row
One of the StatPlus commands you can use to identify a particular row is
the Select Row command. This command works only if your data values
are organized into columns. To use this command, you select a single point
from the chart and then click Select Row from the StatPlus menu. Try this
now and identify the university that had the highest graduation percentage
in the Big Ten.To select a data row:1 Click a data point in the scatter plot in order to select the entire data
series.
2 Click the plot symbol highlighted in Figure 3-20 where the SAT
value is equal to 1140 and the graduation percentage is equal to 58.
Now only that plot symbol should be selected and none of the other
symbols.
3 Click StatPlus from the Menu Commands group on the Adds-Ins
tab.
4 Click Select Row from the StatPlus menu.
The eighth row should now be highlighted, indicating that the Uni-
versity of Minnesota (MINN) is the university that had the highest
graduation percentage in the Big Ten (see Figure 3-21).