Assignment 3: Course Project Task 1—Interpreting Population Data
rlenerulzAUO_PH6012_Centervale_Data.xls
Centervale data
Centervale | Independence County | Simon Township | Diamond Township | Taylor Township | |
Population | |||||
Total population | 190,000 | 650,000 | 75,000 | 20,000 | 95,000 |
Age distribution | |||||
Under 5 | 7600 | 26000 | 3000 | 800 | 3800 |
5–9 | 11400 | 39000 | 4500 | 1200 | 5700 |
10–14 | 13300 | 45500 | 5250 | 1400 | 6650 |
15–19 | 11400 | 39000 | 4500 | 1200 | 5700 |
20–24 | 5700 | 19500 | 2250 | 600 | 2850 |
25–29 | 5700 | 19500 | 2250 | 600 | 2850 |
30–34 | 7600 | 26000 | 3000 | 800 | 3800 |
35–44 | 28500 | 97500 | 11250 | 3000 | 14250 |
45–54 | 26600 | 91000 | 10500 | 2800 | 13300 |
55–59 | 17100 | 58500 | 6750 | 1800 | 8550 |
60–64 | 13300 | 45500 | 5250 | 1400 | 6650 |
65–74 | 24700 | 84500 | 9750 | 2600 | 12350 |
75–100 | 17100 | 58500 | 6750 | 1800 | 8550 |
190000 | |||||
Sex distribution | |||||
Male | 98,800 | 370,500 | 42,750 | 11,400 | 54,150 |
Female | 91,200 | 279,500 | 32,250 | 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 | $20,817 | $26,817 | $24,817 | $20,817 |
Racial composition | |||||
Latino | 19,000 | 65,000 | 7,500 | 2,400 | 3,800 |
White | 152,000 | 520,000 | 45,000 | 15,000 | 58,900 |
Black | 3,800 | 13,000 | 21,750 | 1,000 | 31,350 |
Asian | 11,400 | 39,000 | 450 | 1,200 | 380 |
Other | 3,800 | 13,000 | 300 | 400 | 570 |
Population distribution by level of education | |||||
Less than 9th grade | 3,800 | 13,000 | 1,500 | 400 | 1,900 |
9th to 12th grade, no diploma | 15,200 | 52,000 | 6,000 | 1,600 | 7,600 |
High school graduate, no college | 57,000 | 195,000 | 22,500 | 6,000 | 28,500 |
Some college through professional degree | 114,000 | 390,000 | 45,000 | 12,000 | 57,000 |
Education | |||||
School enrollment | |||||
Nursery school, preschool | 3,800 | 13,000 | 1,500 | 400 | 1,900 |
Kindergarten | 3,420 | 11,700 | 1,350 | 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 | 560 | 2,660 |
Day care centers | 2 | 1 | 0 | 1 | |
Elementary schools | 6 | 3 | 1 | 2 | |
Middle schools | 3 | 2 | 0 | 1 | |
High schools | 2 | 1 | 0 | 1 | |
Community college | 1 | 0 | 0 | 1 |
Car accidents by age of driver
Simon Township | Diamond Township | Taylor Township | |||||||||||||
2005 | 2006 | 2007 | 2008 | 2009 | 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–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 | 232 |
White | 3445 | 4232 | 4232 | 5353 | 2323 | 4555 | 3434 | 3342 | 3423 | 3232 | 4423 | 5334 | 3223 | 3334 | 4343 |
Black | 334 | 332 | 323 | 322 | 232 | 121 | 232 | 124 | 232 | 123 | 232 | 442 | 232 | 422 | 442 |
Asian | 345 | 343 | 443 | 433 | 232 | 553 | 323 | 433 | 232 | 533 | 232 | 533 | 234 | 343 | 343 |
Other | 200 | 322 | 422 | 442 | 211 | 212 | 121 | 121 | 322 | 423 | 232 | 121 | 323 | 121 | 222 |
Total | 5074 | 5989 | 6090 | 7006 | 3343 | 5862 | 4534 | 4243 | 4632 | 4432 | 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 | 4555 | 3434 | 3342 | 3423 | 3232 | 4423 | 5334 | 3223 | 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 | 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 | 400 | 412 | 345 | 323 | 311 | 367 | 389 | 323 | 400 | 442 | 432 | 450 |