Assignment 2

Course Project Task 2—Road Accidents Data Analysis

Scenario:

Epidemiology can use census data or survey data. Epidemiologists would love to have a complete count of everyone (census), and sometimes we need to go find and interview everyone who is exposed to a certain event. However, when describing large population trends, most often we rely on representative samples of the population to give us an indication of how big of a proportion of people are sick or at risk.

On the job, you will often be asked to provide or retrieve information. A good practice is to confirm the intended purpose and the type of data you are expected to provide before responding. You should also provide confirmation of your sources when you respond to the request.

This exercise is about what you can or cannot say when you are given certain data. Be careful to consider which aspect of the data you would use to make policy recommendations.
Each of Centervale’s three townships—Simon Township (ST), Diamond Township (DT), and Taylor Township (TT)—is responsible for traffic safety in the unincorporated areas, including maintenance and installation of roads, sidewalks, bike trails, lighting and traffic signs and lights, and snow removal. As Centervale grows and expands rapidly, with an out-migration of young families and retired couples from Metropolis, more reports of traffic accidents are appearing in the media.

Simon
Township (ST)Diamond
Township (DT)Taylor
Township (TTMorbidity (%)101828Children (0–14 years)131323Adults (15–59 years)102027Elderly (over 60 years)81834Mortality (%)52540Children (0–14 years)71935Adults (15–59 years)52940

Directions:

Based on the additional information about Centervale, your readings, and research, respond to the following:

In this module, you have been asked to clarify a news reporter’s summary statement that traffic accidents are increasing. You have been given this rather cryptic chart, and your office keeps some standard data about Centervale. The data that your office keeps is on a spreadsheet that you can

download here

. The first page of data was probably taken from the most recent Census Bureau report (2010). Another tab (or sheet) of the spreadsheet contains data that was collected by the police department. You can assume that all motor vehicle accidents with injury or death are reported.

Explain the accident rates in the data table in terms of absolute numbers and in terms of population ratios. Be careful to use age-specific denominators. Has the overall number of accidents in Centervale increased? Can you tell who is responsible for the increase?
You may use statistics, charts, or visualizations to show what is known.

When working people are hospitalized or dead, it is considered a burden to the community; the community loses a productive member. Most drivers are what we consider of working age. After puzzling over the chart, you decide that people might understand it better if you explain things in terms of hospitalizations and fatalities. You can say, for example, that 13 percent of hospitalizations of children under 15 years in Simon Township are caused by motor vehicle accidents. The chart also indicates that 40 percent of deaths in Taylor Township are caused by motor vehicle accidents

In your report, tell if you think this is realistic. Is it possible that the summed data across townships are representative of the county? Can you compare your conclusions to statewide data? What are some probable reasons that the actual data are not yet available at the state level?
Tell whether you would be critical or cynical about quality of data from the different townships. Is the data you have been given adequate to make an assessment of whether traffic accidents are increasing in number? Explain clearly what the data can be used for. Can you tell if the rate of accidents has been increasing? Explain what additional information is needed.

You should utilize at least 2 scholarly sources beyond the course readings in your research. Your paper should be written in a clear, concise, and organized manner; demonstrate ethical scholarship in accurate representation and attribution of sources; and display accurate spelling, grammar, and punctuation.

Write a 3–4-page report in Word format. Apply APA standards to citation of sources. Use the following file naming convention: LastnameFirstInitial_M1_A3 . For example, if your name is John Smith, your document will be named SmithJ_M2_A2 .

By the due date assigned, deliver your assignment to the Submissions Area.

Assignment 2 Grading Criteria

Assignment 3 Grading CriteriaMaximum PointsExplain the accident rates in the data table in terms of absolute numbers and in terms of population ratios.20Determine if the data about Centervale is realistic and if the summed data across townships are representative of the county.20Compare your conclusions to state-wide data. Explain some probable reasons why the actual data are not yet available at the state level.20Explain if you would be critical or cynical about quality of data from the different townships and what additional information would be needed.20

Academic Writing

Write in a clear, concise, and organized manner; demonstrate ethical scholarship in accurate representation and attribution of sources (i.e., APA); and display accurate spelling, grammar, and punctuation.20Total:100

Centervale

Data

Centervale

population

000

50,000

5,000

75,000

3000

5250

195000 39000 4500 1200 4500

19500

600 2250

97500 19500 2250 600 2250

3000 800 3000

97500

3000 11250

10500

6750

227500 45500 5250 1400 5250

500

9750 2600 9750

6000

42,750

,250

$20,817

65,000

450

300

65,000 13,000 300 400 450

65,000 13,000

400 1,500

6,000

195,000

6,000 22,500

45,000

390,000

9,000 2,400 9,000

260,000 52,000 6,000 1,600 6,000

44,250

13,500

2,250 600 2,250

2 1 0 1

6 3 1 2

3 2 0 1

2 1 0 1

1 0 0 1

																									Independence County	Simon Township		Diamond Township	Taylor Township
Population
				Total																3							5			0	6	7	20,000
Age distribution
	Under 5													1		300	2	600	8
	5 to 9				19500		39000														4	1	200	450
	10 to 14			22	750		45500				5	25	1		400
	15 – 19
	20 –	24					9750				2250
	25 –		29
	30 –	34	130000			26
	35 – 44	487500		11250
	45 – 54	455000	91000		10500			28
	55 – 59	292500	58500		6750	1800
	60 – 64
	65 – 74					422	84500
	75 -100	2		6000	52000	1600
Sex distribution
Male	1,690,000	370,500		42,750	11,400
Female	1,560,000	279,500		3		2,250	8,600	32
Income distribution
Median household income	$43,160	$40,160	$44,890	$41,860	$40,990
Median family income	$45,568	$48,568	$50,568	$49,968	$51,568
Per capita income			$20,8	17	$26,817	$24,817
Racial composition
		Latino	325,000				65,000	7,500		2,400	3,000
		White	2,600,000	520,000			45,000	15,000	46,500
		Black			13,000	21,750	1,000	24,750
		Asian		195,000	3		9,000	1,200
		Other
Population distribution by level of education
Less than 9th grade		1,500
9th to 12th grade, no diploma		260,000		52,000					6,000		1,600
High school graduate, no college	975,000		22,500
Some college through professional degree	1,950,000		390,000	12,000
Education
School Enrollment
Population 3 years and over enrolled in school
Nursery school, preschool	78,000
Kindergarten
Elementary school (grades 1-8)	1,917,500	383,500		44,250	11,800
High school (grades 9-12)	585,000	117,000		13,500	3,600
College or graduate school	97,500	19,500
Day care centers
Elementary schools
Middle schools
High schools
Community college
Health status
Birth rate
Death rate
Life expectancy
Infant mortality rate
Death rate by cause of death
Morbidity rate
Work days lost due to illness
Most common illnesses
Morbidity and mortality due to road accidents
Health services
Number of healthcare professionals
Number of primary care facilities
Number of hospitals
Number of physician practices
Number of nursing homes
Number of pathological laboratories
Number of pharmaceutical companies
Manufacturing
Number of industries
Number of industries by size
Number of industries by sector
Population employed in manufacturing
Average income in manufacturing
Service sector
Number of organizations
Population employed in the service sector
Average income in the service sector

Car Accidents by Age of Driver

Simon Township Diamond Township Taylor Township

2005 2006 2007 2008 2009 2005 2006 2007 2008 2009

Under 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
5 to 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 to 14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
15 – 19 2 3 2 3 5 3 3 3 3 2 4 3 2 4 2
20 – 24 4 4 3 6 8 7 6 5 7 6 5 3 5 3 4
25 – 29 4 2 3 4 3 4 5 6 7 3 3 3 2 4 5
30 – 34 2 4 4 5 4 6 3 5 4 5 5 4 4 4 3
35 – 44 3 2 4 2 4 5 5 3 5 3 5 5 4 4 4
45 – 54 1 3 5 4 3 5 6 3 4 4 6 4 5 3 4
55 – 59 1 5 1 2 1 2 1 3 4 2 1 1 2 3 1
60 – 64 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
65 – 74 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
75 -100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Total 17

22 26 28 32 29 28 34 25 29 23 24 25 23

											2005												2006												2007												2008												2009
		23

Number of walkers

Simon Township Diamond Township Taylor Township
2005 2006 2007 2008 2009 2005 2006 2007 2008 2009 2005 2006 2007 2008 2009

Latino 750

232

White

4232

Black 334

323 322 232 121 232

232

232 442 232 422 442

Asian 345 343

232

323 433 232 533 232 533

343 343

Other 200 322 422 442

121 121 322 423 232 121 323 121

Total

760	670	456					345	421	424	223			423							121		323	134	523					232
	3445				4232		5353	2323		4555						343	334	3423	3232		442				533	322	3334	4343
	332			124			123
	443				433		553			234
	211		212			222
5074	5989	6090	7006	3343	5862	4534	4243	4632	4	432	5442	6564	4535	4452	5582

Number of bicyclists

Simon Township Diamond Township Taylor Township
2005 2006 2007 2008 2009 2005 2006 2007 2008 2009 2005 2006 2007 2008 2009

Latino 345 343 443 433 232 553 323 433 232 533 232 533 234 343 343
White 3445 4232 4232 5353

4555

3423 3232

3334 4343

Black 334 332 323 322 232 121 232 124 232 123 232 442 232 422 442

Asian 232 121 323 121 222 121 232 124 232 123 232 533 234 343 343

Other 200 322 422 442 211 212 121 121 322 423 232 121 323 121 222

Total

4443	3434	3342	4423	5334	3223
4556	5350	5743	6671	5340	5562	4342	4144	4441	4434	5351	6963	4246	4563	5693

Number of bike trails

Simon Township Diamond Township Taylor Township
2005 2006 2007 2008 2009 2005 2006 2007 2008 2009 2005 2006 2007 2008 2009

Total

345

400

345 323

367

323 400 442 432 450

230

367

412

311

389

Sources

City has counties	http://en.wikipedia.org/wiki/New_York_City
Dupont county stats	http://www.muninetguide.com/states/illinois/DuPage.php
Milton township stats	http://www.antrimcounty.org/twp-prof/Milton-Township

http://en.wikipedia.org/wiki/New_York_City

http://www.muninetguide.com/states/illinois/DuPage.php

http://www.antrimcounty.org/twp-prof/Milton-Township

Turn in your highest-quality paper
Get a qualified writer to help you with

“ Assignment 2 ”

Get high-quality paper

Guarantee! All work is written by expert writers!

Still stressed from student homework?

Get quality assistance from academic writers!

Order now