r – How to calculate the total proportional change in abundance?

I am now dealing with the analysis of a long term bird survey, that was conducted every 3 years since 2004. For each species, I have calculated the mean abundance per year. Next, I am trying to check for each species, the trends in estimated abundance – if there is any increase or decrease in the abundance over the total study period (and not between year A and year B). Actually, I want to calculate the total change in estimated abundance over the entire study (Total proportional change). Does anyone know how to do it using R studio?

I thought about doing something like this:

((Abundance in the last year – Abundance in the first Year) / Abundance in the first year)

is it the correct approach?

Here is an exmaple for the data:

bird_data <- data.frame( Year = c(2004, 2007, 2010, 2013, 2017, 2020, 2023), mean_abundance = c(100, 110, 120, 130, 140, 150, 160), se = c(5, 6, 7, 8, 9, 10, 11) )

Read more here: Source link