1. Use the Punitiveness.xls data,correlate collective_efficacy (respondents' perceived collective efficacy in their neighborhood) and punitiveness (respondents' support for punitive criminal justice policies) inExcel.Copy and pastethe Excel output here.Summarize your results and make sure that you briefly explain what this correlation means to you in terms of the impact of collective efficacy on respondents' support for punitive criminal justice policies (direction of the correlation, correlation coefficient, and test of significance result).

person sex race age crime recidivism | custody 2 27 Close 1 2 41 Medium 1 34 2 0 Minimum A 2 61 Medium 2 75 Close 1 34 2 Medium 21 Close 2 37 0 Medium 60 2 0 Close 10 2 30 2 0| Medium 11 2 29 2 0 Medium 12 1 1 71 0 Medium 13 2 22 0 Minimum 14 2 28 0 Minimum 15 2 40 0 Medium 16 21 61 2 1 Close 17 1 42 1 1 Medium 18 1 21 71 1 1 Medium 19 2 67 Medium 20 2 45 0 Minimum 21 2 41 2 Close 22 1 2 27 Close 23 2 33 3 Close 24 2 56 Close 25 36 0 Minimum 26 1 64 Minimum 27 2 55 2 0 Medium 28 2 55 2 Medium 29 2 54 Medium 30 1 71 1 Minimum