Math 210
Laboratory 2
Displaying Data
In this lab we will display and analyze data graphically. We
will
be using a data set that includes the mean salary of public school
teachers
for each state for the school year 2000-01. These data were
obtained
from the National Education Association website (www.nea.org). We
will also look at state mean scores for the SAT as well as the percent
of students that took the test. These data were obtained from the
College Board website (www.collegeboard.com).
Click here to find the data set. Select
all of the data set, copy it, and paste it into a Minitab
worksheet.
When you paste the document, make sure you have your cursor in the
upper
left gray cell - not in row 1. Using the data set, answer the
following
questions.
- Teacher Salary.
Make a stem-and-leaf diagram for the teacher pay. (Graph
> Stem-and-Leaf, double click on Teacher_Pay and click OK.)
- Copy this stem-and-leaf diagram into Word. When doing so, use
the courier
font. This will keep the columns aligned.
- Briefly
describe the shape, center, and spread of the distribution of your
distribution.
- What is the average teacher
salary in Michigan? Make the number (leaf) associated with
Michigan's
mean teacher salary bold in your stemplot.
- What are the scores for the SAT math
test?
- Make a histogram of the distribution of the SAT math scores. (Graph
> Histogram, click OK in the first window
that pops up, in the second window double click on SAT-M and click OK.)
- Give your histogram a better title. (Double click on the current title and a
window will pop up allowing you to make any change you want.)
- Find the center of the data and mark this with an X on your
histogram.
(Right click on the histogram, click on Add > Title and type in X, and click OK. Now move the X to the appropriate spot.)
- Copy your histogram
and paste in in Word. (To copy the histogram right-click the
mouse in the histogram window and select copy graph.)
- Briefly describe the overall shape of the
distribution.
- What percentage of students take the
SAT?
- Make a histogram of the distribution of the percent of high
school
seniors
who take the SAT. (Graph > Histogram, double
click on % taking, and click OK.)
- Make the horizontal
axis of your graph go from 0 to 100 in increments of 10. (Double
click on the horizontal axis on your histogram, choose the Binning
tab, click on
Cutpoint, click on
Midpoint/cutpoint
positions: and type in
0:100/10.)
Give your histogram a better title. Copy and paste your histogram
into
Word.
For the last question of the lab we will look the distribution of the
types of Girl Scout cookies a local Brownie troop sold in 2004.
Click here to find the
data set. Select
all of the data set, copy it, and paste it into a Minitab worksheet.
- Making a pie chart.
- Make
a pie chart of the cookie data. To do this click on Graph
> Pie Chart then
click on Chart
values from table and in Categorical
variable:
put "Cookie Type" and for Summary
variables:
put "Number of Boxes." and click OK.
- Put the categoral variables on the pie chart next to the
appropritate slices. (Double click on the pie chart, click on the
Slice
Labels tab and put checks in the Category name,
Frequency, and Percent boxes. Click on the legend box next
to the right of the pie chart and hit the delete key.)
- Give your pie chart an appropriate title.
- Copy and paste your pie chart into Word.
- Which type of cookie was sold the most? How many boxes
were sold and what percentage of all sold were of this type?
- Which type of cookie was sold the least? How many boxes
were sold and what percentage of all sold were of this type?