# Trying to match ftotval and hhincome to published income data from the Census **URL:** \ **Category:** CPS\ **Created:** [July 19, 2023, 4:31pm UTC](https://forum.ipums.org/t/trying-to-match-ftotval-and-hhincome-to-published-income-data-from-the-census/5379 "2023-07-19T16:31:14Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Christian\_Weller](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/christian_weller/32/428_2.png) [@Christian\_Weller](https://forum.ipums.org/u/Christian_Weller)\ **Post date:** [July 19, 2023, 4:31pm UTC](https://forum.ipums.org/t/trying-to-match-ftotval-and-hhincome-to-published-income-data-from-the-census/5379/1 "2023-07-19T16:31:14Z")
I am sure I am making an elementary mistake, but when I calculate the median and mean of ftotval, it is a lot lower than the mean and median family income from the Census and vice versa the mean and median for hhincome are much higher than what the Census tables show. I am comparing nominal values to the published tables for 2021, so deflation is not a factor (I think). I am also using asecwt. Any pointers on what I may be missing? Thanks. ---
**Author:** ![Christian\_Weller](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/christian_weller/32/428_2.png) [@Christian\_Weller](https://forum.ipums.org/u/Christian_Weller)\ **Post date:** [July 19, 2023, 5:59pm UTC](https://forum.ipums.org/t/trying-to-match-ftotval-and-hhincome-to-published-income-data-from-the-census/5379/2 "2023-07-19T17:59:12Z")
I figured out my mistake. Sorry to bother you. ---
**Author:** ![Evan\_Wasner](https://avatars.discourse-cdn.com/v4/letter/e/b782af/32.png) [@Evan\_Wasner](https://forum.ipums.org/u/Evan_Wasner)\ **Post date:** [February 19, 2024, 4:52pm UTC](https://forum.ipums.org/t/trying-to-match-ftotval-and-hhincome-to-published-income-data-from-the-census/5379/3 "2024-02-19T16:52:41Z")
Hello @Christian_Weller, are you able to please explain the mistake you made and how you resolved this problem? I am a very novice user of IPUMS CPS data and am having the same issue. I pulled HHINCOME, took a simple median, and for year 2022 (survey year 2023) the value is $91,200, whereas in the Census report “Income in the United States: 2022”, nominal median household income for 2022 was $74,580. I’m sure my mistake is also extremely elementary… ---
**Author:** ![Christian\_Weller](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/christian_weller/32/428_2.png) [@Christian\_Weller](https://forum.ipums.org/u/Christian_Weller)\ **Post date:** [February 19, 2024, 5:12pm UTC](https://forum.ipums.org/t/trying-to-match-ftotval-and-hhincome-to-published-income-data-from-the-census/5379/4 "2024-02-19T17:12:36Z")
I used all observations instead of just one per household. That was my biggest error if I remember correctly. I think I also used the wrong weight. I think it should be asecwth. ---
**Author:** ![Isabel\_Pastoor](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/isabel_pastoor/32/788_2.png) [@Isabel\_Pastoor](https://forum.ipums.org/u/Isabel_Pastoor)\ **Post date:** [February 19, 2024, 6:06pm UTC](https://forum.ipums.org/t/trying-to-match-ftotval-and-hhincome-to-published-income-data-from-the-census/5379/5 "2024-02-19T18:06:19Z")
Hi Evan. Like Christian stated, when performing analyses of household level variables, such as HHINCOME, you should exclude your analysis to just one person per household. You can do this easily by filtering PERNUM=1. You also need to use a household weight for household level analyses. The household weight for the ASEC is [ASECWTH](https://cps.ipums.org/cps-action/variables/ASECWTH#codes_section). We also offer [replicate weights](https://cps.ipums.org/cps/repwt.shtml#:~:text=In%20IPUMS%20testing%20of%20CPS,coefficients%20may%20become%20clearly%20nonsignificant.) to use with ASEC data, which are necessary for estimating empirically derived standard errors or confidence intervals. ---
**Author:** ![Evan\_Wasner](https://avatars.discourse-cdn.com/v4/letter/e/b782af/32.png) [@Evan\_Wasner](https://forum.ipums.org/u/Evan_Wasner)\ **Post date:** [February 19, 2024, 7:57pm UTC](https://forum.ipums.org/t/trying-to-match-ftotval-and-hhincome-to-published-income-data-from-the-census/5379/6 "2024-02-19T19:57:57Z")
Thank you very much! That is very helpful, and this resolves the issue.