2022 Population Decrease in 2018-2022 5-Year?

I'm seeking to create a map which overlays 2022 MIGPUMAs onto 2018-2021 and provides weighting for overlapping boundaries. In preparing this, I've noticed that both the total population and number of employed persons in 2022 is lower than previous years. Ideally, my weighting would be the sum of 'PWGTP' for 2022 divided by the sum of 'PWGTP' for all years, but those values are surprising:

Calculation for figures below: sum('PWGTP') * 5 for each year

pop_2018 = 330,392,650
pop_2019 = 330,778,030
pop_2020 = 335,532,750
pop_2021 = 335,754,690
pop_2022 = 323,029,850

same calculation but with employed persons:

2018: 159,018,450
2019: 160,511,725
2020: 157,185,140
2021: 158,912,185
2022: 157,184,160

My gut tells me to use the sum of 'PWGTP' for each year for weighting, since those will be how my variables are weighted, but it feels odd given 2022 certainly had a higher population and labor force than previous years.

Does anyone have advice? My goal is to create a 5-year average, just like the data prescribes. It will be one one map though, and I'm not sure how much to weight my averages for 2022.

Parents Reply Children