The 2025 ACS Data Users Conference will be held on May 29, 2025 (virtual day) and June 3, 2025 (in-person in DC)
American Community Survey Data Users Group
Search for topics, people, or keywords
Sign Up
Log in
Site
Search for topics, people, or keywords
User
Home
Discussion Forum
ACS Resources
Webinars
Conferences
Steering Committee
More
Cancel
Home
Discussion Forum
ACS Resources
Webinars
Conferences
About
More
Cancel
Details
Views
3534 views
Replies
5 replies
Subscribers
543 subscribers
Users
0 members are here
Labels
ACS basics
Related Census Bureau Resources
Related Forum Threads
Median family income question
Bill Byrnes
over 5 years ago
I’m gathering data on median family income in Illinois from 2009 to 2016, using 5-year estimates. Is it appropriate to adjust those numbers for inflation using the consumer price index? The data indicate that incomes have been increasing steadily all that time until I adjust it for inflation to 2016 dollars, at which point it says median family income has been *decreasing* every year. Any help would be greatly appreciated!
Parents
Cliff Cook
over 5 years ago
Bill
If you are trying compare change in income on a one-to-one basis, I'd recommend adjusting any income levels you use to the same point in time. It could be 2016 or it could even be 2018. If you make this adjustment using ACS guidelines for comparing income data, which calls for making adjustments using the CPI-U-RS. You can find details on the Census ACS website. Look under "Comparing ACS Data" and pick the years for the data sets you are using.
However, your plan seems to raise another issue. When you compare 5 year ACS data that is less than 5 years apart there will be overlapping data sets underlying the statistics (eg, 2009-13 and 2011-16 share the data from 2012-13). While the larger sample dampens the effect on the margin of error it also means that you are not really comparing two independent values, and you will see more correlation than you might expect in the figures. This is not to say you should not follow this method. The answer to that question depends on what question you want to answer and who your audience will be. If I were undertaking this type of comparison I would use two non-overlapping 5 year ACS period if the data is available.
Cancel
Up
0
Down
Reply
Cancel
Reply
Cliff Cook
over 5 years ago
Bill
If you are trying compare change in income on a one-to-one basis, I'd recommend adjusting any income levels you use to the same point in time. It could be 2016 or it could even be 2018. If you make this adjustment using ACS guidelines for comparing income data, which calls for making adjustments using the CPI-U-RS. You can find details on the Census ACS website. Look under "Comparing ACS Data" and pick the years for the data sets you are using.
However, your plan seems to raise another issue. When you compare 5 year ACS data that is less than 5 years apart there will be overlapping data sets underlying the statistics (eg, 2009-13 and 2011-16 share the data from 2012-13). While the larger sample dampens the effect on the margin of error it also means that you are not really comparing two independent values, and you will see more correlation than you might expect in the figures. This is not to say you should not follow this method. The answer to that question depends on what question you want to answer and who your audience will be. If I were undertaking this type of comparison I would use two non-overlapping 5 year ACS period if the data is available.
Cancel
Up
0
Down
Reply
Cancel
Children
Bill Byrnes
over 5 years ago
in reply to
Cliff Cook
Thanks for your response! This is really helpful. It seems like I'm learning something new every day about how to properly utilize ACS data. Right now I'm just interested in showing how median family income fluctuates over time. The concern about overlapping data is a valid one. After a little digging on the "Comparing ACS Data" site, it seems that comparing 1-year estimates (i.e., 2013 to 2014, 2014 to 2015, etc.) is not sound because there's some overlap there too. I wonder if I should compare 1-year data from even-numbered years to avoid overlap, and then use the consumer price index to adjust them for inflation?
Cancel
Up
0
Down
Reply
Cancel