Projects
Analytical plan.doc
File contents
Analytical Plan: Nov 07 Hoffman Census
Finish data entry
Data cleaning
Addresses standardized
HHID07 recoded/standardized
Merge Proxy, HH and Visual datasets using HHID07 as standard key
Logic checks:
In proxy data,
the number in age groups should add up to total number in hh
In the HH data,
the number of people in demographic table should add up to the total number in the household
etc…
Recoding and Processing
FHH: females who are heads of the household.
Single FHH: in demographic table, females who are heads of hh and single
Code top problems into categories
Target stats
(Note: Where possible we will try also incorporate 2005 dated from US Census and 2006 RALLY data in the following tables and figures.)
Population/Occupancy
TABLE: Total population
Occupancy rate
Vulnerable Groups
Female-headed households
TABLE: Total number of FHHs
Rate of female headship among all households
Children under five
TABLE: Total number of children under five
Percent who live in FHHs
School age children
TABLE: Total number of school age children
Percent who live in FHH
Percent who are currently enrolled in school
Elderly
TABLE: Total number over 65
Employment rate for over 65
Selected Demographics
Genral
TABLE: Average Age
Average HH size
Race/Ethnicity breakdown
PIE CHARTS: Percent in each age group
MAP: Fuzzy location of Hispanic residents
Age breakdown
BAR CHART: Percent in each age group
Education breakdown
BAR CHART: Percent in each education group, excluding under-18
Employment breakdown
BAR CHART: Percent in each employment group
New Residents
PIE CHART: Lived here pre-K vs. not
PIE CHART: Race ethnicity of new post-K residents only
Owners and renters
PIE CHART: Percent who own vs rent
Needs and Assets
Needs:
TABLE: Ranked list of responses to question 5. This will be qualitative and will require some re-coding.
Priority Services
TABLE: Ranked list of responses to question 12.
Access to services:
TABLE: Question 6 broken down with four columns: service category, % yes % no, %dk
TABLE: Ranked locations where people are accessing services, by service category
Utilization
PIE CHART: Percent aware of a community center in the neighborhood vs. not
PIE CHART: Percent who use existing community center
TABLE: Ranked responses to 7.a.
PIE CHART: Percent who say they would use a center if there was one
Location
PIE CHART: Percent who would use a community center near Broad and Washington vs. not vs. dk
PIE CHART: Percent who would use a community center near Hoffman School/Taylor Park vs. not vs. dk
PIE CHART: Percent who would use a community center near Jackson and Simon Bolivar vs. not vs. dk
PIE CHART: Percent who would prefer another location vs. not vs. dk
TABLE: Ranked responses to 11.a.
Hoffman School
PIE CHART: Percent who feel it is important to open JW Hoffman School vs. not vs. dk
