demo - c,e,m calculated correctly, but not p and z (wrong total?)

NYCPlanning / db-acs

American Community Survey data processing for Population Fact Finder

4 stars 1 forks source link

demo - c,e,m calculated correctly, but not p and z (wrong total?) #17

Closed SPTKL closed 4 years ago

SPTKL commented 4 years ago

Since in this case, e and m are correct, we probably picked the wrong group total to calculate p and z against. this shows up for both NTA and CT e.g. geoid 5032300 variable PopU18F

p_pop: 40.4 p_mine: 8.9
z_pop: 16.1
z_mine: 3.6

PopU18F = B05003_014 see metadata: https://api.census.gov/data/2017/acs/acs5/groups/B05003.json

B05003_014 => Total!!Female!!Under 18 years B05003_001 => Group total

EricaMaurer commented 4 years ago

percent and percent moe for PopU18F should be calculated off of PopU18_2

SPTKL commented 4 years ago

no, we might need to create a logic that finds the total for the given variable.