Description
2 attachmentsSlide 1 of 2attachment_1attachment_1attachment_2attachment_2
Unformatted Attachment Preview
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
Tags:
data analysis
crime scene
PIE CHART
line graph
statistic analysis
User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.
Reviews, comments, and love from our customers and community: