Course Project Task 1—Interpreting Population Data
Scenario:
Some population data from the Centervale project are on the spreadsheet, which you can download. In order to quickly and clearly understand the population you will be working with, you should put the data in graphic format.
Directions:
- Produce graphs for each of the three townships and for the county so we visualize similarities and differences in population distribution, sex distribution, income, racial composition, educational achievement, and schools. Label each graph.
- Write a paragraph about each demographic and speculate on how the distributions might be related to health measurements.
Be sure to save a copy of your work!
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_M1_A3 .
By the due date assigned, deliver your assignment to the Submissions Area.
Assignment 3 Grading Criteria
Assignment 3 Grading CriteriaMaximum PointsProduce a graph for the first township of the county to visualize the similarities and differences in population distribution, sex distribution, income, racial composition, educational achievement, and schools.20Produce a graph for the second township of the county to visualize the similarities and differences in population distribution, sex distribution, income, racial composition, educational achievement, and schools.20Produce a graph for the third township of the county to visualize the similarities and differences in population distribution, sex distribution, income, racial composition, educational achievement, and schools.20Write a paragraph about each demographic and speculate on how the distributions might be related to health measurements.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
> data
Centervale population
9 ,000
0,000
5,000
00
0
00
0
00
0
00
0
0
0
1 39000 4500 1200 5700 5700 50
600 50
5700 19500 2250 600 2850 0
26000 3000 800 3800 0
3000 13300 100
13300 45500 5250 1400 6650 9750 2600 50
17100 58500 6750 1800 8550 ,250
$20,817 $20,817 3,800 11,400 450 1,200 380 3,800 13,000 300 400 570 3,800 13,000 400 52,000 6,000 45,000 57,000 3,800 13,000 1,500 400 1,900 1,350 560 2 1 0 1 6 3 1 2 3 2 0 1 2 1 0 1 1 0 0 1 2005 2006 2007 2008 2009 2005 2006 2007 2008 2009 232 4232 4
2
3
4
3
323 322 232 121 232 232 232 442 232 442 232 323 433 232 533 232 533 343 343 121 121 322 423 232 121 323 121 4555 3423 3232 3334 4343 Black 334 332 323 322 232 121 232 124 232 123 232 442 232 422 442 Other 200 322 422 442 211 212 121 121 322 423 232 121 323 121 222 400 345 323 367 323 400 442 432 450
2
Centervale
Independence County
Simon Township
Diamond Township
Taylor Township
Population
Total
1
0
6
5
7
20,000
95,000
Age distribution
Under 5
7
600
26
3
8
380
5–9
1
1
4
39000
450
1
200
570
10–14
13300
45500
5
25
400
6650
15–19
11400
20–
24
19500
22
28
25–
29
30–
34
760
35–44
28500
9
750
11250
14250
45–54
26600
91000
10500
2800
55–59
17
58500
6750
1800
8550
60–64
65–74
24700
84500
1
23
75–100
190000
Sex distribution
Male
98,800
370,500
42,750
11,400
54,150
Female
9
1,200
279,500
32
8,600
40,850
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,817
$26,817
$24,817
Racial composition
Latino
19,000
65,000
7,500
2,400
3,800
White
1
52,000
520,000
45,000
15,000
58,900
Black
13,000
21,750
1,000
3
1,350
Asian
39,000
Other
Population distribution by level of education
Less than 9th grade
1,500
1,900
9th to 12th grade, no diploma
15,200
6,000
1,600
7,600
High school graduate, no college
57,000
195,000
22,500
28,500
Some college through professional degree
114,000
390,000
12,000
Education
School enrollment
Nursery school, preschool
Kindergarten
3,420
11,700
360
1,710
Elementary and middle school (grades 1–8)
22,
230
76,050
8,775
2,340
11,115
High school (grades 9–12)
9,120
31,200
3,600
960
4,
560
College or graduate school
5,320
18,200
2,100
2,660
Day care centers
Elementary schools
Middle schools
High schools
Community college
Car accidents by age of driver
Simon Township Diamond Township Taylor Township
2005
2006
2007
2008
2009
Under 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
5–9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10–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 23 22 26 28 32 29 28 34 25 29 23 24 25 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 760
670
456
345
421
424
223
423
121
323
134
523
232
White
3445
4232
5353
2323
4555
343
334
3423
3232
442
533
322
3334
4343
Black 334
332
124
123
422
Asian 345 343
443
433
553
234
Other 200 322 422 442
211
212
222
Total
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
4443
3434
3342
4423
5334
3223
Asian 232 121 323 121 222 121 232 124 232 123 232 533 234 343 343
Total
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 230 345
367
412
311
389