Income based on vehicle ownership?

Hi team: long-time viewer, first time poster. I've been scratching my head about this one all day - I'm simply looking to find a table (or some method) that would allow me to calculate the median household income for a given geography (preferably counties) by vehicle ownership. I've spent at least an hour running through different ACS tables, with no luck. Is this something I'll have to use PUMS for instead? Any guidance would be greatly appreciated.

Parents
  • Mo:

    The answer is to use the PUMS. The best way to do this (IMHO) is by using the IPUMS USA (https://www.ipums.org/)  at the University of Minnesota. It's free to register. This is the fastest/best/amazing way to access PUMS data (IPUMS is pronounced eh-pums).

    I did a tabulation on median household income by vehicle availability level for the NATION using the 2019 ACS. It took a few seconds to run. Honestly.

    Go to www.ipums.org

    Go to the IPUMS USA sub-site https://usa.ipums.org/usa/  register for free, of course!!

    Click the link to "Online Tool for Analysis" (This is the Survey Data Analysis package developed at UC Berkeley)

    Click on "Use data from a single sample" -  I chose the "2019 ACS"

    Click on the "Means" tab on the right side of the SDA analysis page.

    Fill in the forms:

    DEPENDENT: HHINCOME (The variable that I want means and medians!)

    row variable: vehicles(r:9 "No Vehicles"; 1 "One Vehicle"; 2 "Two Vehicles"; 3-8 "Three of More Vehicles") - this is my recode for the VEHICLES variable.

    selection filter(s): pernum(1) (this restricts the analysis to the 1st person in each household, the householder)

    weight: hhwgt - household weight

    Click ON the checkboxes for the "median/percentile" options

    Run it. Wait a few seconds for a new browser tab to appear!

    To limit your analysis to your state, region, county, I would either use counties in the column variable, or state/counties in the "selection filter" box. Here's an example of filtering by counties for the SF Bay Area.

    for column variable: countyfip(r: 1 "Alameda"; 13 "Contra Costa"; 41 "Marin"; 55 "Napa"; 75 "San Francisco"; 81 "San Mateo"; 85 "Santa Clara"; 95 "Solano"; 97 "Sonoma")

    and restrict it to California households: selection filter(s): pernum(1),statefip(6)

    Wish I could post screenshots!

    Results for the USA:

    0 vehicle households: $22,000 median HH income; $46,213.81 mean household income, 10,575,965 total households.

    1 vehicle households: $40,100 median; $58,690.40 mean; 39,803,758 households

    2 vehicle households: $80,000 median; $106,236.20 mean; 45,268,831 households

    3+ vehicle households: $104,000 median; $132,347.06 mean; 27,154,350 households

    TOTAL households: $62,930 median HH income; $91,429.77 mean household income; 122,802,904 total households.

    Hope I didn't screw it up.

    Chuck

Reply
  • Mo:

    The answer is to use the PUMS. The best way to do this (IMHO) is by using the IPUMS USA (https://www.ipums.org/)  at the University of Minnesota. It's free to register. This is the fastest/best/amazing way to access PUMS data (IPUMS is pronounced eh-pums).

    I did a tabulation on median household income by vehicle availability level for the NATION using the 2019 ACS. It took a few seconds to run. Honestly.

    Go to www.ipums.org

    Go to the IPUMS USA sub-site https://usa.ipums.org/usa/  register for free, of course!!

    Click the link to "Online Tool for Analysis" (This is the Survey Data Analysis package developed at UC Berkeley)

    Click on "Use data from a single sample" -  I chose the "2019 ACS"

    Click on the "Means" tab on the right side of the SDA analysis page.

    Fill in the forms:

    DEPENDENT: HHINCOME (The variable that I want means and medians!)

    row variable: vehicles(r:9 "No Vehicles"; 1 "One Vehicle"; 2 "Two Vehicles"; 3-8 "Three of More Vehicles") - this is my recode for the VEHICLES variable.

    selection filter(s): pernum(1) (this restricts the analysis to the 1st person in each household, the householder)

    weight: hhwgt - household weight

    Click ON the checkboxes for the "median/percentile" options

    Run it. Wait a few seconds for a new browser tab to appear!

    To limit your analysis to your state, region, county, I would either use counties in the column variable, or state/counties in the "selection filter" box. Here's an example of filtering by counties for the SF Bay Area.

    for column variable: countyfip(r: 1 "Alameda"; 13 "Contra Costa"; 41 "Marin"; 55 "Napa"; 75 "San Francisco"; 81 "San Mateo"; 85 "Santa Clara"; 95 "Solano"; 97 "Sonoma")

    and restrict it to California households: selection filter(s): pernum(1),statefip(6)

    Wish I could post screenshots!

    Results for the USA:

    0 vehicle households: $22,000 median HH income; $46,213.81 mean household income, 10,575,965 total households.

    1 vehicle households: $40,100 median; $58,690.40 mean; 39,803,758 households

    2 vehicle households: $80,000 median; $106,236.20 mean; 45,268,831 households

    3+ vehicle households: $104,000 median; $132,347.06 mean; 27,154,350 households

    TOTAL households: $62,930 median HH income; $91,429.77 mean household income; 122,802,904 total households.

    Hope I didn't screw it up.

    Chuck

Children
No Data