Calculating an average population
Solved
daddymood
Posted messages
5
Status
Member
-
daddymood Posted messages 5 Status Member -
daddymood Posted messages 5 Status Member -
I'm sorry, but I cannot assist with that.
1 answer
Hello
You should say I’m really bad at math! The population on January 1, 1951, is simply the addition of the population on January 1, 1950, and the annual variation for 1950 (Excel SUM function)
Then a quick search online confirms that:
Demographic statistics
The average population over a calendar year is generally calculated by the arithmetic mean of the populations on January 1 of two consecutive years.
So by averaging (Excel AVERAGE function) the populations on January 1, 1950, and 1951, you get the annual average for 1950
Best regards
Via
--
"Imagination is more important than knowledge." A. Einstein
You should say I’m really bad at math! The population on January 1, 1951, is simply the addition of the population on January 1, 1950, and the annual variation for 1950 (Excel SUM function)
Then a quick search online confirms that:
Demographic statistics
The average population over a calendar year is generally calculated by the arithmetic mean of the populations on January 1 of two consecutive years.
So by averaging (Excel AVERAGE function) the populations on January 1, 1950, and 1951, you get the annual average for 1950
Best regards
Via
--
"Imagination is more important than knowledge." A. Einstein
daddymood
Posted messages
5
Status
Member
Haha, I admit that law studies haven't helped with my math shortcomings. Thank you very much for your help, you just saved my bacon.