Data Analysis

Data Analysis – Quiz #6 (Due 6/14) To answer the following questions, please open the Excel file (i.e., the data) included in the current folder. Download the current word document, and type directly on it to answer the questions. You will also need to copy and paste the charts and graphs you create in Excel to this word document. Make sure to add a header to the Chart and make them look pretty. Once you have finished the quiz, upload the completed word document with your answers. The excel sheet includes data on a sample of persons (anonymized), who were asked about their criminal history (survey conducted between 2015 and 2019 in NJ). Questions 1. Create a line graph that looks at the Number of Crimes committed (using the “How Many Crimes Have You Committed this Year?”) variable by the Year variable. In other words, how many crimes (in total) were committed each Year. Remember, you will need to create a new “Sheet” for this, and create new cells by doing additions of the # of crimes variable by the Year variable. Copy and paste the graph from Excel into this word doc. 2. Explain the findings from the graph you created in Q1. Include as much detail as you can and address what you find interesting. 3. Create a bar graph that looks at Sex by “Type of Crime”. Remember, you will need to create a new “Sheet” for this, and create new cells by doing additions of Sex (i.e., Male and Female) by “Type of Crime”. Copy and paste the graph from Excel into this word doc. 4. Explain the findings from the graph you created in Q3. Include as much detail as you can and address what you find interesting. 5. Create a pie chart that looks at “Have you ever committed a crime?” (no = 0; yes = 1). Copy and paste the graph from Excel into this word doc. 6. Explain the findings from the graph you created in Q5. Include as much detail as you can and address what you find interesting. Student Anonymized ID # 1 2 4 13 24 35 46 48 49 50 51 52 53 54 55 56 57 58 59 68 79 90 5 6 7 8 9 10 11 12 14 Year 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2016 2016 2016 2016 2016 2016 2016 2016 2016 Have you ever committed a crime? (no = 0; yes = 1) 1 1 1 1 1 0 0 1 1 1 0 0 1 0 1 1 1 1 1 0 1 1 0 1 1 1 1 1 1 1 1 Student Anonymized ID # 15 16 17 18 60 61 62 63 64 65 66 67 69 70 71 72 73 19 20 21 22 23 25 26 27 28 74 75 76 77 78 Year 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 Have you ever committed a crime? (no = 0; yes = 1) 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Student Anonymized ID # 80 81 82 83 29 30 31 32 33 34 36 37 38 84 85 86 87 88 89 91 92 93 3 39 40 41 42 43 44 45 47 Year 2017 2017 2017 2017 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2019 2019 2019 2019 2019 2019 2019 2019 2019 Have you ever committed a crime? (no = 0; yes = 1) 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 1 1 1 1 Student Anonymized ID # 94 95 96 97 98 99 100 Year 2019 2019 2019 2019 2019 2019 2019 Have you ever committed a crime? (no = 0; yes = 1) 0 0 1 0 1 1 1 Student Anonymized ID # 1 2 4 13 24 35 46 48 49 50 51 52 53 54 55 56 57 58 59 68 79 90 5 6 7 8 9 10 11 12 14 Type of crime: (0 = NA; 1 = Misdemeanor; 2 = Non-Violent Felony; 3 = Violent Felony) 1 1 2 2 3 0 0 1 2 3 0 0 1 0 1 1 1 1 2 0 1 1 0 1 3 3 3 3 2 2 2 Student Anonymized ID # 15 16 17 18 60 61 62 63 64 65 66 67 69 70 71 72 73 19 20 21 22 23 25 26 27 28 74 75 76 77 78 Type of crime: (0 = NA; 1 = Misdemeanor; 2 = Non-Violent Felony; 3 = Violent Felony) 2 2 0 1 1 1 3 3 3 3 2 2 2 2 2 0 1 1 1 3 2 1 1 1 2 3 1 1 3 2 1 Student Anonymized ID # 80 81 82 83 29 30 31 32 33 34 36 37 38 84 85 86 87 88 89 91 92 93 3 39 40 41 42 43 44 45 47 Type of crime: (0 = NA; 1 = Misdemeanor; 2 = Non-Violent Felony; 3 = Violent Felony) 1 1 2 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 2 0 2 1 2 3 Student Anonymized ID # 94 95 96 97 98 99 100 Type of crime: (0 = NA; 1 = Misdemeanor; 2 = Non-Violent Felony; 3 = Violent Felony) 0 0 2 0 2 1 2 Student Anonymized ID # 1 2 4 13 24 35 46 48 49 50 51 52 53 54 55 56 57 58 59 68 79 90 5 6 7 8 9 10 11 12 14 How Many Crimes Have You Committed this Year? 1 2 18 16 5 0 0 1 16 5 0 0 3 0 4 5 3 2 18 0 4 5 0 1 12 17 18 12 17 10 12 Subject Age 18 18 17 18 19 29 27 18 18 19 29 27 22 21 22 19 22 18 17 21 22 19 40 18 17 18 19 20 21 20 21 Student Anonymized ID # 15 16 17 18 60 61 62 63 64 65 66 67 69 70 71 72 73 19 20 21 22 23 25 26 27 28 74 75 76 77 78 How Many Crimes Have You Committed this Year? 11 10 0 5 2 1 12 17 18 12 17 10 12 11 10 0 5 11 7 10 13 12 1 2 3 4 11 7 10 13 12 Subject Age 20 19 29 19 40 18 17 18 19 20 21 20 21 20 19 29 19 19 19 20 22 21 20 20 21 20 19 19 20 22 21 Student Anonymized ID # 80 81 82 83 29 30 31 32 33 34 36 37 38 84 85 86 87 88 89 91 92 93 3 39 40 41 42 43 44 45 47 How Many Crimes Have You Committed this Year? 1 2 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 17 0 0 12 0 9 2 4 17 Subject Age 20 20 21 20 27 25 26 27 28 29 30 31 32 27 25 26 27 28 29 30 31 32 22 27 27 19 25 20 22 33 22 Student Anonymized ID # 94 95 96 97 98 99 100 How Many Crimes Have You Committed this Year? 0 0 12 0 9 2 4 Subject Age 27 27 19 25 20 22 33 Student Anonymized ID # 1 2 4 13 24 35 46 48 49 50 51 52 53 54 55 56 57 58 59 68 79 90 5 6 7 8 9 10 11 12 14 Subject Sex Male Female Male Male Female Male Female Male Male Female Male Female Male Male Male Female Male Female Male Male Male Female Female Female Male Male Male Male Male Male Male Student Anonymized ID # 15 16 17 18 60 61 62 63 64 65 66 67 69 70 71 72 73 19 20 21 22 23 25 26 27 28 74 75 76 77 78 Subject Sex Male Male Female Male Female Female Male Male Male Male Male Male Male Male Male Female Male Male Male Male Male Male Female Female Female Female Male Male Male Male Male Student Anonymized ID # 80 81 82 83 29 30 31 32 33 34 36 37 38 84 85 86 87 88 89 91 92 93 3 39 40 41 42 43 44 45 47 Subject Sex Female Female Female Female Male Female Female Female Male Female Female Female Female Male Female Female Female Male Female Female Female Female Male Female Female Male Male Male Female Female Male Student Anonymized ID # 94 95 96 97 98 99 100 Subject Sex Female Female Male Male Male Female Female Student Anonymized ID # 1 2 4 13 24 35 46 48 49 50 51 52 53 54 55 56 57 58 59 68 79 90 5 6 7 8 9 10 11 12 14 Student Anonymized ID # 15 16 17 18 60 61 62 63 64 65 66 67 69 70 71 72 73 19 20 21 22 23 25 26 27 28 74 75 76 77 78 Student Anonymized ID # 80 81 82 83 29 30 31 32 33 34 36 37 38 84 85 86 87 88 89 91 92 93 3 39 40 41 42 43 44 45 47 Student Anonymized ID # 94 95 96 97 98 99 100
Purchase answer to see full attachment

Just $7 Welcome
Order Now