In this lab we will display and analyze data graphically and numerically.  We will be using a data set that includes the mean salary of public school teachers for each state for the school year 2003-04.  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 in 2003.  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.
 

1. Teacher Salary.  Make a stem-and-leaf diagram for the teacher pay. (Graph > Stem-and-Leaf, double click on Teacher_Pay and click OK.)  
1. Copy this stem-and-leaf diagram into Word. When doing so, use the courier font. This will keep the columns aligned.
2. What is the average teacher salary in Michigan?  Make the number (leaf) associated with Michigan's mean teacher salary bold in your stemplot.
3. Briefly describe the shape of this distribution.
4. Find the mean and median for teacher pay.  (Stat > Basic Statistics > Display Descriptive Statistics)  How do these numbers relate to the shape of the distribution?
5. The mean teacher salary in the United States in 2003-04 was $46,752.  Why is this different than the mean you calculated in the previous question?
   

2. What are the scores for the SAT verbal test? 

• Make a histogram of the distribution of the SAT verbal scores. (Graph > Histogram,  click OK in the first window that pops up, in the second window double click on SAT-V 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.)
  

1. Copy your histogram and paste it in Word.  (To copy the histogram right-click the mouse in the histogram window and select copy graph. To paste it into Word use Edit > Paste Special > Bitmap)
2. Briefly describe the overall shape of the distribution.  
   

3. What percent 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.
  

4. 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 categorical variables on the pie chart next to the appropriate 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.

1. Copy and paste your pie chart into Word.
2. Which type of cookie was sold the most?  How many boxes were sold and what percentage of all sold were of this type?
3. Which type of cookie was sold the least?  How many boxes were sold and what percentage of all sold were of this type?