assignment 5 tutorial

Document Sample
assignment 5 tutorial Powered By Docstoc
					Tutorial for Sociology 300 Assignment #5.

This document outlines the 4 steps it will take to conduct the analyses necessary for assignment 4. Be aware
that the assignment requires you to do some work both before and after conducting the analyses outlined in
this document.

1. Prepare yourself with the tools to conduct the analysis.

In order to conduct this analysis you will need 2 things:

        1.    Survey data.
                The data are available on the course web-page
                http://www.soc.washington.edu/academics/courses/classpage.asp?cid=2101
                Click on Files for Download, Employment Survey Data.

        2.    A computer that has Microsoft Excel and includes the Excel data analysis tool pack.
              In an Excel 2010 version, you can verify that the computer you are working on has the data
                analysis tool pack installed by opening Microsoft Excel on your computer, go to the Data
                menu, and look for an option called Data Analysis. If it is listed, you are ready to get
                started. If it is not listed, you will need to install it (or find a computer that has it). In order
                to install it go to the File menu, go to Options along the left hand column, choose Add-Ins
                along the left-hand column of window that pops up. On the bottom of the window, where it
                says Manage: Excel Add-ins click Go. A new window will appear, check the box for
                Analysis ToolPak and click OK. Some computers will require the original software
                installation CD/DVD to do this and others will not. University/Lab computers should all
                have this tool pack already installed.
              For older versions, open Microsoft Excel on your computer, go to the Tools menu, and
                check to see if Data Analysis is listed (typically one of the last options) in the Tools menu.
                If it is listed, you are ready to get started. If it is not listed, you will need to install it (or find
                a computer that has it). In order to install it, go to the Tools menu, and select Add-Ins,
                select Analysis ToolPak, and click OK. Some computers will require the original software
                installation CD/DVD to do this and others will not. University/Lab computers should all
                have this tool pack already installed.

2. Open the data in Microsoft Excel and examine it.

The data should open in Microsoft Excel automatically when you click on the web-link. If it doesn’t, you
may have to save the data to your computer and then open it manually. In order to open the data manually,
go to the File menu, and select Open. Find the data wherever you have stored it (e.g.,
C:Soc300/employment_survey.xls) and click on it.

Take a careful look at the data. There are 33 columns and 162 rows. The first row is a header row with
labels. The labels should be self-explanatory. If you need more information go back to the catalyst web-
survey to look at the questions as they were asked. There are three additional bits of information.

Column A = Sex of Respondent (Student)
Column B = Sex of Applicant (Allyson or Matt)
Column C = Applicant Revealed is Parent (Candidates 2 & 4)

3. Calculate summary statistics to answer your research question. You might begin by just calculating
summary statistics for the whole sample. There are lots of ways to generate summary statistics including the


                                                           1
mean and median in Excel. One way is to use the data analysis package to generate summary statistics. For
example, it may be useful to start by looking at the mean annual salary (Column Y). In order to do this,
follow the next 4 steps:

    1.    Go to the Data menu (or Tools menu in pre 2010 versions of Excel) and choose Data Analysis.
    2.    A dialog box should open. In the box, choose Descriptive Statistics, and click OK.
    3.    Select the columns for which you wish to obtain summary statistics. For example, if I want to
          examine mean annual salary (Column Y), I can either type $Y:$Y, or select the column using the
          mouse. Be sure to indicate that the data are grouped by Columns, check the box marked Labels in
          the First Row, and (I recommend) send the output to New Worksheet, and mark the box for
          Summary Statistics. Select OK.
    4.    These steps should produce a table with summary statistics for annual salary. You might notice
          that the mean and the median annual salary are included. There are a lot of other statistics in the
          chart, but for now let’s just concentrate on the mean and median. NOTE: You will get an error if
          there is missing data or if some data is not in numerical format. You will need to decide how to
          best respond to these issues.

In order to do the assignment you need to do more than just generate summary statistics for the whole
sample. The assignment requires that you compare at least two groups. For example, imagine you are
interested in how recommendations for annual salary vary based on the gender of the applicant. That is,
how does the annual salary recommended vary between men and women applicants?

In order to do this, follow the next 6 steps:

    1.    First you need to sort the data into the groups that you are interested in (in this case, men and
          women). Go to the Data menu, choose Sort. In the dialogue box you can choose how to sort the
          data. Type in (or select) the variable you want to sort the data on. In this case, you will select Sex
          of Applicant. While it doesn’t matter if you sort the data in ascending or descending order, it may
          be simplest to sort in ascending order. As a result you will have a dataset where all the men are
          listed first (Sex = 1), and all the women are listed second (Sex = 2). Be sure to check Header row
          at the bottom of the box. Click OK.
    2.    Go to the Tools menu and choose Data Analysis.
    3.    A dialog box should open. In the box, choose Descriptive Statistics, and click OK.
    4.    Select the columns for which you wish to obtain summary statistics. For example, if I want to
          examine annual salary (Column Y) for men, I can either type Y78:Y162, or select the cells you
          want to summarize using the mouse. Be sure to indicate that the data are grouped by Columns,
          check the box marked Labels in the First Row, and (I recommend) send the output to New
          Worksheet, and mark the box for Summary Statistics. Select OK.
    5.    These steps should produce a table with summary statistics for annual salary for men. You might
          notice that the table includes the mean and the median. There are a lot of other statistics in the
          chart, but for now let’s just concentrate on the mean and median.
    6.    Repeat steps 2-5, this time selecting women (Y2:Y77). What is the mean and the median annual
          salary recommended?


4. Last you need to make a table or graph (in Excel or a word processing program) that illustrates what
you’ve found. It can be as simple as a table showing differences in annual salary recommended for men and
women. You might also think about how you can make a bar graph or chart to illustrate what you’ve found.

If you want to make a chart, I’d recommend making an Excel spreadsheet of your own, listing each variable
in a different column and using Excel. For example, enter the information from in an Excel spreadsheet. To


                                                       2
make a chart, go to the Insert menu and select Chart. This opens the chart wizard. In order to make a chart
you need to follow the next four steps:

    1.   Choose what type of chart you’d like to make.
    2.   Select the data you’d like to include in your chart.
    3.   Make sure to include a title and labels on your chart. Make sure your labels are succinct and
         informative.
    4.   Save the chart. Excel will default to put the chart into your current spreadsheet. You can also
         choose to have it make a new worksheet with the chart.




                                                      3

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:1
posted:2/6/2012
language:
pages:3