Description
Open “Prep 2.2” Excel file that I attached here. Data for the two questions can be found on different sheets. Use the Excel file for computation and charts and a Word document for your written answers.Open “transportation” sheet in “Prep 2.2” Excel file. The city’s Department of Transportation has been keeping track of accidents on a particularly dangerous stretch of highway. Early in this year, the city lowered the speed limit on this highway and increased police patrols. Data on number of accidents before and after the changes are presented in the Excel sheet. Did the change work? Is the highway safer? Construct a line chart in Excel to display these two sets of data and write a paragraph (150 words) describing the changes. Copy-paste the chart from MS Excel to MS Word and add it to your text.Open “gun control” sheet in “Prep 2.2” Excel file.The score of 15 respondents on four variables are reported in the Excel sheet. The numerical codes for the variables can be also found there. Construct a frequency distribution for each variable. Include a column for percentages.Construct pie and bar charts in Excel to display the distributions of sex, support for gun control, and level of education. Provide a paragraph describing the dataset. Copy-paste the tables and charts from MS Excel to MS Word and add it to your text.
Unformatted Attachment Preview
Month
Jan
Feb
March
April
May
June
July
Aug
Sept
Oct
Nov
Dec
12 Montths Before 12 Months After
23
25
25
21
20
18
19
12
15
9
17
10
24
11
28
15
23
17
20
14
21
18
22
20
Case number
Sex
1= Male
2= Female
Support of Gun Control
1= In favor
2= Opposed
Level of Education
0= Less than HS
1= HS
2= Jr. college
3= Bachelor’s
4= Graduate
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Support of Gun
Control
Sex
2
1
2
1
2
1
2
1
1
2
1
1
1
2
1
Level of
Education
1
2
1
1
1
1
2
1
2
1
1
1
1
1
1
Age
1
1
3
2
3
1
0
1
0
1
4
4
0
1
1
45
48
55
32
33
28
77
50
43
48
33
35
39
25
23
Purchase answer to see full
attachment
