I've recently come across this coding exercise but as I've just started learning R, I'm not sure how to solve these. Below is my dataset screenshot,
Below are the queries,
a. What regions have the maximum and minimum total Indigenous populations(given in column 'Value') in 2016 and 2031?
b. What region/s have the maximum and minimum growth or decay rates of their total Indigenous population between 2016 and 2031?
Calculate these rates as the percentage difference between the 2016 and 2031,
e.g., if 2031 population = 5500 & 2016 population = 5000, then rate = (5500 – 5000) / 5000 = 500/5000 = 0.1, so 10% growth
Can anyone help me out with these?