Income measures compared to ACS

Here are the steps I took to get per capita income for 4 PUMAs. These steps resulted in 3 out of 4 PUMA’s per capita income within the margin of published error.

ROW: inctot

SELECTION FILTER: met2013(41180) PUMA (1804)

WEIGHT: perwt

Copy result into Excel

Multiply 2 columns (Labeled N * Distribution)

Exclude the N value 9999999

Total the calculated column

Divide by total distribution (Which equals the population for the PUMA)

If this is correct, I would like to rerun with an added filter selection for raced (610)

I would also like to estimate a measure of household income, but don’t understand how to do it using the online tool. This post makes me think I can’t: Matching ACS median household income?

D