Good evening,

Using the below Census Population Survey variables, I need to figure out the change in percent Latino for each metarea from year to year, as well as the actual percent for each given year. I plan to use actual percent for that year and the change in percent as IVs for my model.

-year (2010-2019 in one year increments; sample per year)
-metarea (about 370 metropolitan areas that households are assigned to)
-household
-person in household
-Latino (binary variable at the person level)

I attached a preview of my dataset.

Thank you!