Evaluation of Correlation

Data are gathered regarding the length of tenure top executives have at a major corporation and whether those executives have been divorced.  The Human Resources department is evaluating this data to drive decision-making in regard to their hiring process.  The data for eight executives is as follows:

 
In a three to five page paper, excluding title page and reference page(s), answer the following questions to analyze the data.  Include clearly labeled calculations, if applicable.  Calculations conducted in Excel must be copied and pasted into the Word document.  This paper should be formatted according to APA guidelines outlined in the Ashford Writing Center.

1. What’s the most appropriate procedure for evaluating the relationship between tenure and divorce?
2. What is the correlation and how can it be interpreted in terms of magnitude, direction and practical importance?
3. How much of whether executives have been divorced can be accounted for by their length of tenure with the organization? How much of tenure can be explained by whether there has been a divorce?
4. Make a logical argument for why lengthy tenure may be causing divorce.
5. Make another logical argument for why divorce may be causing lengthy tenure.  

Make sure to support your arguments with at least two articles from the Ashford Library or other scholarly sources.  All calculations conducted in Excel must be copied and pasted into the Word document before submission.  Be sure to clearly label all calculations.

CJ 301

Independent Project 1

UNIVARIATE ANALASYS: CHAPTER 4- SPSS

Due date: March 22 – Sunday by midnight

PLEASE BE CAREFUL: THER ARE 2 PARTS

Name: ____________________________________________________________

PART 1 – INDEPENDENT PROJECT A – CHAPTER 4

Please move carefully through this assignment, thinking about which statistical tool you need to use from your SPSS output to answer each question.

You have to read Chapter 4 in your textbook, materials under the Learning Modules and complete all exercises in order to complete this assignment.

Using “2004GSS.SAV”,    I will provide the data set under the Assignment tool. 

 recode the variable AGE into a new variable called AGE2 with categories for:

• Teens

• Twenties

• Thirties, and so on.

•  

  Be sure to include the new variable labels for the variable AGE2.

  Request a frequency chart for AGE2 and answer the following questions:

   

1. How many respondents are in their forties?

    

2. What percentage is under fifty?

    

3. Which category has the fewest cases?

    

   **Instruction to complete this question:

    

   Below is some very helpful advice on completing the RECODE procedures for variable AGE into AGE2.

    

    

1. When you RECODE the AGE variable into AGE2, it is very important NOT to double count any of the original values of AGE.  First, you need to do a frequency distribution on the variable AGE so that you can examine all of the values of AGE and you will be able to identify the VALID VALUES (this means non-missing values) of AGE and make intelligent, thoughtful, choices for the categories to be created when you create AGE2.  I have the following suggestions.

1. When you create the category for teens, your range should be from LOWEST thru 19, and you need to assign this category a value of 1. 

    

2. For the category of twenties, your range should be 20 thru 29, and you need to assign this category a value of 2. 

    

    

3. For the category of thirties, your range should be 30 thru 39, and you should assign this category a value of 3. 

    

    

4. Continue with this logic until you have exhausted all the VALID (this means non-missing values) for the AGE variable. 

    

    

5. The final category for this variable will be eighties.  Now you need to specify that all other values will be coded as SYSTEM MISSING by clicking the “All other values” button on the left hand side of the screen, clicking the “System-missing” button on the right hand side, and then clicking the ADD button. 

    

    

6. Now check the display box to verify that you have created the categories that you need and click the CONTINUE button at the bottom of the screen to send you back to the RECODE display screen.  Once here, you need to click OK and AGE2 will be created. 

    

    

7. You can find your variable by scrolling to the far right side of your data mix where you will see your newly created AGE2 variable.

    

• Once you have successfully created AGE2, I want you to go through the assignment of defining the data by creating a VARIABLE LABEL, VALUE LABELS, and removing all of the decimals (since the decimals are not required for the analysis).  To do this you need to follow the instructions in Chapter 4 on p. 64.  The steps are:

   

  1. Click on the VARIABLE VIEW tab in the lower left hand corner of the screen displaying the GSS data set.  You will then see a screen displaying several rows and columns of information about each variable in your data set.  You need to find your newly created AGE2 variable.  It is the very last variable in the list of variables. 

  2. To eliminate the decimals in your newly created AGE2 variable, go to the column labeled decimals for AGE2 and click once.  You will see two arrows, one point up and one pointing down.  These arrows control the number of decimal places that will be displayed in the DATA VIEW.  Click on the down arrow until the number 0 is displayed.

  3. To add a VARIABLE LABEL, move to the column under LABELS and click.  Now you can type a label that makes sense to you such as “Age Categories”.

  4. To add VALUE LABELS, move to the column under VALUES and click once.  You will see a shaded box.  Click once on that shaded box and you will see a value labels box that has no information in it.  Move your mouse into the box adjacent to “Value” and enter a 1.  Then move your mouse to the box adjacent to “Value Labels” and enter “Teens”.  Then click the ADD button and you will see your VALUE LABEL appear in the display box. 

  5. Continue this process until you have entered the VALUE LABELS for all of your AGE2 age categories.  Once you have entered all of the VALUE LABELS, click CONTINUE, and then click OK at the bottom of the “Define Variable” box.

  6. You have now successfully defined all the values for your newly created AGE2 variable.

      

      

1. After you complete this assignment I advise you to save the dataset in its current form as there is a good chance that we will use these recoded variables again in the class and you will avoid going through the exercise of recoding AGE into AGE2.

PART 2 – INDEPENDENT PROJECT B – CHAPTER 4

Request a descriptive statistics – frequencies for the variable CHLDIDEL (ideal number of children) in data set “2004GSS.SAV”. Fill in the following information:

1. The minimum response for ideal number of children is ______________

    

2. The maximum response for ideal number of children is __________

    

    

3. The mode response for ideal number of children is _____________

    

    

4. _______________ respondents answered this question.

    

    

5. The mean ideal number of children is ___________________

    

    

6. The standard deviation for CHLDIDEL is __________________

    

    Using “2004GSS.SAV”,    Please find the data set – GSS.SAV attached.
   2004gssnew-2.sav