When looking through your project I noticed that in the “Further Analysis” section you misinterpreted the
population_growth field. If I am correct, this is a percentage.
I will use the output of the query in this section to provide examples. Focusing on the India record first, you interpreted the
population_growth (a value of 1.22 for India) as meaning a 22% increase in the population. In reality, the population only increased by 1.22%. This means that your calculation should have looked more like the following:
new_population = old_population + (old_population * 0.0122)
new_population = old_population * 1.0122.
This is why you have some very large numbers for
pop_diff. In your calculations the population in both Ethiopia and Iraq nearly tripled in size; for Uganda it more than tripled.
You may have already caught this but I figured I should comment on it in case you haven’t.