[SOLUTION] Social Cohesion Measures
The dataset for this portion of the assignment is data from the Seattle Public Safety Survey and is labeled Safety_Survey_Midterm.sav. IMPORTANT: Use only the dataset linked from the Assignments page where the Midterm information is located and where you downloaded this document.There are multiple variables that capture information about the respondents and their views on public safety related issues in the Seattle area. To be eligible to complete the survey, respondents need to live and/or work in Seattle. Please type your answers directly into this document and insert all graphs and tables requested into this document. In addition, save your output and submit it with this file.10. (5 points). Create two pie charts that compare the distribution of individuals who did not report their victimization (NO_REPORT) between whether the respondent identified as female or not (FEMALE). Edit the graph so that it is presentable and copy and paste it into this document. Explain what differences, if any, do you see between the two pie charts.11. (5 points). Create a scatterplot that explores the relationship between a respondents perception of social disorganization in their neighborhood (SOCIAL_DISORGANIZATION_SCALE) and their fear of crime (FEAR_CRIME_SCALE). Social disorganization measures a respondents perception of visible problems in their neighborhood, such as broken windows, graffiti, etc Fear of crime measures how often they think about, or are fearful of, criminal victimization. Edit the graph so that it is presentable and copy and paste it into this document. What trends do you see in the data? Offer an explanation for why you think that might be.12. (5 points). Using the year the respondent completed the survey (SURVEY_YEAR) and whether the respondent was victimized or not (VCTM_YES), create a multiple line graph. Edit the graph so that it is presentable and copy and paste it into this document. Interpret your graph for me (i.e. explain the patterns you see in the data).13. (5 points). Using the variable for social cohesion (SOCIAL_COHESION_SCALE) request and report on the three main measures of central tendency we discussed in class as well as the three measures of variability/dispersion.14. (5 points). Request frequency tables for marital status (MARITAL_STATUS) and the age of the respondent (AGE). Answer the below questions.a. What is the mode for marital status?b. What % of respondents were single?c. For respondents who provided information about their age, what percent were younger than 60?d. What is the scale of measurement for age?15. (5 points). Recode age into the following categories: 29 and younger, 30-49, 50-69, 70 and older. Request a frequency table and bar chart for this new variable. Paste both below.16. (5 points). Request and report the mean for social cohesion (SOCIAL_COHESION_SCALE). Social cohesion measures how well one believes their neighborhood works together. Typically, neighborhoods with high social cohesion contain individuals who know each other, share similar values, and look out for each other. Now, filter your data so that you are only looking at respondents who reported they were retired (RETIRED). Request and report on the mean again. Explain what differences, if any, you see in the means for the social cohesion scale across the two groups (All respondents vs retired respondents).17. (15 points). Compute a new variable (POLICE_LEGITIMACY_SCALE) by summing the following variables: POLICE_LEGITIMACY_1 through POLICE_LEGITMACY_19.a. Report all measures of central tendency and variability for this new variable.b. Now, ask SPSS to convert this new variable to Z-scores and report all measures of central tendency and variability for this new standardized variable.c. Create a histogram for both your new POLICE_LEGITIMACY_SCALE variable and the variable of Z-scores. Paste them below.