Hello, I am looking at ACS data to see how several variables (population, visitation, migration rate, rate of seasonal residence etc) impact GINI index in two sets of communities.
I am planning to do an ANOVA with the variables listed above as the independent variables and GINI index as independent. However, I would like to use the growth rate for each year for this analysis.
How do you compute growth rate version of a variable you currently have? For each town I have information on all of the variables from 2010 to 2019. It is easy to average the growth rate in excel (mean of community group 1 population 2011- mean of community group 1 population 2010/ mean of community group 1 population 2010). But I need to find a way to do this SPSS.
Using population as an example (Here I just included 2 towns but in reality I have 3.901 towns):
Community Name Year Population GINI My question: Population yearly growth rate GINI yearly growth rate
Smithtown 2010 21,000 .46
Smithtown 2011 22,551 .47
Smithtown 2012 20,543 .46 etc continuing to 2019
Joetown 2010 5,000 .45
Joetown 2011 4,900 .47 etc continuing to 2019
------------------------------
Elizabeth Depew
------------------------------
#SPSSStatistics