In my current project, I want to compare population and number of households in Tennessee metro areas between 2019 and 2023.
We decided to use MET2013 variable.
When I calculated the number of people and households in each of the available MSAs in both years with MET2013 variable, we find Knoxville MSA (MET2013 == 28940) population and household change between the two years does not fit with ACS results. While both population and households increased in ACS data, Knoxville MSA (MET2013=28940) is showing declining population and households. Using the same code I calculate population and households in both years for other Tennessee Metro areas and I find results directionally consistent with ACS tables.
I also tested MET2023 variable. We are getting the same number of households and people in 2019 and 2023 for all MSAs, except Knoxville. This time (with MET2023), Knoxville is showing a growth (which is correct), but because 2019 population and household values are lower than what we get with MET2013.
Is there something I am missing or misinterpreting.
Thank you
Hulya Arik