1 / 1

Optimizing Census Data Distribution of Traveler Types Using VBA in MS Access

This module outlines the process of reading and manipulating 2010 Census data using VBA macros in MS Access. It covers hardcoded distributions of traveler types based on demographic data, including population by sex and age, household type, and group quarters. The methodology involves populating lists of residents—adults and children—formulating different household sizes, and assigning traveler types according to state statistics. Additionally, resident income brackets are assigned and stored in a CSV file to facilitate analysis. This structured approach enhances data usability and insight into household dynamics.

viveka
Télécharger la présentation

Optimizing Census Data Distribution of Traveler Types Using VBA in MS Access

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Module 1 • Read-in Census Data • Hardcoded distribution* of Traveler Types • 2010 Census Summary File 1 • P12 Pop. By Sex by Age • P16 Pop. Over/Under 18 by Sex • H13 HH Size • P29 HH Type by Relationship • P43 Group Quarter • Using VBA macro in MS Access on raw SF1 file • Populate lists of male and female, adults and children • Form all households (HH) of different sizes and types. • Assign a Traveler Type to every resident • Populate all Group Quarters (GQ) in Census Block. • Iterate over # of HH of each size • Choose Fam or Non-Fam HH • Choose main Hhersex • Draw remaining members from HH relations distribution • Iterate over # of people of each age ranges of each sex • Uniformly distributed ages in ranges • Iterate over # of people in each GQ by age and sex • Preset Traveler Type for those whose GQ determines it. • Based primarily on age and HH type • Distribution based on statewide stats of employment and enrollment Legend: • Write these attributes to a CSV, the NJ Resident File • Assign an Income Bracket to each Working Resident Parsing text data Read • HH income sampled first with dollar amount • Then divided among workers in HH • Converted to Bracket indicators Ext. data External data • Each resident is given a unique person ID • Each resident also given a household ID • Household members have the same HH ID and are in consecutive rows • Read-in Household Income Data Process Process Titles • Family Household Incomes • Non-Family Household Incomes Descr. Brief Process Description • Family and Non-Family fields only • Only estimates, not margins of error • 2010 ACS 5 YR

More Related