Chapter 3 Working with Charts 123
STATPLUS TIPS
You can quickly create your own scatter plots using StatPlus. To
create a scatter plot with the add-in, click Single Variable Charts
and then Fast Scatterplot from the StatPlus menu.
In the same way you can quickly create your own bubble plots
using StatPlus. To create a bubble plot, click Multi-Variable
Charts and then Fast Bubble Plot from the StatPlus menu.
You’ve completed your work on the Big Ten scatter plots. You can now
close the workbook, saving your changes.
Exercises
•
•
- You decide to investigate whether there
is any relationship between the gradu-
ation rate for student athletes and the
race of the athlete. To do this, open the
Big Ten workbook you examined in
this chapter and perform the following
analyses:
a. Open the Big Ten workbook from the
Chapter02 folder and save it as Big
Ten Graduation by Race.
b. Create a scatter plot with the calcu-
lated SAT score on the x axis and the
white male and black male gradua-
tion rates on the y axis. Title the chart
Graduation Percentages by Race.
Title the y axis Graduation Percent-
ages and the x axis Calculated SAT
Values. Move your scatter plot to a
chart sheet named Male Graduation
by Race.
c. Edit the scale of the x and y axes to
refl ect the range of data values.
d. Add labels to the scatter plot, iden-
tifying each university. Compare the
black male graduation rate for each
university to the corresponding white
male graduation rate. What do you
observe?
e. Repeat your analysis, this time
comparing female graduation rates
by race. Save your graph on a chart
sheet named Female Graduation
by Race.
f. Save your workbook and write
a brief report summarizing your
observations.
- In the 1980s female professors at a
junior college sought help from statisti-
cians to show that they were underpaid
relative to their male counterparts. The
legal action was eventually settled out
of court. Investigate their claim by creat-
ing scatter plots of the salary data they
acquired for their case.
a. Open the Junior College workbook
from the Chapter02 folder and save it
as Junior College Salary Charts.
b. Create a scatter plot with Salary on
the y-axis and Years on the x-axis.
Title the scatter plot Employee
Salaries. Title the y axis Salary and
the x axis Years Employed. Remove
the legend and gridlines from the
plot. Save the plot as a chart sheet
named Salary by Gender Chart.
